=GEMINI() — use Google Gemini in Google Sheets

=GEMINI() runs Google’s Gemini models from a cell. Gemini is fast and cost-effective for high-volume tasks like classification, tagging and short-form generation.

Syntax

=GEMINI(prompt, [value])

Parameter	Required	Description
`prompt`	yes	The instruction for Gemini.
`value`	no	Extra input appended to the prompt.

=GEMINI_CUSTOM(apiKey, model, prompt, [value])

Runs Gemini with your own Google AI API key and an exact model name — useful when you need a specific model version or your own billing.

=GEMINI_CREATE_IMAGE(prompt, [aspectRatio], [model])

Generates an image with Gemini image models and returns a URL you can render with =IMAGE(). Default aspect ratio is 1:1.

Examples

Classify support tickets in A2:

=GEMINI("Classify as billing, bug, feature request or other. Return one word.", A2)

Generate a thumbnail illustration:

=GEMINI_CREATE_IMAGE("Flat illustration of a mail merge robot, purple palette", "16:9")

Bulk-generate meta descriptions for an SEO sheet (A2 = page title):

=GEMINI("Write a 150-character meta description for a page titled", A2)

Tag product reviews at high volume:

=GEMINI("Return the main topic of this review in 1-2 words", A2)

Tips

Gemini shines on high-volume, short-output tasks — drag the formula down and let it churn; GPT for Sheets handles up to 10,000 results per hour.
No Google AI API key is needed for =GEMINI() — the model is built in. Use =GEMINI_CUSTOM() only when you need a specific model version or your own billing.
Done generating? Use Replace all GPT formulas with results in the sidebar so Sheets stops re-running the formulas.

=GPT() — the default model function, same arguments
=CLAUDE() — Anthropic Claude for nuanced rewriting
=GPT_CREATE_IMAGE() — image generation with OpenAI models

Try it

Copy the template or install GPT for Sheets. See also: How to use Gemini in Google Sheets.