Complete Guide to AI Sheets Formulas

Last updated on 

All Formulas at a Glance

Formula Purpose
=GPT() Generate AI-powered responses and insights
=PERPLEXITY() Get real-time news, research, stock information and web search results
=GPTTEACH() Give it a few examples, and the AI will finish your work for you.
=GPTASK() Get answers to questions about your data
=GPTWRITE() Generate longer-form text content
=GPTTABLE() Create complete tables with structured data
=GPTTRANSLATE() Translate or adjust tone of content
=GPTCATEGORIZE() Automatically categorize and organize data
=GPTEXTRACT() Extract specific information from text
=GPTLIST() Generate vertical lists with each item in its own cell
=GPTIMAGE() Generate AI images directly in your spreadsheet
=GPTTRANSFORM() Apply AI transformation to a range while preserving structure

Table of Contents

Getting Started

  1. Sign up for free at AI Sheets
  2. Install AI Sheets for your Google Sheets
  3. Get started with =GPT and more powerful and easy AI formulas

Formula Details

=GPT()

The most versatile AI formula

The GPT formula generates AI-powered responses based on your prompts and is the foundation of AI Sheets.

Syntax:

=GPT(cell_reference, prompt)

Examples:

  • =GPT("Summarize the benefits of AI in education")
  • =GPT(A2, "Rewrite this in a more professional tone")
  • =GPT(A2:A10, "Identify common themes in these customer reviews")

Use Cases:

  • Content creation (blog posts, emails, social media)
  • Text summarization and rewriting
  • Data analysis and insights
  • Research assistance and idea generation

=GPTASK()

Ask questions about your data

The GPTASK formula allows you to analyze data by asking questions in natural language.

Syntax:

=GPTASK(range, question)

Examples:

  • =GPTASK(A2:F50, "What were our top 3 performing products last month?")
  • =GPTASK(A2:J200, "What's the correlation between customer satisfaction scores and purchase frequency?")

Use Cases:

  • Sales analysis and trend identification
  • Customer feedback analysis
  • Financial reporting and insights
  • Product performance evaluation

=GPTWRITE()

Generate longer-form content

The GPTWRITE formula is specialized for creating longer, more structured content.

Syntax:

=GPTWRITE(cell_reference, instructions, [length], [tone])

Examples:

  • =GPTWRITE("Write a product description for wireless earbuds", "300 words", "persuasive")
  • =GPTWRITE(A2, "Create a professional email response to this customer inquiry")

Use Cases:

  • Marketing copy and product descriptions
  • Email templates and responses
  • Blog posts and articles
  • Technical documentation

=GPTTABLE()

Generate complete tables with structured data

The GPTTABLE formula creates entire tables of organized information.

Syntax:

=GPTTABLE("topic", "column1", "column2", "column3", ...)

Examples:

  • =GPTTABLE("5 top electric vehicles", "Model", "Range (mi)", "Price", "Key Features")
  • =GPTTABLE("content calendar for fitness blog", "Topic", "Target Keyword", "Title", "Key Points")

Use Cases:

  • Comparison charts and product tables
  • Content calendars and marketing plans
  • Project timelines and task lists
  • Research data organization

=GPTTRANSLATE()

Translate text or adjust its tone

The GPTTRANSLATE formula converts content between languages or adapts its style.

Syntax:

=GPTTRANSLATE(cell_reference, target_language, [tone_parameters])

Examples:

  • =GPTTRANSLATE(A2, "Spanish")
  • =GPTTRANSLATE(B5, "French", "formal tone for business communication")
  • =GPTTRANSLATE(C7, "simple", "explain like I'm 10 years old")

Use Cases:

  • Multilingual content creation
  • Localization of marketing materials
  • Tone adjustment (technical to simple, formal to casual)
  • Cultural adaptation of content

=GPTCATEGORIZE()

Automatically classify and organize data

The GPTCATEGORIZE formula helps sort and classify text data into meaningful categories.

Syntax:

=GPTCATEGORIZE(cell_reference, category_type)

Examples:

  • =GPTCATEGORIZE(A2:A50, "positive,negative,neutral")
  • =GPTCATEGORIZE(B5, "Quality Issue,Shipping Problem,Customer Service,Product Feature,Other")

Use Cases:

  • Customer feedback analysis
  • Content tagging and organization
  • Expense categorization
  • Lead qualification and sorting

=GPTEXTRACT()

Pull specific information from text

The GPTEXTRACT formula identifies and extracts particular data points from unstructured text.

Syntax:

=GPTEXTRACT("extract_type", text)

Examples:

  • =GPTEXTRACT("email", A2)
  • =GPTEXTRACT("dates,phone numbers,company names", B5:B25)

Use Cases:

  • Contact information extraction
  • Data cleaning and structuring
  • Document analysis
  • Research data collection

=GPTLIST()

Generate vertical lists with items in separate cells

The GPTLIST formula creates lists where each item appears in its own cell vertically.

Syntax:

=GPTLIST(prompt, [count])

Examples:

  • =GPTLIST("marketing ideas for a coffee shop", 10)
  • =GPTLIST("common objections in B2B sales")

Use Cases:

  • Brainstorming ideas
  • Creating checklists and task lists
  • Content planning
  • Sample data generation

=GPTIMAGE()

Generate AI images in your spreadsheet

The GPTIMAGE formula creates custom images based on text descriptions.

Syntax:

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

Examples:

  • =IMAGE(GPTIMAGE("Mountain landscape at sunset with pine trees"))
  • =IMAGE(GPTIMAGE("Product mockup of a minimalist water bottle", "portrait", "realistic"))

Use Cases:

  • Product visualization
  • Marketing assets creation
  • Blog and social media images
  • Concept illustration

=GPTTRANSFORM()

Transform ranges while preserving structure

The GPTTRANSFORM formula applies AI-powered changes to data ranges while maintaining their format.

Syntax:

=GPTTRANSFORM(range, instructions)

Examples:

  • =GPTTRANSFORM(A2:A20, "Translate to Spanish")
  • =GPTTRANSFORM(B5:D15, "Convert all text to proper case and fix spelling errors")

Use Cases:

  • Bulk translation and localization
  • Data cleaning and standardization
  • Text formatting and style adjustment
  • Content adaptation for different audiences

=PERPLEXITY()

Get real-time information from the web

The PERPLEXITY formula provides up-to-date search results, news, and information directly from the web into your spreadsheet.

Syntax:

=PERPLEXITY(prompt, [cell_reference])

Examples:

=PERPLEXITY("Latest news about Tesla")
=PERPLEXITY("Current stock price of AAPL")
=PERPLEXITY("Latest research papers on " & A2)
=PERPLEXITY("Competitive analysis of " & B5 & " and its top 3 competitors")

Use Cases:

  • Real-time stock market data retrieval
  • News monitoring and aggregation
  • Competitive intelligence gathering
  • Research and fact-checking
  • Trend analysis and market research
  • Sales prospecting with current company information

Best Practices

  • Lock Your Results: Use "Lock results" feature to preserve generated content (Extensions → AI Sheets → Lock results)
  • Use Cell References: Make your formulas dynamic by referencing cells instead of typing text directly
  • Be Specific: The more detailed your instructions, the better the results
  • Start Small: Test with simple examples before scaling to larger datasets
  • Combine Formulas: Use the output of one AI Sheets formula as input for another

Ready to transform your spreadsheet workflow? Get started with AI Sheets today!