SheetAI

Google Gemini Models in SheetAI

Use Gemini 2.0 Flash in Google Sheets with the dedicated GeminiAI() function. Gemini offers a generous free tier, making it a great option for getting started.

Available Gemini Models

"g"→Gemini 2.0 FlashLatestFree Tier

Gemini uses a different function

Unlike other providers that use SHEETAI(), Gemini has its own dedicated function:

=GeminiAI(prompt, model, maxTokens, temperature, api_key)

The api_key parameter is optional if you have already saved it in the sidebar settings.

Formula Examples

A
1
=GeminiAI("Explain quantum computing in one sentence")
2
Quantum computing uses quantum bits that can exist in multiple states simultaneously to solve problems exponentially faster.
A
1
=GeminiAI("Translate to French: " & A5, "gemini-2.0-flash", 500, 0.3)
2
Bienvenue dans notre boutique en ligne.
A
1
=GeminiAI("Extract the email from: " & B2, "gemini-2.0-flash", 100, 0)
2
contact@example.com
$0

Generous Free Tier

Google offers a generous free tier for the Gemini API. You can make a significant number of requests per day at no cost, making it ideal for testing, personal projects, and light usage.

Setup in 3 Steps

  1. Get your Google AI Studio API key

    Go to aistudio.google.com/app/apikey and create an API key. It is free to get started.

  2. Open the SheetAI sidebar

    In Google Sheets, go to Extensions → SheetAI → Open Sidebar.

  3. Paste your API key

    Click the gear icon in the sidebar, paste your Google AI Studio API key, and save.

Tip: You can also pass your API key directly in the formula: =GeminiAI("Your prompt", "gemini-2.0-flash", 1000, 0.7, "your-api-key")