SheetAI

Get Started with SheetAI

Use AI directly inside Google Sheets to generate content, extract data, classify text, and more. Total setup time: 8-10 minutes. After that, it's as simple as typing a formula.

What we'll cover

1

Install the add-on

~1 minute

2

Set up your API key

~4 minutes

3

Your first formula

~2 minutes

1
~1 minute

Install the add-on

  1. 1

    Go to the Google Workspace Marketplace

    Click the button below to open the SheetAI install page.

  2. 2

    Click "Install"

    On the marketplace page, click the blue Install button.

  3. 3

    Select your Google account

    Choose the Google account you want to use with SheetAI.

  4. 4

    Click "Continue" and then "Allow"

    Grant the required permissions for SheetAI to work in your spreadsheets.

  5. 5

    Done!

    SheetAI is now installed. You'll see it under Extensions in any Google Sheet.

Install SheetAI from Marketplace

Need more detail? See the full installation guide

2
~4 minutes

Set up your API key

Free to start: OpenAI gives new accounts free credits. You can also use Google Gemini which has a generous free tier.

Quick steps (OpenAI)

  1. 1

    Sign up at platform.openai.com/signup

  2. 2

    Go to API Keys and click "Create new secret key"

  3. 3

    Copy the key (starts with sk-) — you won't see it again

  4. 4

    In Google Sheets: Extensions → SheetAI App → Launch sidebar

  5. 5

    Open Settings, paste your key, click Save

Other supported providers

Google GeminiAnthropic ClaudexAI GrokDeepSeek

See setup guides for all providers

3
~2 minutes

Your first formula

Open any Google Sheet (or go to sheet.new), make sure to launch the sidebar first (Extensions → SheetAI App → Launch), then type this in cell A1:

A
1
=SHEETAI("Write a tagline for a coffee shop")
2
"Brewing happiness, one cup at a time."

That's it! You just used AI in Google Sheets. Now let's try more powerful functions.

Try these next

Each example below shows a real formula you can paste into your sheet right now.

Add creativity with temperature

Higher temperature (0-1) = more creative. Try 0.9 for brainstorming.

A
1
=SHEETAI("Write a tagline for a coffee shop", 1000, 0.9)
2
"Where every sip whispers a secret adventure."

Generate a list with SHEETAI_LIST

Docs

Results spill into multiple rows — perfect for brainstorming.

A
1
=SHEETAI_LIST("5 startup name ideas for a pet app")
2
PawPal
3
FurEver
4
Snoutly
5
BarkBuddy
6
PetVerse

Generate a table with SHEETAI_TABLE

Docs

Outputs structured data across rows and columns.

=SHEETAI_TABLE("top 5 fruits and their calories")
FruitCalories (per 100g)Key Nutrient
Apple52Fiber
Banana89Potassium
Orange47Vitamin C
Strawberry33Antioxidants
Mango60Vitamin A

Auto-tag content with SHEETAI_TAG

Docs

Classify text using your own tags.

A
1
=SHEETAI_TAG("I love chocolate", "food, positive, negative")
2
food, positive

Extract data with SHEETAI_EXTRACT

Docs

Pull emails, names, companies, dates from any text.

A
1
=SHEETAI_EXTRACT("Contact john@acme.com or jane@corp.io", "emails")
2
john@acme.com, jane@corp.io

Translate with SHEETAI_TRANSLATE

Docs

Translate to 90+ languages.

A
1
=SHEETAI_TRANSLATE("Hello, how are you?", "hindi")
2
नमस्ते, आप कैसे हैं?

Auto-fill data with SHEETAI_FILL

Docs

Give it a few examples and it learns the pattern to fill the rest.

A (Product)
B (Description)
1
Running Shoes
Lightweight shoes for daily runs
2
Yoga Mat
Non-slip mat for home workouts
3
Water Bottle
=SHEETAI_FILL(A1:B2, B3)
→
Water Bottle
Insulated bottle for staying hydrated

Function settings explained

All SheetAI functions share these optional parameters:

ParameterWhat it doesDefault
response_tokenMax length of response. ~750 words per 1000 tokens.1000
temperatureCreativity level. 0 = deterministic, 1 = very creative.0.4
modelAI model to use. See all supported models.gpt-3.5-turbo
cacheSaves API credits by caching identical prompts for 6 hours. Set to false for fresh responses.true

Pro tip: Save your results

SheetAI formulas recalculate when your sheet refreshes, using extra API credits. Once you have results you like, go to Extensions → SheetAI App → Replace with Values to lock them in permanently. Learn more

What's next?

All function examples

See every SheetAI function in action

Function reference

Full syntax and parameter docs

Supported AI models

GPT-4o, Claude, Gemini, Grok, DeepSeek

Troubleshooting

Fix common errors