The template is a plain Google Sheet.
Three sheets: one for your key, two with real demo data and the formulas already typed in. Make a copy and it is yours, script included. Nothing to install.
Needs a Google account. Google asks you to confirm the copy.
| Row | A | B |
|---|---|---|
| 1 | Hunch for Sheets | |
| 2 | API key | hunch_2d7f0a9c41be6f3358c0e1d7a94b2f6c8e5d1a03 |
| 3 | Credits left | 4,944 |
| 4 | Buy credits | Buy credits → |
| 5 | ||
| 6 | How to use | |
| 7 | 1 | Paste your key in B2 above. Copies of this file need their own key. |
| 8 | 2 | In any sheet: =HUNCH(A2, "Is this lead a decision maker?") → 0.91 |
| 9 | 3 | =HUNCHSCORE(A2, "ICP fit: B2B SaaS, 20–500 staff, US or EU", "no fit|weak|good|perfect") → 2.7 |
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Ticket | Urgent? (0–1) | Category | Frustration |
| 2 | Our whole team is locked out since this morning, we have a client demo at 2pm. | 0.97 | bug | angry |
| 3 | I was charged twice for the March invoice. Can you refund the duplicate? | 0.36 | billing | calm |
| 4 | The export button does nothing on Safari. Works in Chrome. Not urgent. | 0.10 | bug | calm |
| 5 | How do I add a second admin to my workspace? | 0.41 | question | calm |
| 6 | This is the third time I am writing about the same bug and nobody replies. | 0.51 | bug | furious |
| 7 | Loving the new dashboard, small thing: the date picker ignores my timezone. | 0.36 | bug | annoyed |
| 8 | Great support last week, thanks. Everything works now. | 0.11 | feedback | calm |
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Lead notes | Decision maker? | ICP fit (0–3) | ICP label |
| 2 | Maria K., VP Sales at Northwind Logistics (300 employees, Chicago). Owns the sales tooling budget. | 0.67 | 2.44 | perfect |
| 3 | Tom R., SDR at a 12-person agency in Leeds. Asked for a free trial for himself. | 0.17 | 0.78 | weak |
| 4 | Priya S., Head of Customer Support, Lumen Health (180 staff, Austin). Signs off on tools under $50k. | 0.79 | 2.42 | perfect |
| 5 | Student building a side project, wants API access for a hackathon. | 0.10 | 0.04 | no fit |
| 6 | Jonas W., CTO and co-founder of a 40-person B2B SaaS in Berlin. | 0.79 | 2.79 | perfect |
| 7 | Procurement analyst at a 5,000-person bank. Cannot say who decides. | 0.09 | 0.32 | no fit |
What is inside
Three sheets, the same three tabs shown above.
Settings
Cell B2 holds your key. B3 shows credits left with =HUNCHBALANCE(). B4 is the buy link. Below that, seven numbered how-to lines and the tips that matter: put the definition in the question, add an other option, no math or dates.
Demo: support
Twelve support tickets, already scored: urgency as a probability, category with =HUNCHPICK, frustration level with =HUNCHSCORE. The answers are frozen as values, so the demo reads before you have a key. Row 14 is live: type a ticket there and the three formulas score it with your key.
Demo: leads
Ten lead notes, already scored: decision-maker probability, ICP fit as a score and as a label. Row 12 is live for your own notes. The ICP definition sits inside the formula; change it and re-score your own column.
Hunch menu
Your copy adds a menu next to Help. It is the only part that asks for permissions, and only when you first use it.
Ask about selection
Select a text column, pick a formula, type the question. Results are written as plain values in the next column, up to about 20,000 rows per run.
Freeze selection to values
Replaces formulas with their current values. Do this when a column is final or before sharing, so nothing recalculates.
Set API key, Check balance, Buy credits
The same things the Settings sheet does, one click away from any sheet in the file.
Three steps
Copy
Click Copy the template above. Google opens the sheet and asks to make a copy into your Drive.
Paste your key
Open Settings, click B2, paste the key from your payment page or from the trial email. It starts with
hunch_. No key yet? Get 100 free rows.Type a formula
In any cell:
=HUNCH(A2, "…"). Or point it at a whole range:=HUNCH(A2:A500, "…").