SheetAI Examples

SheetAI makes it easy to automate tasks like text generation, data extraction, classification, and more — all directly inside Google Sheets. Here are all the available functions with usage examples.

SHEETAI

Full docs

The main AI function. Write any prompt and get an AI-generated response directly in your cell.

Syntax

=SHEETAI(prompt, [model], [temperature], [max_tokens])

Formula

=SHEETAI("Write a tagline for a coffee shop")

Output

"Brewing happiness, one cup at a time."

Formula

=SHEETAI("Summarize this text: " & A1)

Output

A concise summary of the text in cell A1

Reference cells to process existing data

Formula

=SHEETAI("Write a tagline for a coffee shop", "gpt-4o-mini", 0.9)

Output

"Where every sip tells a story."

Higher temperature (0.9) = more creative results

SHEETAI_LIST

Full docs

Generate multiple AI responses at once. Results spill into consecutive cells vertically — perfect for brainstorming, generating variations, or creating lists.

Syntax

=SHEETAI_LIST(prompt, number_of_responses)

Formula

=SHEETAI_LIST("Give me startup name ideas for a pet app", 5)

Output

PawPal, FurEver, Snoutly, BarkBuddy, PetVerse (each in its own row)

Formula

=SHEETAI_LIST("List 3 benefits of meditation")

Output

Reduces stress, Improves focus, Better sleep (each in its own row)

SHEETAI_TABLE

Full docs

Generate structured data in table format. Creates organized datasets with rows and columns — great for comparisons, catalogs, and structured data.

Syntax

=SHEETAI_TABLE(prompt, number_of_rows)

Formula

=SHEETAI_TABLE("Compare 3 programming languages with pros and cons", 3)

Output

A table with Language, Pros, Cons columns filled across rows

Formula

=SHEETAI_TABLE("Generate 5 fictional product entries with name, price, category", 5)

Output

5 rows of product data spread across columns

SHEETAI_TAG

Full docs

Automatically categorize and tag content using AI. Analyzes text and assigns relevant tags — perfect for product tagging, content organization, and labeling.

Syntax

=SHEETAI_TAG(content, number_of_tags)

Formula

=SHEETAI_TAG("This laptop has great battery life and a stunning display", 3)

Output

Electronics, Laptop, Product Review

Formula

=SHEETAI_TAG(A1, 5)

Output

Up to 5 relevant tags based on the content in A1

SHEETAI_EXTRACT

Full docs

Extract specific information from text. Pulls out emails, phone numbers, dates, names, or any structured data from unstructured text.

Syntax

=SHEETAI_EXTRACT(text, what_to_extract)

Formula

=SHEETAI_EXTRACT("Contact John at john@example.com or call 555-1234", "email")

Output

john@example.com

Formula

=SHEETAI_EXTRACT(A1, "country")

Output

Extracts the country name mentioned in cell A1

SHEETAI_FILL

Full docs

Auto-fill missing data using AI. Analyzes patterns in your existing data and fills in the gaps — great for data enrichment and completing datasets.

Syntax

=SHEETAI_FILL(range_with_context, target_cell, [instructions])

Formula

=SHEETAI_FILL(A1:B5, B6)

Output

Fills B6 based on the pattern in A1:B5

Learns from your existing data to predict missing values

Formula

=SHEETAI_FILL(A1:C3, C4, "product description")

Output

Generates a product description matching the pattern in your data

SHEETAI_CLASSIFY

Full docs

Classify and categorize content into predefined or auto-detected categories. Supports sentiment analysis, content categorization, and more.

Syntax

=SHEETAI_CLASSIFY(content, categories, [instructions])

Formula

=SHEETAI_CLASSIFY("I love this product!", "Positive, Negative, Neutral")

Output

Positive

Formula

=SHEETAI_CLASSIFY(A1, "Bug, Feature Request, Question")

Output

Classifies the support ticket in A1 into the right category

SHEETAI_SUMMARIZE

Full docs

Create concise summaries of longer text. Distills key points from articles, documents, reviews, and any lengthy content.

Syntax

=SHEETAI_SUMMARIZE(text, [length], [style])

Formula

=SHEETAI_SUMMARIZE(A1)

Output

A concise summary of the text in cell A1

Formula

=SHEETAI_SUMMARIZE(A1, "2 sentences")

Output

A 2-sentence summary of the content

SHEETAI_IMAGE

Full docs

Generate AI images directly in your spreadsheet cells from text prompts.

Syntax

=SHEETAI_IMAGE(prompt, [style], [size])

Formula

=SHEETAI_IMAGE("A cute cat wearing sunglasses")

Output

An AI-generated image inserted into the cell

Formula

=SHEETAI_IMAGE("Product photo of a red sneaker", "realistic")

Output

A realistic-style AI image of a red sneaker

SHEETAI_BRAIN

Full docs

AI assistant with context from your sidebar conversations. Teach it about your business, then ask questions in cells and get context-aware answers.

Syntax

=SHEETAI_BRAIN(prompt, [cache])

Formula

=SHEETAI_BRAIN("What is our refund policy?")

Output

Based on your context: 30-day money back guarantee...

Add context about your business via the SheetAI sidebar first

Formula

=SHEETAI_BRAIN("Summarize our product features")

Output

Your product offers AI-powered spreadsheet automation...

The AI remembers what you taught it in the sidebar

SHEETAI_API

Full docs

Make HTTP API calls directly from Google Sheets. Supports GET, POST, PUT, PATCH, DELETE with custom headers and body. Extract specific values from JSON responses.

Syntax

=SHEETAI_API(url, [method], [headers], [body], [keyPath])

Formula

=SHEETAI_API("https://api.example.com/users/1")

Output

Full JSON response from the API

Formula

=SHEETAI_API("https://api.example.com/users/1", "GET", "", "", "data.name")

Output

Just the name field extracted from the response

Use keyPath to extract specific values with dot notation

SHEETAI_PJSON

Full docs

Parse JSON strings and extract specific values using dot notation and array indexing. Perfect for working with API responses.

Syntax

=SHEETAI_PJSON(json_string, keyPath)

Formula

=SHEETAI_PJSON(A1, "data.users[0].name")

Output

Extracts the name of the first user from a JSON string in A1

Formula

=SHEETAI_PJSON(A1, "results.count")

Output

Extracts the count value from nested JSON

Get Started

Install SheetAI and try these examples in your own Google Sheets.

Install SheetAI View full docs