Describe the job. Your sheet does it.
SheetMagic puts an AI Chat Agent and 64 formulas inside Google Sheets. Ask for every dentist in Austin with a rating and phone number, or drag =AITEXT() down a thousand rows. Every run has a published cost, and you see it before you spend it.
Every formula is free to try, no card, no expiry. The Chat Agent is included on Solo, Team and Business.
- Users
- 6,300+
- Marketplace rating
- 4.8/5
- AI requests processed
- 3.7M+
Two ways to get work out of a cell.
Ask the Chat Agent
Solo, Team, BusinessA sidebar that reads the sheet and acts on it. It writes cells and formulas, sorts, dedupes, formats, builds charts and pivots, scrapes the web, and generates images and speech. 93 tools, in plain English.
Find my top 10 customers by revenue and build a bar chart
Type a formula
Every plan, including Free64 custom functions that behave like any other formula. Reference a cell, drag it down, and it runs on every row. Change the input and it runs again.
=AITEXT("Write a product description for: " & A2)
=YTTRANSCRIPT(B2)
=AMAZONSEARCH("wireless earbuds", "US", "10001")
Any model, either way. OpenAI, Anthropic, Google, Mistral, Perplexity and anything on OpenRouter, picked from the sidebar. Formulas do not change when the model does.
Every run has a price, and it is printed here.
Two allowances, tracked separately so you can see exactly where usage goes. Nothing is billed by surprise, there are no overage fees, and when an allowance runs out the formula stops rather than charging you.
- Integration credits
- Spent by every scraper and lookup, and by the Chat Agent's scrape tools. Per call for pages, Google and Amazon; per row returned for the platform scrapers.
- AI tokens
- Spent by the eight AI formulas and the Chat Agent's reasoning. Scales with prompt size, output size and the model you pick; smaller models go much further on classification work.
- At zero
- You get a heads-up before an allowance runs out. At zero the formula stops rather than charging you. Upgrade, or buy a one-time pack valid 12 months. Both allowances reset each billing cycle and do not roll over.
Per call, generic web and search
1 to 9credits
A basic page is 1 credit. A bot-protected page escalates to a residential route automatically and costs 9.
Per AI formula call, working assumptions
300 to 1,500tokens
Estimates, not measured rates. A short classification or one-line rewrite sits near the low end; a full product description near the high end. Under BYOK, AI is unlimited at your provider's own rates.
Per row returned, the 30 background scrapers
1 to 84credits per row
credits per rowmean 16
- App Store reviews1credits per row
- Instagram9credits per row
- LinkedIn profiles40credits per row
- Full site crawl84credits per row
The 13 instant scrapers (Google, Amazon, YouTube) bill per call, above. These 30 run in the background and bill per row returned. A few also charge a fixed fee per query; the full table lists them.
What a plan buys, in real work.
Allowances divided by the published rates above. Free is a one-time allowance with no expiry; Solo, Team and Business reset every billing cycle. Yearly billing is a flat 30% off.
Bars are scaled within each row, to its largest cell.
Integration credits
the allowance itself
- Free
- 100
- Solo
- 10,000
- Team
- 50,000
- Business
- 135,000
Amazon product lookups
1 credit per call
- Free
- 100
- Solo
- 10,000
- Team
- 50,000
- Business
- 135,000
Google or YouTube searches
3 credits per call
- Free
- 33
- Solo
- 3,333
- Team
- 16,666
- Business
- 45,000
Instagram rows
9 credits per row returned
- Free
- 11
- Solo
- 1,111
- Team
- 5,555
- Business
- 15,000
LinkedIn profiles
40 credits per row returned
- Free
- 2
- Solo
- 250
- Team
- 1,250
- Business
- 3,375
AI tokens
the allowance itself; unlimited under BYOK
- Free
- 20,000
- Solo
- 3,250,000
- Team
- 15,000,000
- Business
- 37,500,000
Short AI calls
assuming 300 tokens each
- Free
- 66
- Solo
- 10,833
- Team
- 50,000
- Business
- 125,000
Long AI calls
assuming 1,500 tokens each
- Free
- 13
- Solo
- 2,166
- Team
- 10,000
- Business
- 25,000
| Bars are scaled within each row, to its largest cell | Freeone-time, no card | Solo$20/mo, $14 yearly | Team$80/mo, $56 yearly | Business$200/mo, $140 yearly |
|---|---|---|---|---|
| Integration creditsthe allowance itself | 100 | 10,000 | 50,000 | 135,000 |
| Amazon product lookups1 credit per call | 100 | 10,000 | 50,000 | 135,000 |
| Google or YouTube searches3 credits per call | 33 | 3,333 | 16,666 | 45,000 |
| Instagram rows9 credits per row returned | 11 | 1,111 | 5,555 | 15,000 |
| LinkedIn profiles40 credits per row returned | 2 | 250 | 1,250 | 3,375 |
| AI tokensthe allowance itself; unlimited under BYOK | 20,000 | 3,250,000 | 15,000,000 | 37,500,000 |
| Short AI callsassuming 300 tokens each | 66 | 10,833 | 50,000 | 125,000 |
| Long AI callsassuming 1,500 tokens each | 13 | 2,166 | 10,000 | 25,000 |
- AI Chat Agent
- Solo, Team and Business. Not on Free.
- Bring your own key
- Every paid plan. AI becomes unlimited at your provider's rates, and credits rise 50% to 15K, 75K and 202,500.
- Seats
- Team: 100 across 5 licenses. Business: 500 across 15.
- Running out
- You get a heads-up first. Then upgrade, or buy a one-time pack valid 12 months. No overage fees.
From the Marketplace.
Rated 4.8 out of 5 on the Google Workspace Marketplace by the people who installed it. These are their words, unedited.
Featured in
“SheetMagic is truly a gem for those of us working in SEO. The ability to scrape search results and generate content at scale has transformed my workflow.”
Paco B.SEO ProfessionalGoogle Workspace Marketplace
“Started playing with it right away to help us fetch data. The scraping functions are incredibly powerful and save hours of manual work.”
Robin W.Data AnalystGoogle Workspace Marketplace
“Love this tool for AI content creation. Being able to reference cells in prompts makes it incredibly flexible for bulk operations.”
Ale A.Content StrategistGoogle Workspace Marketplace
Who runs it, and the formula they start with.
- SEO agenciesBulk metas, SERP tracking, competitor audits
=GETMETADESCRIPTION(A2) - E-commerce sellersDescriptions at scale, Amazon and price research
=AMAZONSEARCH("shoes", "US", "10001") - Lead generationEnrich lists, find contacts, write first lines
=FINDLEADS(A2) - Virtual assistantsClient content, research, multi-step tasks
=AITEXT("Summarize: " & A2) - Real estateListing copy, comps, rental surveys
=ZILLOWSEARCH(A2) - Marketing agenciesReporting, social monitoring, ad research
=INSTAGRAM(A2) - RecruitersJob market scans, candidate research
=JOBSEARCH("data analyst", "Austin") - Educators and researchersSummaries, translations, structured research
=AITRANSLATE(A2, "Japanese")
Not sure it fits your job? Ask.
Describe the task in plain English. In about ten seconds you get a straight answer, yes, partially or not a fit, plus the exact formulas or Chat Agent prompt to run. No signup, no card.
Already sure?
Installs from the Google Workspace Marketplace in under a minute. Every formula works on the free allowance.
Install free for Google Sheets