SheetMagic
SheetMagic is an AI tool that combines the functionality of Google Sheets with comprehensive data scraping and AI capabilities. It empowers users to generate AI...
Last verified:
What is SheetMagic?
SheetMagic is a powerful Google Sheets add-on that integrates AI capabilities and web scraping directly into spreadsheets, allowing users to generate text, images, videos, audio, and extract web data using simple formulas without leaving their sheets. It supports a wide range of AI models from providers like OpenAI (GPT-4o, DALL-E 3, Sora 2), Claude, Gemini, and more via OpenRouter and Straico, with BYOK options for unlimited usage at provider rates. Key features include bulk AI text generation with =AITEXT(), image creation with =AIIMAGE(), vision analysis via =GPTV(), speech synthesis with =AISPEECH(), video generation using =AIVIDEO(), web scraping with =VISIT() and =GETSELECTOR(), SERP scraping with =SERP(), and page data extraction functions like =PAGEDATA() and =GETMETATITLE().
Designed for e-commerce professionals generating product descriptions and images, SEOs conducting keyword research and competitor SERP monitoring, marketers creating content and ads at scale, sales teams researching leads, and data analysts automating data collection and cleaning. It enables dynamic prompts referencing cells for personalized bulk processing, asynchronous operations for large datasets, multi-language support, and team collaboration with shared seats. Setup is quick: install from Google Workspace Marketplace, authenticate, validate license, and start using formulas.
SheetMagic eliminates the need for separate tools or coding, turning spreadsheets into AI powerhouses for research, content creation, and automation. With intelligent caching, JavaScript handling, and region/time filters for scraping, it handles complex workflows efficiently. It's ideal for freelancers, small teams, and agencies needing scalable, no-code solutions within familiar Google Sheets environment.
SheetMagic pricing
Pricing model: Paid
Free tier with 3K tokens to start, no credit card required. Paid plans: Solo $19/mo (3M tokens, 1K credits, 1 seat); Team $79/mo (15M tokens, 5K credits, 5 seats); Business $149/mo (80M tokens, 20K credits, 15 seats). Yearly billing saves 16%. All plans include all features, BYOK for unlimited AI, tokens/credits reset monthly without rollover. One-time credit packs available mid-cycle.
SheetMagic pros
- Simple formula-based usage like =AITEXT()
- Supports 50+ AI models including GPT-4o and Claude
- BYOK for unlimited AI at provider rates
- Bulk processing for 1000+ rows asynchronously
- AI image generation with DALL-E 3 and Flux
- Web scraping handles JavaScript pages
- SERP scraping with region and time filters
- AI vision for image analysis in cells
- Text-to-speech with 11 voice options
- AI video generation via Sora 2 and Veo 3
- Dynamic cell-referenced prompts
- Team seats for collaboration
- Multi-language content generation
- 30-minute intelligent caching
- No coding or external tools required
- Quick 3-minute setup process
- Extracts meta titles and headings easily
SheetMagic cons
- Requires paid OpenAI or other API keys
- Tokens and credits reset monthly, no rollover
- Separate limits for AI tokens and credits
- Google Sheets only, no Excel support
- Limited mobile functionality
- Potential rate limits on bulk operations
- Dependent on third-party AI providers
- Integration credits needed for scraping
- No overage usage, must upgrade or buy packs
Frequently asked questions about SheetMagic
Do I need my own API key?
Yes, SheetMagic requires your own OpenAI, Anthropic, Google, or other provider API keys for AI functions via BYOK, allowing unlimited usage at provider rates with zero markup from SheetMagic.
What AI models does SheetMagic use?
Supports GPT-5.2, GPT-4o, Claude Opus 4.6, Gemini 2.5 Pro, DALL-E 3, Sora 2, Imagen 4, Llama models, and 350+ via OpenRouter and 60+ via Straico, with dynamic auto-loading of new models.
What are tokens and credits?
AI tokens power text, image, video, vision, and speech functions (e.g., 3M/mo Solo); integration credits cover non-AI scraping and SERP (e.g., 1K/mo Solo). Both reset monthly, no rollover.
Does SheetMagic work on mobile?
Limited mobile support as it's optimized for desktop Google Sheets; full formula editing and sidebar features work best on desktop browsers.
Can I use SheetMagic without an OpenAI key?
No, an API key from OpenAI or compatible provider is required for AI features; web scraping functions like =VISIT() use integration credits independently.
How do I give SheetMagic access to my team?
Share your license key from the dashboard; team plans include multiple seats for collaborators to use on shared sheets without individual licenses.
What happens when I hit my limit?
Receive heads-up notifications; upgrade plan instantly for more allowance or buy one-time token/credit packs valid 12 months, no overage fees.
Does SheetMagic work with Excel?
No, SheetMagic is exclusively a Google Sheets add-on installed via Google Workspace Marketplace, not compatible with Microsoft Excel.
Can I switch plans anytime?
Yes, upgrade instantly; downgrades or cancellations apply at next billing cycle, no contracts or fees, access until period ends.
Do web scraping features use OpenAI credits?
No, scraping like =VISIT(), =SERP(), =GETSELECTOR() uses integration credits only, completely separate from AI tokens and free of AI provider costs.