1. Build your prompt
Only the response experiment selects a fixture. No AI inference takes place.
THE WORKSPACE AUTOMATION SERIES · LAB 02
Your spreadsheet.
Your script.
A little Gemini.
Turn a cell of text into a useful first draft. Learn every step between reading a sheet and reviewing an AI response.
16 lessons · 6 response experiments · 1 complete starter project
01 / SOURCEA2 · Meeting notes
↓ Apps Script builds a requestKeep the original. Send only what you need.
02 / GENERATEGemini → a draft
↓ You inspect and approveCheck the status. Read the actual response.
03 / REVIEWB2 · Ready for a human
Helpful automation starts with a review step.
A COACH AT EVERY STEP
Learn the connection.
CHANGE ONE THING. FOLLOW THE RESULT.
The request workbench
2. Inspect the exchange
Request payload
Build a request, then run the simulation.
Raw response fixture
No exchange yet.
Extracted draft
No usable draft yet.
B2 · Empty
Follow the pipeline
- Waiting for an exchange.
This diagram models the exported script’s stages. Browser controls do not execute Google services.
FROM PRACTICE TO A REAL PROJECT
Build your one-cell assistant.
Your setup checklist
Download Code.gs ↓ Learning handbook ↓The starter makes a real API request when you run it in Google Apps Script. API access, authorization, availability and usage charges depend on your account. It processes A2 once and writes a draft to an empty B2 after confirmation.
Three useful project directions
Meeting notes → summary
Put non-sensitive notes in A2. Keep the starter’s summary task, generate once, then compare each claim to the original. Leave uncertain dates uncertain.
Customer message → reply draft
Change the task in buildPrompt_ to request a polite draft. Include approved policies in the prompt. Review promises and facts yourself. This starter does not send email.
Notes → action items
Ask for owner, action and due date in plain text, using “unknown” when missing. If you later request JSON, validate its shape and every required field before writing columns.
Before scaling
Use explicit file IDs for background jobs, record row status, limit each batch and plan for retries. Avoid calling the API from a simple onEdit trigger or a custom formula that may recalculate repeatedly.
Complete starter code
Loading downloadable starter…