SheetMagicSheetMagic

Ask the sheet. It does the work.

A sidebar in Google Sheets that reads your data and acts on it from a plain-English request. It writes cells and formulas, formats, builds charts and pivots, scrapes the web into a new tab, and generates images and speech. 93 tools, no formulas to remember.

The Chat Agent is on Solo, Team, Business. Free includes every formula on a one-time allowance and not the agent.

Unedited sessionReal capture
One sentence, four eBay sold-listing scrapes, 40 rows written into new tabs.

Ask for data you do not have yet.

With a formula you have to know that eBay comps live behind =EBAYSOLD and traffic behind =SIMILARWEB, and get the arguments right. With the agent you describe the data you want; it picks the source, runs it, writes the rows into a new tab, and the cost is the published rate for that source.

  • Find every dentist in Austin on Google Maps with their rating, phone number and website.

    You never name a scraper. The agent recognises this as a Maps job and runs it.

    Shape of the output, Google Maps3 credits per search
    PracticeRatingPhoneWebsite
    Lamar Family Dental4.8(512) 555-0142lamarfamilydental.com
    South Congress Smiles4.6(512) 555-0188socosmiles.com
  • What did Charizard ex cards actually sell for on eBay in the last 30 days?

    Sold prices, not asking prices. The gap between the two is the whole point.

    Shape of the output, eBay sold listings14 credits per row
    ListingSold forDateCondition
    Charizard ex 223/197 PSA 10$284.00Jul 29Graded
    Charizard ex 223/197 raw$96.50Jul 27Near mint
  • Take the company URLs in column A and pull their traffic, category and employee count.

    It reads column A itself. No range arguments, no dragging a formula down.

    Shape of the output, SimilarWeb32 credits per row
    DomainMonthly visitsCategoryEmployees
    northwind.com1.2MBusiness software210
    contoso.io486KE-commerce85
  • Pull the transcripts for these 8 YouTube videos and summarise each in two sentences.

    Scrape and AI in one sentence. The transcript never touches your clipboard.

    Shape of the output, YouTube transcripts, then AI24 credits per row, plus tokens
    VideoLengthSummary
    How we hit $1M ARR18:42Founder walks through the pricing changes that doubled...
    Cold email teardown11:05Breaks down four sequences and why the third...
  • Scrape the pricing table from the 12 competitor URLs in column B into new columns.

    Arbitrary pages, not just the platforms with a dedicated scraper.

    Shape of the output, Any web page1 to 2 credits per page
    CompetitorEntryMidTop
    Acme Analytics$29$99$249
    Globex Insights$25$120Custom

Sample rows are illustrative. Columns and rates are the real ones. Every source and its rate

What people actually type.

  • Find my top 10 customers by revenue, highlight them in green, and build a bar chart.

    A sort, a conditional format, and a chart. Three manual steps, one sentence.

  • Scrape the pricing table from these 12 competitor URLs in column B and put the results in new columns.

    The agent uses the same scraping engine as the scraper formulas.

  • Reformat this sheet: sort by close date, freeze the header row, and add a pivot table summarizing revenue by rep.

    Multi-step cleanup jobs are exactly what plain English is good at.

  • Read this data and tell me which rows look like duplicates.

    Read-only questions are answered without changing your sheet.

How it works.

  1. Step 1

    It reads your sheet

    Open the sidebar and ask. The agent reads the active sheet, headers, data and structure, so you never describe what is already there.

  2. Step 2

    It acts directly

    Writing cells, formatting, building charts and pivots, scraping the web: the work happens in your sheet, not in a transcript you copy from.

  3. Step 3

    You stay in control

    Reading and analysing happen instantly. Anything that writes to your sheet or spends credits asks for a quick confirmation first.

Formulas and the agent, together.

Formulas are the assembly line: define the pattern once with =AITEXT() or =AMAZONSEARCH(), then scale it across a thousand rows. The agent is the analyst on call: describe a one-off or multi-step task and it handles it. A typical workflow starts in the chat to explore and clean a new dataset, then switches to formulas for the repeatable processing.

Included on Solo, Team, Business.

Free includes every formula on a one-time 20,000 token and 100 credit allowance, no card. Upgrade for the agent.