APPS SCRIPT + GEMINI / BUILD WITH UNDERSTANDING
Connect your code.
Build with Gemini.
Learn how Apps Script and Gemini work together. Build requests, inspect responses, and turn AI drafts into dependable Workspace workflows.
FIND THE ANSWER / UNDERSTAND THE REASON
40 common questions, explained.
Search by question, app or symptom. Answers include practice steps and official Google references. Guidance reviewed October 1, 2026; features can vary by account and device.
CHANGE AN INPUT / INSPECT THE RESULT
Your AI automation workbench.
Eight local simulators: change inputs and inspect the mechanics. No API key, live model call or Google account connection. Drafts save in this browser.
TURN IDEAS INTO TESTABLE WORK
Build something you can explain.
Use the project briefs and downloadable Apps Script starters. Plan here, then test with fictional data in your own private Google project.
RETURN / RECALL / REVISE
Keep what you understand.
Recall practice
Your learning record
Completion requires a correct scenario answer, an artifact of at least 80 characters and a reflection of at least 40 characters. Editing an answer or written work reopens the lesson.
Review timing follows your own rating, not a measured estimate of mastery.
Code starters & official documentation
Configure credentials only in your private Apps Script project. The downloadable starter makes real requests only when you run it there. Read the setup instructions first.
Download Code.gs — API wrapper + Sheets, Docs and reply examples ↓Download setup & testing guide ↓Google: generateContent / Apps Script examples ↗Google: current text-generation guidance ↗Apps Script documentation ↗Current model availability ↗Current API pricing ↗Apps Script foundations ↗This course uses the generateContent REST track, currently labeled legacy by Google. Other API tracks use different request and response fields. Check current guidance before production use.
Independent DiscoveryVIP resource; not affiliated with Google. Local labs are transparent simulations, not AI-generated answers. Progress and notes stay in this browser. Export a backup to keep them. The supplied analytics tag does not receive practice text in custom events.