# 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](https://hunchsheet.app/docs) covers every argument. ## Google Sheets - [Sentiment analysis in Google Sheets with one formula](https://hunchsheet.app/formulas/sentiment-analysis-google-sheets.md): Score review or feedback sentiment on a five-level scale with =HUNCHSCORE, then count per level with COUNTIF. Real outputs on six reviews. - [Lead scoring in Google Sheets without a CRM](https://hunchsheet.app/formulas/lead-scoring-google-sheets.md): Two formulas turn lead notes into a ranked list: a decision-maker probability and an ICP fit score. Real outputs on eight leads, then SORT with a threshold. - [Categorize support tickets in a spreadsheet](https://hunchsheet.app/formulas/categorize-support-tickets-spreadsheet.md): Export tickets, add three formulas: urgency, category, frustration. Real outputs on seven tickets and why the "other" option is mandatory. - [Code open-ended survey responses in Google Sheets](https://hunchsheet.app/formulas/code-open-ended-survey-responses.md): One yes/no column per theme plus one pick column for the primary theme. Real outputs on six churn-survey answers, then QUERY for the summary table. - [Classify text into categories with a Google Sheets formula](https://hunchsheet.app/formulas/classify-text-google-sheets-formula.md): The general pattern for =HUNCHPICK: write options, describe them after a colon, add other, choose between one pick column and several yes/no columns. Real outputs on article titles. - [Tag customer reviews by topic in Google Sheets](https://hunchsheet.app/formulas/tag-customer-reviews-google-sheets.md): Topic and sentiment as two columns on a review export, then a pivot on both. Real outputs on six reviews. - [REGEXMATCH vs asking a question](https://hunchsheet.app/formulas/regexmatch-vs-asking-a-question.md): Side by side on five real tickets: a refund keyword match misses two refund requests and flags one non-request. When to use each, and how to combine them. - [Score ICP fit for a lead list in Google Sheets](https://hunchsheet.app/formulas/icp-fit-score-spreadsheet.md): Write your ideal customer profile as one sentence, put it in a =HUNCHSCORE formula, and every lead gets a 0–3 fit. Real outputs and how to re-score when the ICP changes. - [Find urgent customer emails in a spreadsheet](https://hunchsheet.app/formulas/find-urgent-customer-emails-spreadsheet.md): One question with the definition of urgent inside it, a probability per row, conditional formatting and a daily FILTER view. Real outputs on seven messages. - [AI formulas for Google Sheets: what returns a number, what returns text](https://hunchsheet.app/formulas/ai-formulas-google-sheets-number-or-text.md): Chat-style AI functions return prose in a cell. Hunch returns a probability, an option or a level, priced per row, no install. What each is for and what Hunch cannot do. - [Categorize expenses in Google Sheets](https://hunchsheet.app/formulas/categorize-expenses-google-sheets.md): Turn a bank or card export into budget categories with =HUNCHPICK, one label per row. Real outputs on fifteen transactions, then SUMIF and QUERY for totals. - [Classify job titles in Google Sheets](https://hunchsheet.app/formulas/classify-job-titles-google-sheets.md): Rate seniority with =HUNCHSCORE and pick a department with =HUNCHPICK, both from one messy job title column. Real outputs on fifteen titles from a CRM export. - [Classify cold email replies in Google Sheets](https://hunchsheet.app/formulas/classify-cold-email-replies-google-sheets.md): =HUNCHPICK sorts cold email replies into interested, not now, wrong person, unsubscribe, or out of office, plus a pricing flag. Real outputs on 15 replies. - [Classify keyword intent in Google Sheets](https://hunchsheet.app/formulas/keyword-intent-google-sheets.md): =HUNCHPICK sorts keywords into informational, commercial, transactional, or navigational intent, plus a branded-query flag. Real outputs on fifteen keywords. - [Analyze NPS comments in Google Sheets](https://hunchsheet.app/formulas/nps-comment-analysis-google-sheets.md): =HUNCHMULTI asks several yes/no questions per NPS or CSAT comment, one column each. Real outputs on fourteen comments, then COUNTIFS by score band. - [Analyze app store reviews in Google Sheets](https://hunchsheet.app/formulas/app-review-analysis-google-sheets.md): =HUNCHPICK splits app reviews into bug report, feature request, praise, or pricing complaint, then =HUNCHSCORE rates severity. Real outputs on fourteen reviews. - [Detect spam form submissions in Google Sheets](https://hunchsheet.app/formulas/detect-spam-form-submissions-google-sheets.md): =HUNCH scores the probability a form submission is spam, a fake signup, or a low-quality lead. Real outputs on fifteen submissions and where to set a threshold. - [Categorize products in Google Sheets](https://hunchsheet.app/formulas/categorize-products-google-sheets.md): =HUNCHPICK maps product titles to your category taxonomy, plus a confidence score to flag rows for review. Real outputs on fifteen product titles. ## Excel - [Sentiment analysis in Excel with one formula](https://hunchsheet.app/formulas/sentiment-analysis-excel.md): Sentiment analysis in Excel with =HUNCH.SCORE, a five-level scale you can sort and count, plus a complaint flag. Real model outputs on eight reviews. - [Text classification in Excel with a formula](https://hunchsheet.app/formulas/classify-text-excel.md): Classify text in Excel with =HUNCH.PICK: choose a category from your list, add other, and get a confidence number to find the rows worth checking. - [Categorize bank transactions in Excel](https://hunchsheet.app/formulas/categorize-bank-transactions-excel.md): Categorize bank transactions in Excel with =HUNCH.PICK, turning raw card descriptions into budget categories while amounts and dates stay in normal formulas. - [Lead scoring in Excel without a CRM](https://hunchsheet.app/formulas/lead-scoring-excel.md): Score leads in Excel with two formulas: =HUNCH.ASK for who can buy, =HUNCH.SCORE for ICP fit, then SORTBY and FILTER to rank the list by both at once. - [Categorize support tickets in Excel](https://hunchsheet.app/formulas/categorize-support-tickets-excel.md): Categorize support tickets in Excel: category and urgency with two formulas, then =HUNCH.MULTI for refund, churn and blocker flags on the same row. - [Analyze open-ended survey answers in Excel](https://hunchsheet.app/formulas/analyze-survey-responses-excel.md): Analyze open-ended survey answers in Excel with =HUNCH.MULTI: one yes/no column per theme on the same response, then COUNTIF or a PivotTable on the results. - [AI formulas in Excel that return a number](https://hunchsheet.app/formulas/ai-formulas-excel.md): An overview of Hunch's four Excel formulas that return a probability, an option or a level instead of generated text, with a guide linked for each one.