AI-Powered Google Sheets for Education
Generate quizzes, create lesson plans, and build grading rubrics, all inside the Google Sheets your school already uses.
No card, no expiry.
- Users
- 6,300+
- Marketplace rating
- 4.8/5
What you run.
Quiz & Assessment Generator
AI tokensType a topic and difficulty level. SheetMagic generates multiple-choice questions, short answers, and rubrics instantly.
=AITEXT("Write a product description for: " & A1)Curriculum Research via Search
creditsFind articles, datasets, and educational resources for any topic. Pull search results directly into your lesson planning sheet.
=SERP("best coffee shops in NYC", 20, "us-en", "d")YouTube Transcripts for Research
credits, backgroundFetch full video transcripts with one formula: build reading materials, summaries, and citations from lecture content.
=YTTRANSCRIPT({"https://youtube.com/watch?v=dQw4w9WgXcQ"})
What each source costs.
Scrapers and lookups spend integration credits. Instant sources bill per call; background sources bill per row returned, so a 20-row pull costs a fraction of a 500-row one. Every rate is published before you run it.
Public pages only. Background scrapes take up to about a minute and show a placeholder first. Every source and its rate
Shared axis, 0 to 84 credits, the dearest rate in the catalog.
What a plan buys.
Free is a one-time allowance, not a trial: 20,000 AI tokens and 100 credits, every formula included. Solo is $20 a month, or $14 on yearly billing, and adds the AI Chat Agent. Bring your own AI key on any paid plan and credits rise 50%.
Compare plansFree credits
100one-time
No card, no expiry. Usage-based nudges only.
Solo credits
10,000a month
15K with your own AI key connected.
Solo AI tokens
3.25Ma month
Unlimited on your own key, at your provider's rates.
Questions people ask before installing.
Can I generate different difficulty levels of the same quiz?
Yes. Use AITEXT with a prompt specifying the difficulty: "Generate 10 multiple-choice questions about photosynthesis for Grade 8, difficulty: easy/medium/hard." Create three columns for three levels.
Does it work with Google Classroom?
SheetMagic works inside Google Sheets, which integrates natively with Google Classroom. Generate your content in Sheets, then share or import into Classroom as usual.
Is there a discount for educators?
The free plan includes 20,000 AI tokens as a one-time free allowance, enough to explore all features. Schools and districts can contact us for volume pricing.
Install it, then drag the formula down.
6,300+ users. Free includes 20,000 AI tokens and 100 credits, one-time, no card.