Quick Start

Get started with SheetMagic and supercharge your Google Sheets with AI in minutes.

What is SheetMagic?

SheetMagic is a powerful Google Sheets add-on that brings AI capabilities and web scraping directly into your spreadsheets. Use simple formulas to generate content, create images, analyze data, and extract information from the web.

Key Features

AI Text Generation

Generate content with GPT-5, Claude, Gemini, and 100+ more models

AI Image & Video

Create images with DALL-E, Imagen, and videos with Sora, Veo

Web Scraping

Extract data from any website with simple formulas

5 AI Providers

OpenAI, Claude, Gemini, OpenRouter, and Straico supported

5-Minute Setup

Install SheetMagic

Install SheetMagic from the Google Workspace Marketplace.

Get an API Key

Get an API key from your preferred provider:

Configure SheetMagic

Open SheetMagic in Google Sheets (Extensions → SheetMagic) and enter your API key.

Start Using Formulas

Use SheetMagic formulas in any cell:

=AITEXT("Write a product description for a wireless mouse")

Your First Formula

Try these formulas to see SheetMagic in action:

AI Text Generation

=AITEXT("Write a short product description for: wireless bluetooth headphones")

AI Text with Cell Reference

=AITEXT("Translate to Spanish: " & A1)

Generate a List

=AILIST("List 5 benefits of remote work")

Scrape a Webpage

=VISIT("https://example.com")

Core Functions

// Generate AI text
=AITEXT("Your prompt here")

// Create vertical lists
=AILIST("Generate 10 blog ideas about coffee")

// Create horizontal lists
=AILISTH("List 5 product categories")

// Generate images
=AIIMAGE("A modern office workspace, minimalist design")

// Analyze images
=GPTV(A1, "Describe this product")

// Text-to-speech
=AISPEECH("Welcome to our demo", "nova")

// Generate video
=AIVIDEO("Product rotating on white background")

// Get page content
=VISIT("https://example.com")

// Get specific elements
=GETSELECTOR("https://example.com", ".price")

// Get all images
=GETIMG("https://example.com")

// Get page metadata
=PAGEDATA(A1:A10)

// Search the web
=SERP("best coffee makers 2024", 20)

// Search with filters
=SERP("AI news", 20, "us-en", "w")

// Horizontal results
=BULKSERP("CRM software", 5)