Guides
Each guide is one job, the formula that does it, and real outputs from the model. Copy the formula, change the question, point it at your column. The reference covers every argument.
Google Sheets
- Sentiment analysis in Google Sheets with one formula Sentiment
- Lead scoring in Google Sheets without a CRM Lead scoring
- Categorize support tickets in a spreadsheet Ticket triage
- Code open-ended survey responses in Google Sheets Survey coding
- Classify text into categories with a Google Sheets formula Classification
- Tag customer reviews by topic in Google Sheets Review tagging
- REGEXMATCH vs asking a question REGEXMATCH vs a question
- Score ICP fit for a lead list in Google Sheets ICP fit
- Find urgent customer emails in a spreadsheet Urgency
- AI formulas for Google Sheets: what returns a number, what returns text AI formulas compared
- Categorize expenses in Google Sheets Expense categorization
- Classify job titles in Google Sheets Job titles
- Classify cold email replies in Google Sheets Cold email replies
- Classify keyword intent in Google Sheets Keyword intent
- Analyze NPS comments in Google Sheets NPS comments
- Analyze app store reviews in Google Sheets App reviews
- Detect spam form submissions in Google Sheets Spam detection
- Categorize products in Google Sheets Product categorization
Excel
- Sentiment analysis in Excel with one formula Sentiment
- Text classification in Excel with a formula Classification
- Categorize bank transactions in Excel Transactions
- Lead scoring in Excel without a CRM Lead scoring
- Categorize support tickets in Excel Ticket triage
- Analyze open-ended survey answers in Excel Survey coding
- AI formulas in Excel that return a number AI formulas
Run it on your own column
Copy the template (or use the Excel add-in), paste your key, point the formula at your data. Every formula here has its Excel spelling underneath. 100 rows free to start, then $29 for 5,000 rows. Credits never expire and there is no subscription.