Every SheetMagic Function, on One Page
63 custom functions: 21 core formulas for AI, scraping, and page data, plus 42 platform scrapers for Amazon, Google, YouTube, Instagram, LinkedIn, eBay, Zillow, and more. If you can write =SUM(), you can use every one of them.
All 63 functions on every plan, including Free. No credit card.
1,000 product descriptions, written overnight
=AITEXT()
=AITEXT("Write a 40-word description for: " & A2)Audit meta titles and descriptions across a client site
=PAGEDATA()
=PAGEDATA(A2:A200)Turn a column of ASINs into a live price sheet
=AMAZONPRODUCT()
=AMAZONPRODUCT(A2)Translate a catalog into six languages
=AITRANSLATE()
=AITRANSLATE(A2, "German")Pull the transcript of every video in a playlist
=YTTRANSCRIPT()
=YTTRANSCRIPT(A2:A30)Read receipts and screenshots into columns
=GPTV()
=GPTV(A2, "Extract vendor, date and total")AI Generation
Text, lists, images, video, speech, translation, and vision, every AI model, one formula away.
| Function | What it does | Example |
|---|---|---|
=AITEXT() | Generate AI text from any prompt, supports every model and optional real-time web search | =AITEXT("Write a product description for: " & A1) |
=AILIST() | AI-generated list that spills down rows | =AILIST("10 blog topics about coffee") |
=AILISTH() | AI-generated list that spills across columns | =AILISTH("5 US holidays in 2026") |
=AIIMAGE() | Generate images with GPT Image 2, DALL-E 3, or Gemini image models | =AIIMAGE("A professional photo of a modern coffee shop") |
=AIVIDEO() | Generate video clips with Sora 2 or Veo 3.1 | =AIVIDEO("Product showcase, rotating 360 degrees") |
=AISPEECH() | Convert text to natural-sounding speech with 11 voices | =AISPEECH("Welcome to our product demo", "nova") |
=AITRANSLATE() | Translate cell content into any language | =AITRANSLATE(A1, "Spanish") |
=GPTV() | Analyze images with AI vision, extract text, describe content, identify objects | =GPTV(A1, "Describe this product image") |
Web Scraping Classics
Scrape any page, any selector, any search result, no code, no browser extensions.
| Function | What it does | Example |
|---|---|---|
=VISIT() | Get entire page content from any URL (up to 50K chars), including JavaScript-rendered pages | =VISIT("https://example.com") |
=GETSELECTOR() | Extract elements matching any CSS selector | =GETSELECTOR("https://example.com", ".product-price") |
=GETIMG() | Extract all image URLs from a page | =GETIMG("https://example.com") |
=SERP() | Up to 20 search results per query, title, snippet, URL, powered by DuckDuckGo | =SERP("best coffee shops in NYC", 20, "us-en", "d") |
=BULKSERP() | Search results in horizontal format, ideal for many keywords at once | =BULKSERP("best coffee shops in NYC") |
=DOMAINCHECK() | Check domain availability instantly via RDAP across 20+ TLDs | =DOMAINCHECK("mybrand.com") |
Page Data & SEO
Audit meta tags, headings, and page copy across hundreds of URLs at once.
| Function | What it does | Example |
|---|---|---|
=PAGEDATA() | Bulk-extract metadata (title, description, headings) from a range of URLs | =PAGEDATA(A1:A100) |
=GETMETATITLE() | Get the meta title of any page | =GETMETATITLE("https://example.com") |
=GETMETADESCRIPTION() | Get the meta description of any page | =GETMETADESCRIPTION("https://example.com") |
=GETH1() | Get the main H1 heading of any page | =GETH1("https://example.com") |
=GETH2() | Get all H2 headings of any page | =GETH2("https://example.com") |
=GETHEADINGS() | Get all headings (H1–H6) of any page | =GETHEADINGS("https://example.com") |
=GETP() | Get all paragraph text from any page | =GETP("https://example.com") |
AI formulas spend AI tokens. Scraper and page-data formulas spend integration credits: a Google or YouTube lookup is 3 credits, an Amazon lookup is 1, a page scrape is 1, and platform scrapers are priced per row returned. Every paid plan refills both pools monthly. Free starts with 20,000 tokens and 100 credits, one time, no card.
On a paid plan, skip the formula
Solo, Team and Business include the AI Chat Agent, which picks the right function for you. Say “translate column B into Spanish and flag any row over 200 words” and it writes the cells, no formula required.
Every function on Free. Upgrade when the allowance runs out.
Join 6,400+ users. Install from the Marketplace, type your first formula, and see the result in the cell. Solo is $20 a month when you want a monthly refill.