Free trial
Text and scraping formulas are free to try with no card and no expiry, alongside a one-time allowance of 100 scraping credits and 20,000 AI tokens. Video and most image models need a paid plan.
Learn moreSheetMagic
AI chat agent and 64 custom formulas living inside Google Sheets
Beginner
What is SheetMagic?
SheetMagic is an AI spreadsheet generator tool. An AI add-on for Google Sheets combining a 93-tool chat agent with 64 custom formulas for text, images, speech and web scraping. Results land directly in cells, with two published usage allowances and a free tier that needs no card.
SheetMagic is a Google Sheets add-on that puts an AI chat agent and a library of custom spreadsheet functions directly into the grid. Rather than exporting data to a separate tool, users describe a job in plain English or type a formula into a cell and let it fill down across rows. The add-on handles text generation, translation, classification, image and vision tasks, speech, video and web scraping from inside the same workbook where the results need to live. The formula layer is the core of the product. Sixty four functions behave like native Google Sheets formulas: reference a cell, drag the fill handle, and the call runs on every row. The set splits into 43 platform scrapers (YouTube, Amazon, LinkedIn, Zillow and others), 13 page and search functions covering any URL, Google, maps, news and shopping, and eight AI functions such as AITEXT. Users who would rather not write formulas can open the Chat Agent sidebar, which reads the sheet, writes cells and formulas, sorts, dedupes, formats, builds charts and pivots, and runs scrapers and generation tasks across 93 tools. It is available on every plan, including Free. The tool suits sales and lead generation teams, SEO and marketing agencies, ecommerce sellers, recruiters, real estate researchers and virtual assistants who already run their workbooks in Google Sheets. Model choice is flexible: OpenAI, Anthropic, Google, Mistral, Perplexity or anything on OpenRouter can be picked from the sidebar without rewriting formulas. Compared with standalone scraping or enrichment services, SheetMagic keeps output native to the sheet, which removes the import and cleanup step. The tradeoff is that it lives entirely inside Google Sheets, so teams working elsewhere would need a different approach. Costs are transparent by design. Usage draws on two separate allowances, scraping credits and AI tokens, each with published rates, and formulas stop when an allowance hits zero rather than incurring overage fees. A free allowance with no card and no expiry covers text and scraping formulas, while video and most image models require a paid plan.
How do you use SheetMagic?
1Install the add-on from the Google Workspace Marketplace
Add SheetMagic to a Google account from the Marketplace listing and grant the requested permissions for the spreadsheet. The free allowance applies immediately with no card required.2Open your sheet and start with a simple AI formula
Type an AITEXT formula that references a cell, then drag the fill handle down the column so each row runs the call on its own input.3Browse the full function reference
Review all 64 functions across platform scrapers, page and search lookups, and AI tasks to pick the right one for a given column.4Try a scraping formula for leads or products
Use a function such as FINDLEADS with job title, location and industry arguments, or an Amazon search, and check the returned table before scaling it down the sheet.5Hand a multi-step task to the Chat Agent
Open the sidebar, describe the outcome in plain English, and let the agent write cells, sort, dedupe, format and build charts or pivots on the open sheet.6Estimate usage before committing to a plan
Run the cost calculator against expected volumes, then pick a plan or a one-time credit pack and note the published rates for each source.
Pros and cons
Pros
- AI and scraping functions behave like native formulas, so dragging one down fills every rowAI
- Published per-call and per-row rates, with formulas stopping at zero instead of charging overageAI
- Chat Agent is included on every plan, including the free one-time allowanceAI
- Model choice spans OpenAI, Anthropic, Google, Mistral, Perplexity and OpenRouter without changing formulasAI
- Bring your own key on paid plans makes AI usage unlimited at the provider's own ratesAI
Cons
- Free tier is a one-time allowance with no refill, so sustained work needs a paid planAI
- Unused credits and tokens do not roll over between billing cyclesAI
- Video and most image models are locked to paid plansAI
- LinkedIn profile rows cost 40 credits each, which burns through smaller allowances quicklyAI
- No native path for teams whose data lives outside Google SheetsAI
How much does SheetMagic cost?
Pricing
Free is a one-time allowance with no card: 100 scraping credits and 20,000 AI tokens. Solo is $20 monthly, $17 quarterly or $14 yearly; Growth $80, $68 or $56; Scale $200, $170 or $140. Paid plans refill credits and tokens each cycle, share one pool across licenses, and add 50 to 67 percent more credits under bring your own key.
Learn moreIntegrations
Runs as a Google Sheets add-on installed from the Google Workspace Marketplace, with scrapers for platforms including YouTube, Amazon, LinkedIn and Zillow. AI model access spans OpenAI, Anthropic, Google, Mistral, Perplexity and OpenRouter.
Learn moreFeatures
A 93-tool Chat Agent that reads and edits the open sheet, plus 64 custom formulas: 43 platform scrapers for YouTube, Amazon, LinkedIn, Zillow and more, 13 page and search functions, and eight AI functions for text, lists, translation, image, vision, speech and video. Model choice covers OpenAI, Anthropic, Google, Mistral, Perplexity and OpenRouter.
Learn moreFrequently asked questions about SheetMagic
How much does SheetMagic cost?
Free is a one-time allowance with no card: 100 scraping credits and 20,000 AI tokens. Solo is $20 monthly, $17 quarterly or $14 yearly; Growth $80, $68 or $56; Scale $200, $170 or $140. Paid plans refill credits and tokens each cycle, share one pool across licenses, and add 50 to 67 percent more credits under bring your own key.Does SheetMagic offer a free trial?
Text and scraping formulas are free to try with no card and no expiry, alongside a one-time allowance of 100 scraping credits and 20,000 AI tokens. Video and most image models need a paid plan.How do you use SheetMagic?
The walkthrough on this page covers 6 steps: 1. Install the add-on from the Google Workspace Marketplace 2. Open your sheet and start with a simple AI formula 3. Browse the full function reference 4. Try a scraping formula for leads or products 5. Hand a multi-step task to the Chat Agent 6. Estimate usage before committing to a plan.What platforms does SheetMagic support?
SheetMagic is available on Web App and Browser extension.What does SheetMagic integrate with?
Runs as a Google Sheets add-on installed from the Google Workspace Marketplace, with scrapers for platforms including YouTube, Amazon, LinkedIn and Zillow. AI model access spans OpenAI, Anthropic, Google, Mistral, Perplexity and OpenRouter.What are the limitations of SheetMagic?
Free tier is a one-time allowance with no refill, so sustained work needs a paid plan. Unused credits and tokens do not roll over between billing cycles. Video and most image models are locked to paid plans.
Status
StatusActive
Views0
Outbound clicks0
Added10/21/2026
Platforms
Web AppBrowser extension
Pricing
FreeFreemiumSubscription
