All 64 functions, one page.
21 core formulas for AI, scraping and page data, plus 43 platform scrapers for Amazon, Google, YouTube, Instagram, LinkedIn, eBay, Zillow and more. If you can write =SUM(), you can use every one. All of them are on every plan, including Free.
Which formula for which job.
Start from the task. Drag the formula down and it runs on every row.
1,000 product descriptions, written overnight
=AITEXT("Write a 40-word description for: " & A2)Audit meta titles and descriptions across a client site
=PAGEDATA(A2:A200)Turn a column of ASINs into a live price sheet
=AMAZONPRODUCT(A2, "US", "10001")Translate a catalog into six languages
=AITRANSLATE(A2, "German")Pull the transcript of every video in a playlist
=YTTRANSCRIPT(A2:A30)Read receipts and screenshots into columns
=GPTV(A2, "Extract vendor, date and total")
AI Generation
8functionsText, 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
6functionsScrape 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, free on every plan | =SERP("best coffee shops in NYC", 20, "us-en", "d") |
=BULKSERP() | Search results in horizontal format, ideal for many keywords at once, free on every plan | =BULKSERP("best coffee shops in NYC") |
=DOMAINCHECK() | Check domain availability instantly via RDAP across 20+ TLDs, free on every plan | =DOMAINCHECK("mybrand.com") |
Page Data & SEO
7functionsAudit 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(A2, A3, A4) |
=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") |
Platform scrapers
43functions13 spill a table instantly (Google, Amazon, YouTube search). 30 run as background jobs and write results into the same cells within about a minute. All return public data.
- Google11
- Amazon3
- YouTube2
- Social Media7
- LinkedIn3
- Jobs & Leads5
- Commerce & Reviews3
- Reviews & Reputation3
- Real Estate3
- Research & Web3
What they spend.
AI formulas spend AI tokens. Scraper and page-data formulas spend integration credits: a Google or YouTube lookup is 3 credits, an Amazon lookup 1, a page scrape 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. Solo is $20 a month when you want a monthly refill.
On Solo, Team and Business the AI Chat Agent picks the right function for you. Say “translate column B into Spanish and flag any row over 200 words” and it writes the cells.