SheetMagicSheetMagic

Powerful Features for Google Sheets

Generate text, create images, make videos, and scrape the web. All without leaving your favorite cells. Your spreadsheet just got superpowers.

AI Features

Generate text, images, audio, and video directly in your spreadsheets

AI Text Generation

Generate bulk AI content with simple formulas

  • =AITEXT() - Generate content with any prompt
  • =AITEXT(prompt, context, TRUE) - Real-time web search with OpenAI, Claude, and Perplexity
  • =AILIST() - Create vertical lists with AI
  • =AILISTH() - Create horizontal lists with AI
  • All modern AI models included (GPT-5, Claude, Gemini, and more)
  • Link cells to prompts using the & operator
  • Asynchronous processing for large batches
=AITEXT("Write a product description for: " & A1)

AI Image Generation

Create and edit images with AI

  • =AIIMAGE() - Generate images from text prompts
  • DALL-E 3, Imagen 4, Flux, Gemini 3 Pro Image, Gemini 3.1 Flash Image
  • Edit and refine images with multi-turn conversational prompts
  • Perfect for product images and marketing assets
  • Returns image URLs directly in cells
  • Batch generate multiple images at once
=AIIMAGE("A professional photo of a modern coffee shop")

AI Vision

Analyze images with AI vision models

  • =GPTV() - Analyze images with custom prompts
  • Extract text, describe content, identify objects
  • Perfect for image cataloging and analysis
  • Works with any publicly accessible image URL
  • Powered by GPT-4o vision capabilities
=GPTV(A1, "Describe this product image")

AI Text-to-Speech

Convert text to natural-sounding audio

  • =AISPEECH() - Generate speech from text
  • 11 different voice options (alloy, nova, onyx, and more)
  • Perfect for audio content and accessibility
  • Returns audio file URLs
  • Professional-quality voice synthesis
=AISPEECH("Welcome to our product demo", "nova")

AI Video Generation

Create videos from text descriptions

  • =AIVIDEO() - Generate videos from prompts
  • Sora 2, Veo 3, Runway Gen 4 support
  • Perfect for marketing and social content
  • Returns video file URLs
  • High-quality cinematic output
=AIVIDEO("Product showcase, rotating 360 degrees")

Web Scraping Features

Extract data from any website with powerful scraping functions

Web Scraping

Extract content from any webpage

  • =VISIT() - Get entire page content (up to 50K chars)
  • =GETSELECTOR() - Custom CSS selector scraping
  • =GETIMG() - Extract all image URLs from a page
  • =PAGEDATA() - Bulk extract metadata from URLs
  • Handles JavaScript-rendered pages
  • 30-minute intelligent caching
=VISIT("https://example.com")

Page Data Extraction

Extract specific SEO and page elements

  • =GETMETATITLE() - Get page meta title
  • =GETMETADESCRIPTION() - Get meta description
  • =GETH1() - Get main H1 heading
  • =GETH2() - Get all H2 headings
  • =GETHEADINGS() - Get all headings (H1-H6)
  • =GETP() - Get all paragraph text
=PAGEDATA(A1:A100)

SERP Scraping

Get search engine results in your sheets

  • =SERP() - Get up to 20 search results per query
  • =BULKSERP() - Get results in horizontal format
  • Filter by region (us-en, uk-en, de-de, etc.)
  • Filter by time (day, week, month, year)
  • Perfect for SEO research and competitive analysis
  • Powered by DuckDuckGo for reliable results
=SERP("best coffee shops in NYC", 20, "us-en", "d")

Domain Checking

Check domain availability instantly

  • =DOMAINCHECK() - Check if domains are available
  • Supports .com, .io, .ai, .co, and 20+ TLDs
  • Powered by RDAP protocol
  • Perfect for brand research
  • Batch check multiple domains at once
=DOMAINCHECK("mybrand.com")

Supported AI Providers

Connect your own API keys from any of these providers

🤖

OpenAI

GPT-5, GPT-4o, o1, o3, DALL-E 3, Sora 2, TTS

🧠

Claude

Opus 4.6/4.5, Sonnet 4.6/4.5/4, Haiku 4.5 + Web Search

✨

Google Gemini

Gemini 2.5 Pro/Flash, Gemini 3 Pro/Flash Image, Imagen 4, Veo 3

🔄

OpenRouter

100+ models from 15+ providers

🎯

Straico

60+ models, images, video, audio

And Much More...

No Coding Required

Simple formulas anyone can use

Cell References

Dynamic prompts with cell linking

Team Collaboration

Share across your entire team

Multi-Language

Works in any language

Zero Markups

Use your own API keys

Unlimited Usage

No limits on AI calls

All Functions at a Glance

AI Functions

  • =AITEXT()
  • =AILIST()
  • =AILISTH()
  • =AIIMAGE()
  • =GPTV()
  • =AISPEECH()
  • =AIVIDEO()

Scraping Functions

  • =VISIT()
  • =GETSELECTOR()
  • =GETIMG()
  • =SERP()
  • =BULKSERP()
  • =DOMAINCHECK()

Page Data Functions

  • =PAGEDATA()
  • =GETMETATITLE()
  • =GETMETADESCRIPTION()
  • =GETH1()
  • =GETH2()
  • =GETHEADINGS()
  • =GETP()

Simple, Transparent Pricing

Every plan includes full access to all features. Choose based on your usage needs.

AI Tokens

AI tokens power every AI operation—text generation, image creation, video, vision analysis, and speech. Each plan gets a monthly allowance: Solo (3M), Team (15M), Business (80M). Tokens reset at the start of each billing cycle—unused tokens don't roll over, so use them while you have them.

Learn about AI tokens →

Integration Credits

Integration credits are separate from AI tokens and power non-AI operations—web scraping (VISIT, GETSELECTOR), SERP searches, domain checks, and page data extraction. Monthly allowance: Solo (1K), Team (5K), Business (20K). Like tokens, credits reset monthly and don't roll over. Each function has a fixed credit cost so you always know what you're spending.

View credit costs →

BYOK: Unlimited with Your Own Keys

For power users and enterprises. Connect your own API keys from OpenAI, Anthropic, Google, or any provider. Pay them directly with zero markups from us—unlimited AI at cost.

Ready to supercharge your spreadsheets?

Join 3,900+ professionals using SheetMagic to automate their work. Start free with 1K tokens—no credit card required.

Start FreeCompare Plans