AI Formulas for Sheets guides
Classify, extract, translate, summarise and write, straight from a formula or a sidebar. Bring your own free Gemini key; results are cached so recalculation costs nothing.
- Install and run your first AI formula — Key, first formula, first column fill, in about five minutes.
- The five functions — Syntax, examples and limits for AI, AI_CLASSIFY, AI_EXTRACT, AI_TRANSLATE and AI_SUMMARIZE.
- Fill a column with AI — Run a prompt down a column and get plain values back, with placeholders, progress and Stop.
- Formula help — Describe a calculation in plain English and get a Google Sheets formula built around your headers.
- Getting a free Gemini API key — Two minutes, no card. Where the key is stored, who can use it and what it costs.
- Privacy policy for AI Formulas for Sheets — Exactly which Google permissions the add-on uses, why, and what happens to your cell contents.
Can't find an answer? Contact support and include the form name and what you saw under Activity.