Hunch
AI formula for Google Sheets. Score, tag, classify any column.
Type =HUNCH(A2, "Is this lead a decision maker?"), drag it down, and every row gets an answer: a probability, a category, or a score. It runs inside the sheet you already have.
One credit per row, no subscription, no card for the trial. Blank cells and repeated texts are free. Also for Excel and CSV files, same key.
| Row | A | B |
|---|---|---|
| 1 | Lead notes | Decision maker? |
Three formulas, plus one for whole rubrics.
Each one asks Hunch a question about the text in a cell. You write the question in plain English and decide what shape the answer takes.
| Formula | Returns | Use it for |
|---|---|---|
| =HUNCH(A2, "Is this lead a decision maker?") | 0.91 | A probability from 0 to 1 that the answer is yes. Filter, sort, or conditional-format on it. |
| =HUNCHPICK(A2, "billing|refund|bug|other") | "refund" | One option from your list. Add an other option when nothing may fit. Describe an option with a colon: "bug: something is broken". |
| =HUNCHSCORE(A2, "ICP fit: B2B SaaS, 20–500 staff", "no fit|weak|good|perfect") | 2.7 | A position along levels you define, low to high. Add "label" as the last argument to get the level's name instead. |
| =HUNCHMULTI(A2:A500, C1:F1) | 4 columns | Several yes/no questions about the same text in one go. Put one question per header cell; each gets a probability column. Text is read once, so a four-question rubric costs four credits a row, not four calls. |
Three steps, about two minutes.
The template is a normal Google Sheet with the formulas built in. Your key lives in one cell of your copy, and the credits belong to that key.
Copy the template
Open it, then File › Make a copy. It brings the formulas, a Hunch menu, and two demo sheets with real data.
Paste your key
The payment page shows a key that starts with hunch_. Paste it into the Settings sheet, cell B2.
Type a formula
In any cell: =HUNCH(A2, "…"). Drag it down, or point it at a whole range: =HUNCH(A2:A500, "…").
Big jobs: select the column, then Hunch menu › Ask about selection. It writes plain values, no formulas, up to about 20,000 rows per run. When a column is final, Hunch menu › Freeze selection to values keeps it from ever recalculating.
Any text column you already have.
Copy a formula, change the question, point it at your data.
Lead lists
=HUNCH(D2, "Can this person approve a purchase for their team?")Review sentiment
=HUNCHSCORE(B2, "How does the reviewer feel about the product?", "angry|disappointed|neutral|happy|delighted", "label")Support triage
=HUNCHPICK(C2, "billing|bug|how-to question|feature request|other")Survey coding
=HUNCH(E2, "Does this answer mention price as a reason for leaving?")Resume screening
=HUNCHSCORE(B2, "Hands-on experience with distributed systems in production", "none|mentions it|has shipped it|leads teams that do", "index")Content tagging
=HUNCHPICK(A2, "tutorial|news|opinion|product update|other", "What kind of article is this?")
Pay per row. Nothing recurring.
One row is one credit. Blank cells, repeated texts, and recalculation within six hours are free. Credits never expire. No refunds once a key is issued, so start with the free 100 rows below.
Payments go through Stripe, on this site or on Stripe's hosted page. Your key appears on the confirmation page right after paying. Save it, since it is the only thing that ties credits to your sheet.
Questions
What is answering the question?
Jev, a model made by TypeSafe. It does not write text. It reads yours and returns a calibrated judgment: how likely the answer is yes, which of your options fits, or where on your scale the text lands. So the cell gets a number you can sort and filter.
Where does my data go?
The text in the cells you point a formula at is sent to our server and on to TypeSafe to compute the answer. We keep no copy of your text. We store your key, its credit balance, and the email from your purchase. TypeSafe states that it does not train on customer requests. Details on the privacy page.
What is it bad at?
Math, counting, and comparing dates. Keep those in normal formulas and give Jev the judgment part. English works best; other languages work with lower accuracy. Vague questions get vague probabilities: "ICP fit" alone means nothing, "ICP fit: B2B SaaS, 20–500 staff, US or EU" means something.
Will it spend credits every time the sheet recalculates?
No. Results are cached for six hours, so edits elsewhere in the sheet do not cost anything. For columns that are done, use Hunch menu › Freeze selection to values. Then they are plain values forever.
Can my team use it?
Yes. The key lives in the Settings sheet of your copy, so anyone you share that sheet with uses the same credits. For a second sheet, copy the template again and paste the same key.
Is there a free trial?
Yes. The form under the prices sends a key with 100 rows to your email, one per address, no card. It works in the template, in Excel and in the CSV runner. When it runs out, buy the Starter pack and paste the new key; the trial key cannot take top-ups.
Refunds?
None. A key is issued the moment payment clears and credits never expire, so there is nothing to give back. Use the 100 free rows on your own data first. If a formula fails on our side, the row is not charged. If something looks wrong, write to us with the first eight characters of your key.
Does it work in Excel?
Yes. Hunch for Excel is a small add-in file you upload to Excel on Windows, Mac or the web: =HUNCH.ASK, =HUNCH.PICK, =HUNCH.SCORE, =HUNCH.MULTI, same key and credits. No spreadsheet at all? The CSV runner scores a file in the browser.
Is there a limit per formula?
A single range formula handles about 1,000 rows comfortably within Google's 30-second limit for custom functions. For more, use Hunch menu › Ask about selection, which runs for up to six minutes and writes values as it goes.