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.

  1. Install and run your first AI formula — Key, first formula, first column fill, in about five minutes.
  2. The five functions — Syntax, examples and limits for AI, AI_CLASSIFY, AI_EXTRACT, AI_TRANSLATE and AI_SUMMARIZE.
  3. Fill a column with AI — Run a prompt down a column and get plain values back, with placeholders, progress and Stop.
  4. Formula help — Describe a calculation in plain English and get a Google Sheets formula built around your headers.
  5. Getting a free Gemini API key — Two minutes, no card. Where the key is stored, who can use it and what it costs.
  6. 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.