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.
| 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 |
| 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.35 | 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.40 | question | calm |
| 6 | This is the third time I am writing about the same bug and nobody replies. | 0.52 | bug | angry |
| 7 | Loving the new dashboard, small thing: the date picker ignores my timezone. | 0.39 | bug | annoyed |
| 8 | Great support last week, thanks. Everything works now. | 0.12 | feedback | calm |
| 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.34 | perfect |
| 3 | Tom R., SDR at a 12-person agency in Leeds. Asked for a free trial for himself. | 0.17 | 0.84 | weak |
| 4 | Priya S., Head of Customer Support, Lumen Health (180 staff, Austin). Signs off on tools under $50k. | 0.79 | 2.36 | perfect |
| 5 | Student building a side project, wants API access for a hackathon. | 0.11 | 0.07 | no fit |
| 6 | Jonas W., CTO and co-founder of a 40-person B2B SaaS in Berlin. | 0.80 | 2.74 | perfect |
| 7 | Procurement analyst at a 5,000-person bank. Cannot say who decides. | 0.09 | 0.24 | 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. Three range formulas: urgency as a probability, category with =HUNCHPICK, frustration level with =HUNCHSCORE. Type a new ticket in the next row to see it scored.
Demo: leads
Ten lead notes. Decision-maker probability, ICP fit as a score and as a label. The ICP definition sits inside the formula; change it and the whole column re-scores.
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. It starts with
hunch_.Type a formula
In any cell:
=HUNCH(A2, "…"). Or point it at a whole range:=HUNCH(A2:A500, "…").