Getting a free Gemini API key

Two minutes, no card. Where the key is stored, who can use it and what it costs.

Create the key

  1. Go to aistudio.google.com/apikey and sign in with any Google account.
  2. Click Create API key. If asked, create a new project or pick one.
  3. Copy the key (it starts with AIza or AQ.).
  4. In the add-on, open Settings, paste it and click Save key.

Where it is stored, and who can use it

Google Sheets runs custom functions without knowing which user triggered them, so a formula can only read settings stored with the spreadsheet. That is where the key lives. Consequences:

If you’d rather not share a key, use Fill column, remove the key under Settings afterwards, and share the values.

Cost

Google’s free tier for Gemini Flash models covers a few thousand requests a day. Cached results never call Gemini. If you enable billing on your project you pay Google directly, a fraction of a cent per cell; the add-on never bills you for AI.

Workspace accounts

Some company or school Workspace accounts block AI Studio. Create the key with a personal Google account; it works regardless of which account uses the spreadsheet.