SheetMagic Documentation
Complete guide to SheetMagic - AI-powered Google Sheets add-on for text generation, image creation, and web scraping
Introduction
SheetMagic is a powerful Google Sheets add-on that brings AI capabilities and web scraping directly into your spreadsheets. Generate AI content, create images, analyze visuals, and scrape web data using simple formulas.
Key features include:
- AI Text Generation - Generate content with any modern AI model using
=AITEXT() - AI Image Generation - Create stunning images from text prompts with
=AIIMAGE() - AI Vision Analysis - Analyze images with AI using
=GPTV() - Text-to-Speech - Convert text to audio with
=AISPEECH() - AI Video Generation - Create videos from prompts with
=AIVIDEO() - Web Scraping - Extract content from any webpage with
=VISIT() - SERP Scraping - Get search engine results with
=SERP()
Quick Start
Here's how easy it is to get started with SheetMagic:
=AITEXT("Write a product description for a wireless mouse")=AITEXT("Write a product description for: " & A1)=AIIMAGE("A professional photo of a modern coffee shop interior")Core Functions
SheetMagic provides several categories of functions:
AI Text Functions
Generate AI text content with AITEXT, create vertical lists with AILIST, or horizontal lists with AILISTH. Works with all major AI providers including OpenAI, Claude, Gemini, and more.
AI Media Functions
Create images with AIIMAGE using DALL-E, Imagen, or other models. Generate speech audio with AISPEECH. Create videos with AIVIDEO using Sora or Veo.
AI Vision
Analyze any image using GPTV. Extract text, describe content, identify objects, and more from any publicly accessible image URL.
Web Scraping
Extract webpage content with VISIT, get structured page data with PAGEDATA, scrape specific elements with GETSELECTOR, and extract images with GETIMG.
Search Scraping
Get search engine results with SERP and BULKSERP. Filter by region and time period for targeted research and SEO analysis.
Page Data Functions
Extract meta titles, descriptions, headings, and paragraphs from any URL. Check domain availability with DOMAINCHECK.
Supported AI Providers
SheetMagic supports 5 major AI providers with hundreds of models:
| Provider | API Key Source | Features |
|---|---|---|
| OpenAI | platform.openai.com | GPT-5, GPT-4o, DALL-E, Sora, TTS |
| Claude | console.anthropic.com | Claude Opus, Sonnet, Haiku |
| Google Gemini | aistudio.google.com | Gemini 2.5, Imagen, Veo |
| OpenRouter | openrouter.ai | 100+ models from 15+ providers |
| Straico | platform.straico.com | 60+ aggregated models |
Installation
Install the Add-on
Install SheetMagic from the Google Workspace Marketplace.
Configure Your API Key
Open SheetMagic settings in Google Sheets and enter your API key from your preferred provider (OpenAI, Claude, Gemini, OpenRouter, or Straico).
Example Use Cases
Content Generation
=AITEXT("Write a 100-word blog introduction about " & A1)Product Descriptions
=AITEXT("Write a compelling product description for: " & B2 & ". Highlight these features: " & C2)Image Analysis
=GPTV(A1, "Describe this product image in detail")SEO Research
=SERP("best " & A1 & " tools 2024", 20, "us-en")Competitor Analysis
=VISIT(A1)Extract and analyze content from competitor websites.
Bulk Data Extraction
=PAGEDATA(A1:A100)Get title, description, H1, and status for up to 100 URLs at once.
Tip: Use cell references with the & operator to create dynamic prompts that pull data from other cells in your spreadsheet.
Function Categories
Explore the detailed documentation for each function category:
- AI Text Functions - AITEXT, AILIST, AILISTH
- AI Media Functions - AIIMAGE, AISPEECH, AIVIDEO, GPTV
- Web Scraping Functions - VISIT, GETSELECTOR, GETIMG
- SERP Functions - SERP, BULKSERP
- Page Data Functions - PAGEDATA, GETMETATITLE, GETMETADESCRIPTION, GETH1, GETH2, GETHEADINGS, GETP
- Utility Functions - DOMAINCHECK
AI Providers & Models
Learn about all supported AI providers and their available models:
- OpenAI Models - GPT-5, GPT-4o, o1, DALL-E, Sora
- Claude Models - Opus, Sonnet, Haiku
- Gemini Models - Gemini 2.5, Imagen, Veo
- OpenRouter Models - 100+ models from multiple providers
- Straico Models - Aggregated models from 10+ providers
API Keys Required: SheetMagic requires your own API keys from your chosen provider. This means you pay the provider directly with zero markups from SheetMagic.