SheetMagicSheetMagic

Everything it does, counted.

64 custom functions and an AI Chat Agent, inside Google Sheets. Every formula is on every plan, including Free. The Chat Agent is on Solo, Team, Business. Nothing below is a roadmap item; each function named here exists in the add-on today.

Custom functions
64
AI formulas
8
Platform scrapers
43
Platforms
10
AI providers
6

AI Chat Agent

Solo, Team, Business

A sidebar that reads your sheet and acts on it from a plain-English request. It does the multi-step jobs a single formula cannot: find the top customers, highlight them, build the chart, all in one ask.

Find my top 10 customers by revenue and build a bar chart

How the agent works
  • Writes cells and formulas
  • Sorts, dedupes, and formats
  • Builds charts and pivot tables
  • Scrapes the web into a new tab
  • Generates images and speech
  • Reads the sheet before it acts

21 core formulas, in three groups.

Type them like any other formula. Reference a cell, drag down, and every row runs.

AI Generation

8functions

Text, lists, images, video, speech, translation, and vision, every AI model, one formula away.

  • =AITEXT()

    Generate AI text from any prompt, supports every model and optional real-time web search

  • =AILIST()

    AI-generated list that spills down rows

  • =AILISTH()

    AI-generated list that spills across columns

  • =AIIMAGE()

    Generate images with GPT Image 2, DALL-E 3, or Gemini image models

  • =AIVIDEO()

    Generate video clips with Sora 2 or Veo 3.1

  • =AISPEECH()

    Convert text to natural-sounding speech with 11 voices

  • =AITRANSLATE()

    Translate cell content into any language

  • =GPTV()

    Analyze images with AI vision, extract text, describe content, identify objects

Web Scraping Classics

6functions

Scrape any page, any selector, any search result, no code, no browser extensions.

  • =VISIT()

    Get entire page content from any URL (up to 50K chars), including JavaScript-rendered pages

  • =GETSELECTOR()

    Extract elements matching any CSS selector

  • =GETIMG()

    Extract all image URLs from a page

  • =SERP()

    Up to 20 search results per query, title, snippet, URL, powered by DuckDuckGo, free on every plan

  • =BULKSERP()

    Search results in horizontal format, ideal for many keywords at once, free on every plan

  • =DOMAINCHECK()

    Check domain availability instantly via RDAP across 20+ TLDs, free on every plan

Page Data & SEO

7functions

Audit meta tags, headings, and page copy across hundreds of URLs at once.

  • =PAGEDATA()

    Bulk-extract metadata (title, description, headings) from a range of URLs

  • =GETMETATITLE()

    Get the meta title of any page

  • =GETMETADESCRIPTION()

    Get the meta description of any page

  • =GETH1()

    Get the main H1 heading of any page

  • =GETH2()

    Get all H2 headings of any page

  • =GETHEADINGS()

    Get all headings (H1–H6) of any page

  • =GETP()

    Get all paragraph text from any page

Every function with its example

43 platform scrapers.

Google, Amazon, YouTube, LinkedIn, Instagram, Zillow, eBay and more, each as a formula that spills a table. 13 return instantly; the rest run in the background for up to about a minute and show a placeholder first.

Public pages only. Some sources have limits: TikTok profiles are blocked upstream (hashtags work), and Zillow search needs a full search URL.

Every scraper and its formula
Google11functions
Amazon3functions
YouTube2functions
Social Media7functions
LinkedIn3functions
Jobs & Leads5functions
Commerce & Reviews3functions
Reviews & Reputation3functions
Real Estate3functions
Research & Web3functions

Pick the model. The formula does not change.

Choose a provider and model in the sidebar. Bring your own key on any paid plan and AI is billed by that provider at its own rates.

OpenAI
GPT-5.5, GPT-5.4, GPT-5.2, GPT-5.1, GPT-5, GPT-4.1, GPT-4o, GPT-4o mini; GPT Image 2 and 1.5; gpt-4o-mini-tts
Anthropic
Claude Opus 5, Claude Sonnet 5, Claude Haiku 4.5
Google
Gemini 3.5 Flash, Gemini 3.1 Pro, Gemini 2.5 Flash; Gemini 3.1 and 3 image models; Veo 3.1 and Veo 3.1 Lite
Mistral
Mistral Large, Mistral Small
Perplexity
Sonar family, web-search capable
OpenRouter
Any model OpenRouter lists

Web search inside AITEXT works with OpenAI GPT-4o and newer, current Claude models, and Perplexity Sonar. Video runs on Sora 2, Sora 2 Pro, Veo 3.1 and Veo 3.1 Lite.

What it costs to run.

Two allowances, tracked separately: AI tokens for the AI formulas and the agent's reasoning, integration credits for every scraper and lookup. Both reset each billing cycle. Every rate is published.

Integration credits per month

Free100cr
Solo10,000cr
Team50,000cr
Business135,000cr

AI tokens per month

Free20,000tok
Solo3,250,000tok
Team15,000,000tok
Business37,500,000tok

With your own key on, credits rise 50%: Solo 15K, Team 75K, Business 202,500.

Every formula, free to try.

20,000 AI tokens and 100 credits, no card, no expiry.