Every SheetMagic Function, on One Page
62 custom functions: 21 core formulas for AI, scraping, and page data, plus 41 platform scrapers for Amazon, Google, Instagram, LinkedIn, TikTok, and more. All included on every plan.
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 DALL-E 3, Imagen 4, Flux, or Gemini image models | =AIIMAGE("A professional photo of a modern coffee shop") |
=AIVIDEO() | Generate video clips with Sora 2, Veo 3, or Runway Gen 4 | =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") |
11 functions
Amazon
3 functions
YouTube
2 functions
Social Media
6 functions
3 functions
Jobs & Leads
5 functions
Commerce & Reviews
3 functions
Reviews & Reputation
3 functions
Real Estate
2 functions
Research & Web
3 functions
AI formulas use AI tokens; scraping and page-data formulas use integration credits. Every plan includes a monthly allowance of both, the Free plan includes a one-time allowance of 20,000 AI tokens and 100 integration credits.
How tokens & credits work →Put all 62 functions to work
Join 3,900+ users automating their spreadsheets. Start free, no credit card required.