20 AI Functions — Free to Start

AI Superpowers for
Google Sheets

Use Claude AI directly in your spreadsheets. Summarize, translate, analyze, generate content — all with a simple formula.

Install from Google Workspace See all 20 functions

Free tier: 50 calls/month, no credit card required

=AI_SENTIMENT(A1)

Returns

Positive (0.94)

Instant sentiment analysis with confidence score

=AI_TRANSLATE(A1, "Spanish")

Returns

Hola, esto es una traduccion...

Translate to any language in one formula

=AI_CATEGORIZE(A1, "B2:B10")

Returns

Electronics

Auto-categorize data into your custom groups

=AI_EXTRACT(A1, "email addresses")

Returns

john@example.com, jane@co.com

Pull any data type from unstructured text

=AI_SEO_TITLE(A1)

Returns

Best Running Shoes 2025: Top Picks

SEO-optimized titles in under a second

=AI_SUMMARIZE(A1, "short")

Returns

A brief summary of the key points...

Summarize any length text instantly

All 20 Functions

Everything your spreadsheet needs

Four categories of AI tools, each designed to work seamlessly in any cell.

Text Processing

=AI(prompt) — General AI
=AI_SUMMARIZE() — Summarize
=AI_TRANSLATE() — Translate
=AI_REWRITE() — Rewrite style
=AI_FIX_GRAMMAR() — Fix grammar
=AI_EXTRACT() — Extract data

Analysis

=AI_SENTIMENT() — Sentiment
=AI_CATEGORIZE() — Categorize
=AI_KEYWORDS() — Keywords
=AI_TOPICS() — Topics

Data Processing

=AI_CLEAN() — Clean data
=AI_PARSE() — Parse text
=AI_DEDUPLICATE() — Find dupes
=AI_FILL() — Smart fill

Business

=AI_EMAIL() — Email drafts
=AI_REVIEW_RESPONSE() — Reviews
=AI_PRODUCT_DESCRIPTION()
=AI_HEADLINE() — Headlines
=AI_HASHTAGS() — Hashtags
=AI_SEO_TITLE() — SEO titles

Pricing

Start free. Scale when you're ready.

No credit card required to get started. Upgrade at any time.

Free

forever

✓ 50 AI calls / month
✓ All 20 functions
✓ 6-hour response caching
✓ Community support

Install Free

Common questions

How do I install WellerDeveler SheetMagic?

Install from the Google Workspace Marketplace. After installing, open any Google Sheet, click Extensions > WellerDeveler SheetMagic > Open Settings. You can start using the free tier immediately — no API key needed. Just type =AI() in any cell.

Do I need my own Claude API key?

No. WellerDeveler SheetMagic includes a shared API key for all tiers. The free tier uses a shared key with a 50 call/month limit. On Pro and Business plans, you can optionally add your own Anthropic API key to bypass all call limits. Get one at console.anthropic.com.

How does billing work?

Pro and Business plans are sold as monthly license keys through Gumroad. After purchase you receive a license key by email. Enter it in WellerDeveler SheetMagic > Settings > License Key to activate your plan. You can cancel at any time.

Is my data private?

Cell data is sent to Anthropic's Claude API for processing. WellerDeveler SheetMagic itself does not store your spreadsheet content. Responses are cached locally in your browser for 6 hours to improve performance. See our Privacy Policy for full details.

Why are my formulas returning errors?

The most common cause is hitting the rate limit (10 calls/minute). Wait a moment and try again. Also check that you have calls remaining for the month (WellerDeveler SheetMagic > View Usage). If you see "No API key" errors, open WellerDeveler SheetMagic > Settings. For other errors, check our documentation.

Can I use WellerDeveler SheetMagic on large datasets?

Yes. Functions like =AI_SENTIMENT() and =AI_CATEGORIZE() can be applied to entire columns. The 6-hour cache means repeated calls on the same cell text are instant and don't count against your monthly limit. For large batch jobs, we recommend the Business plan with unlimited calls.

AI Superpowers forGoogle Sheets

Everything your spreadsheet needs

Start free. Scale when you're ready.

Common questions

Your spreadsheet, supercharged

AI Superpowers for
Google Sheets