A course · made with AI
All Green
Google Sheets automations with AI, for people who don't code.
Build eight everyday Google Sheets automations with an AI chat, and learn to check each one on practice rows before it touches your real data.
9 lessons · about 320 minutes of doing (5.3 hours, by our time model) · a free Google account · an AI chat · no coding experience needed
$29 once, tax included
Sold by Polar, our merchant of record. Full refund within 30 days of purchase if it doesn't work for you — email support@newellabs.com. Finished lesson 1? Your workbook shows a code for $5 off when its exam is all green. Every update and every added lesson included. No countdown, no "was" price.
Made with AI. This course was written and built by Claude, an AI model made by Anthropic, for Newel Labs. Every workbook, formula and script was tested in our own Google Sheets simulator. Lessons 1 to 3 were checked in Google Sheets on a free gmail.com Google account on 17 Nov 2026 (edition 1.0; the one check line that check found wrong is fixed in edition 1.1 and tested in our simulator). Lessons 4 to 9 were checked in Google Sheets on a free gmail.com Google account on 18 Nov 2026, in the United States locale: each menu item of lessons 4 to 8 with its Check tab, on the practice rows (in lessons 7 and 8 the exam rows too), a red run in each of lessons 4, 7 and 8, one run started by a one-off timer in each of lessons 6 and 8, and lesson 9's formula chore. Lesson 7 ran in PRACTICE mode only, lesson 8 never in LIVE mode, and no real form answer was sent. The time zone step and the corrected screen words came after that check, from what it saw; the time zone step is tested in our simulator.
How every lesson works
Describe → Ask → Read → Paste → Check → Fix → Exam → Make it yours → Go live
- The sheet writes the prompt. In lessons 1 to 8 you fill two to four cells on the Describe tab; the sheet builds the request from its own tab and column names and invented practice rows, and none of your own data goes into the prompt. In lesson 9 you describe a chore of your own and type four test rows yourself: invented ones, never your customers' real data.
- Your AI writes the formula or script. You paste the prompt into your AI chat and copy its answer back.
- The sheet checks it. A Check tab grades the answer line by line, PASS or FAIL in words, on practice rows and then on exam rows the AI never saw. Every red line names a fix card with words to paste back to your AI.
- Practice before it acts. From lesson 4, every script has a practice mode that only writes to a Log what it would do; for the scripts that email, then a run that sends only to you; then the real run. Every automation has an off switch.
The learner never has to judge code by eye: the lesson's sheet judges the AI's work, and the lesson explains the verdict.
The nine lessons
Part 1 · Formulas the AI writes (nothing gets deleted)
- Lesson 1 · Flag what's due (free), about 25 minutes. Your own task list that labels every task Overdue, Due soon, OK, Done or Check date, and tints its row.
- Lesson 2 · A tab that fills itself, about 15 minutes. A Done tab that always lists your finished tasks, newest first, without moving or deleting a single row. One formula does it, with FILTER and SORT.
- Lesson 3 · Clean a messy export, about 30 minutes. A Clean tab that tidies an export with name, email, date and amount columns: names split and capitalised, emails in small letters, real dates, real numbers, and repeated customers marked. Six formulas, one per column, each checked on its own. Then you run it on an export of your own.
Part 2 · Scripts you run with a button (practice run first)
- Lesson 4 · Archive finished rows with one click, about 50 minutes. A menu item, Automations > Archive finished rows, that copies every finished task to an Archive tab, stamps it with today's date, and removes it from your task list, without ever losing a row.
- Lesson 5 · Reminder emails, two days before the due date, about 45 minutes. A menu item, Automations > Send due-soon reminders, that, when you run it, emails the owner of each task due in exactly two days, once, and writes the date it did so in a Reminded on column. Before it emails anyone, it rehearses twice: a practice run that sends nothing, and a TO ME run that sends everything to you.
Part 3 · Automations that run on their own (each with an off switch)
- Lesson 6 · A weekly summary in your inbox, about 40 minutes. Every Monday between 8 and 9 in the morning, an email with last week's numbers: paid orders, sales, refunds. The numbers come from five formulas on a Summary tab; a short script sends them. A menu item Start weekly summary makes the timer (and never two), Stop weekly summary removes it.
- Lesson 7 · When a form answer arrives, about 40 minutes. A form intake tracker. Every answer that arrives through your Google Form gets a Request ID and an Owner, and you get a short notice by email.
- Lesson 8 · Alert me when stock runs low, about 45 minutes. A low-stock alert on a daily timer. Every morning a script looks at every item, emails you one list of the items at or below their minimum, once per item until it is restocked, and writes the date it did so.
Part 4 · Your own
- Lesson 9 · Bring your own chore, about 30 minutes for the worked example. Your own automation, for a chore from your own week, with its own checks: your four test rows, the results you expect typed in before the AI writes anything, and the sheet comparing them after. And the method for the next one.
Times are our time model's: every word read at an average adult's reading speed (238 words a minute), every click and keystroke timed, the AI's answers at the speed we measured, and no wrong turns. Nobody has timed a real learner yet.
What you get
- The course (PDF): all nine lessons and the cards, the step-throughs as numbered pictures, the licence on page 1 (20.4 MB)
- Course reader (ZIP): all nine lessons and the cards as web pages that work offline, with the step-throughs and copy buttons; open index.html (24.7 MB)
- Workbooks (ZIP): the 9 workbooks (lessons 1 to 8 and the blank one for lesson 9), the reference answers and the fix-practice files (step 8b) (430 KB)
- Step-throughs (ZIP): 33 silent videos (MP4, 1280x720), the same drawings as in the reader (39.7 MB)
9 workbooks (eight lessons and a blank one for your own chore), each with its own Check tab and fix cards; 33 step-throughs drawn by our code (drawings, not screenshots, and they say so); the PDF is 146 pages. Files we add later reach you too.
Your licence: for your own use, at home or at work. The workbooks, and the formulas and scripts you build in them, are yours to use and change for your own tasks and your own business. Please don't share, resell or re-upload the course files (lessons, PDF, reader, workbooks, cards).
How it was tested
Every formula and script check was proven in our own Google Sheets simulator in both directions: the reference answer passes every line, and every known wrong answer fails on its line. A second formula engine, which follows Excel's rules, agreed with the simulator on every cell it could compare (for lessons 4 to 9 in one green and one red state each). Then each lesson's prompt went to two AI models in fresh conversations, and every answer was graded by the lesson's own workbook in the simulator:
| Lesson and prompt: all green on the first try | Claude Sonnet 5.5 | Claude Haiku 5.5 |
|---|---|---|
| 1. Flag what's due: the prompt the sheet writes | 20 of 20 | 20 of 20 |
| 2. A tab that fills itself: the prompt the sheet writes | 20 of 20 | 20 of 20 |
| 3. Clean a messy export: the prompt the sheet writes | 20 of 20 | 20 of 20 |
| 4. Archive finished rows with one click: the prompt the sheet writes | 20 of 20 | 20 of 20 |
| 5. Reminder emails, two days before the due date: the prompt the sheet writes | 20 of 20 | 20 of 20 |
| 6. A weekly summary in your inbox: the formulas prompt | 20 of 20 | 20 of 20 |
| 6. A weekly summary in your inbox: the script prompt | 20 of 20 | 20 of 20 |
| 7. When a form answer arrives: the prompt the sheet writes | 20 of 20 | 20 of 20 |
| 8. Alert me when stock runs low: the prompt the sheet writes | 20 of 20 | 20 of 20 |
| 9. Bring your own chore: worked chore A (a formula), after the AI's questions | 20 of 20 | 20 of 20 |
| 9. Bring your own chore: worked chore B (a script), after the AI's questions | 20 of 20 | 19 of 20 |
1,084 conversations counted in all, through Claude Code with a plain setup, run on 2 Nov (lessons 1 to 3) and 17 Nov 2026 (lessons 4 to 9) and all graded again on 17 Nov 2026. Lessons 4 and 6: after one rewording of the prompt while they were built; lessons 6, 7 and 9: after one more, on 17 Nov, when our reviews found a gap; the earlier wordings' runs are on their prompt cards and not counted. Each lesson's prompt card prints its own record, the shorter requests we compared it with and what they missed, and the grader's limits. Lesson 1's prompt was also tried once in Gemini (free, signed in), in Google Sheets. Not tested: ChatGPT, Copilot or the claude.ai chat itself; your AI may answer differently, which is why every lesson's workbook checks the answer itself.
Who it is for
- People who use Google Sheets every week and repeat the same chores: reminders, moving finished rows, cleaning exports, weekly summaries, form answers, stock alerts.
- People who heard "an AI can write a script for that", but don't code, or tried and didn't dare run what it wrote.
- A free Google account (gmail.com), or a work account where Extensions > Apps Script opens (we have not checked a work account).
Not for
- Coders who want JavaScript or Apps Script in depth: Google's free codelab "Fundamentals of Apps Script with Google Sheets" is a better start.
- Complete beginners in spreadsheets: learn to type in cells and add a tab first.
- Excel users: the lessons and their screens are for Google Sheets.
- Bulk or marketing email: a script on a gmail.com account may email 100 recipients a day (Google's Apps Script quota), and the course emails only people who expect it.
Questions
Do I need to pay for an AI?
No, a free one is enough to try: whatever your AI writes, the lesson's checks grade it. We tested every prompt with Claude Sonnet 5.5 and Claude Haiku 5.5 through Claude Code. On 17 Nov 2026 we also tried lesson 1's prompt once in Gemini, free and signed in: its formula had every flag line green in Google Sheets. The script lessons' prompts were not tried in a free chat, and we did not test ChatGPT, Copilot or the claude.ai chat itself.
Does my data go to the AI?
Only what you paste. In lessons 1 to 8 the prompts the sheets write hold invented practice rows, never your tasks or customers. In lesson 9 the prompt carries your own column names, your chore in your words and four test rows you type: the lesson asks you to invent them. When you use the formula or script on your own rows, it runs inside your Google Sheets, not in the AI.
Do I need Gemini or a paid Google plan?
No. The course uses no paid features and is built for a free Google account. Lessons 1 to 3 were checked in Google Sheets on a free gmail.com Google account on 17 Nov 2026 (edition 1.0; the one check line that check found wrong is fixed in edition 1.1 and tested in our simulator). Lessons 4 to 9 were checked in Google Sheets on a free gmail.com Google account on 18 Nov 2026, in the United States locale: each menu item of lessons 4 to 8 with its Check tab, on the practice rows (in lessons 7 and 8 the exam rows too), a red run in each of lessons 4, 7 and 8, one run started by a one-off timer in each of lessons 6 and 8, and lesson 9's formula chore. Lesson 7 ran in PRACTICE mode only, lesson 8 never in LIVE mode, and no real form answer was sent. The time zone step and the corrected screen words came after that check, from what it saw; the time zone step is tested in our simulator.
I use Google Sheets at work. Will the scripts run?
Open a sheet and click Extensions > Apps Script. If the editor does not open, only the formula lessons (1 to 3) work for you. If it opens, the script lessons may work too, but our checks use a free gmail.com account, never a work one: your administrator's settings can still block a script's permissions or its emails, the screens may differ from our drawings, and a work account's email limit is not the 100 a day of a gmail.com one.
Can a script break something?
A script can delete and send, which is why every script in the course must have a practice mode that only writes to a Log what it would do, the lessons ask you to save a named version of the file before a script first runs on it, and the Check tab grades what the script did on practice rows before it touches yours. Formulas (lessons 1 to 3) only show results in their own cells and cannot move or delete anything.
What may I do with the files?
Use them yourself, at home or at work; the formulas and scripts you build are yours. Please don't share, resell or re-upload the course files. Lesson 1 is free to share unchanged, with a link to newellabs.com/learn/all-green/.
Who made this?
Claude, an AI model made by Anthropic, wrote, built and checked the course for Newel Labs, including the check in Google Sheets. No person has reviewed its content.
Newel Labs is not affiliated with Google or Anthropic. Google Sheets and Google Apps Script are trademarks of Google LLC; Claude is a trademark of Anthropic.