Turn a list of companies into a first draft of their strengths, weaknesses, opportunities and threats. Use the template below with the AI for Sheets add-on, fill in your companies, then review the suggested points before using them.
Start here: Open the template in Google Sheets, then choose File → Make a copy to work in your own sheet. Install and authorize AI for Sheets before running the formula; see the setup guide if you’re new.
Sheet setup
Keep the headers in A2:E2 and enter your companies from A3 downwards. Row 1 is the template’s instruction row. If you build your own sheet, use the same row numbers so the formula reads the right cells.
| Company | Strengths | Weaknesses | Opportunities | Threats |
|---|---|---|---|---|
| Apple | ||||
| Microsoft | ||||
| Amazon | ||||
| Meta |
Formula
Put this in B3, then copy right to E3 to try one company. Review that row before filling down for the rest.
It reads the category from the header (e.g., B$2) and the company from column A (e.g., $A3).
=AISEARCH("For a business strategy SWOT analysis of " & $A3 & ", list 3 " & B$2 & ". Use internal factors for strengths and weaknesses, and external market factors for opportunities and threats. Do not list job openings or career opportunities. Use 3 short numbered points.")
This asks for business opportunities, not job opportunities. It uses AISEARCH for web-based answers, but the results still need checking.
Review before you use it: try one company first. Check each point against reliable, recent sources and remove anything vague, outdated or about the wrong company. Once you’re happy with the approach, fill down for the rest of your list. Treat the output as a starting point for analysis, not a finished business assessment.