What it does
Jev for Sheets adds four formulas to Google Sheets. They send the text in your cells to TypeSafe's Jev model, which answers in about a tenth of a second per row.
| Formula | Returns |
|---|---|
=JEV_IF(A2, "Is this a complaint?") | TRUE or FALSE |
=JEV_PROB(A2, "Is this a complaint?") | Probability of "yes", 0–1 |
=JEV_CHOICE(A2, "billing, technical, sales") | One of your options (2–255) |
=JEV_CHOICE(A2, D1:D5, "Which team?", 0.8) | An option, or UNSURE when Jev is less than 80% confident |
=JEV_SCORE(A2, "How urgent?", "not urgent, low, medium, high, critical") | 1 to the number of levels (2–10 levels, lowest first); can land between levels, e.g. 2.4 |
Options and levels can be typed as a comma-separated list or taken from a range of cells.
- Whole columns at once:
=JEV_IF(A2:A500, "…")fills one answer per row. - Several columns:
=JEV_IF(A2:C500, "…")judges each row on all its cells together, e.g. product name, description and price. - Knows when it's unsure: set a minimum confidence and uncertain rows say
UNSUREinstead of guessing, so you only check those by hand. - No surprise re-billing: answers are cached for 6 hours, so recalculating the sheet is free.
Getting started
- Install Jev for Sheets from the Google Workspace Marketplace. (Listing coming soon; until then, see the manual install.)
- Get an API key from console.typesafe.ai. You pay TypeSafe directly for usage, at launch pricing about $0.04 per million input tokens (a short cell costs a tiny fraction of a cent).
- In your sheet, open Extensions → Jev for Sheets → Settings & API key, paste the key, and click Save.
- Click Insert example sheet to see every formula working, then use them on your own data.
Your data
Only the cells you pass to a JEV_ formula are sent, and only to TypeSafe's API, to get the answer. The add-on has no server of its own and collects no analytics. Your API key stays in Google's Apps Script storage. Details: privacy policy.
Tips
- Ask one thing per question, and phrase it literally: "Does the customer ask for a refund?" works better than "Is this refund-y?".
- Leave arithmetic, dates and counting to normal formulas. Jev judges meaning, not numbers.
- Up to 1,000 cells per formula. Split larger ranges across several formulas.
Support
Questions, bugs or ideas: open an issue on GitHub. The source code is open (MIT).