← Innovation StudioWORKSPACE GUIDE

Choose a lesson. Learn the code.

You do not need an API key, Google account, or programming experience to run this example. The browser uses a fixed authored response. It does not contact Gemini.

Start the coding course: exact steps

  1. Open the studio and select Choose your learning path → or Learn · 60 lessons.
  2. Choose AI Explorer for foundations, AI Application Builder for JavaScript and service connections, or AI Innovation Developer for workflows, testing and safeguards.
  3. Select Continue to open the first path exercise without recorded checks and explanation self-review. You can open any lesson directly; lessons are not locked.
  4. In Select a lesson, expand a module and select a numbered title. You can also use Jump directly to a lesson or search by title/concept.
  5. Read Discover, the objective and prerequisites. Write a prediction before running anything.
  6. Read Working code. Use What each line does and the collapsed Code vocabulary to understand its syntax and purpose.
  7. Run worked example 1 and worked example 2. Compare actual output with each exact expectation. These use the verified answer and leave your exercise code alone.
  8. Scroll to Your code. The starter has an intentional bug. Edit its JavaScript; the code is genuinely executed when you select Run my code.
  9. Change Practice input if desired. It is JSON because it is the data passed to your function, not the lesson itself.
  10. Select Check my solution. This runs your current function against every authored case. Inspect Actual and Expected under each result.
  11. If stuck, open hints in order. Show verified answer displays a repair but does not replace your code or award a pass.
  12. Explain the changed operation and trace one input through it. Check the self-review rubric and select Record explanation self-review. This is your own review, not an automated judgment of your prose.
  13. Select Save lesson & progress. Then select Next lesson →. Your edits remain in memory during navigation; saving makes them available on return.
  14. Use Download this lesson code for your current function or Download course source & lesson notes for all 60 starters, answers, tests and notes.

Three pathways overlap intentionally: the builder route revisits some prompt and data lessons used by Explorer. The curriculum still contains 60 unique lessons.

Lesson controls and windows

Path cards
Choose a recommended route. Prerequisites, planning time, outcome and evidence counts update. Choosing a path does not erase work.
Module / Search / Jump directly
Filter the lesson list or open a lesson by number. Search includes explanations as well as titles. The selected lesson remains open until you choose another one.
Working code / What each line does
Read the verified function and explanations keyed to its source lines. Code vocabulary defines the symbols and methods used there.
Worked examples
Two real executions of the verified function on different authored inputs. These do not grade your exercise code.
Your code
The real editable JavaScript function. Keep the name solve(input). Tab moves focus to the next control; Ctrl+] or Command+] inserts two spaces, and Ctrl+Enter or Command+Enter runs it. The lab executes in an opaque-origin iframe worker with network access blocked and a three-second limit.
Practice input
The value passed to input after JSON.parse. Invalid JSON is reported without running code. A custom input has no authored expected answer; predict and justify yours.
Run my code
Runs your edited function on Practice input and shows its returned value, runtime errors and console.log messages.
Check my solution
Runs your edited function against all lesson cases, independent of the custom input. Every check reports observed and expected output. These checks cover those cases, not all possible behavior.
Stop execution
Terminates the current isolated run without deleting code. A loop that never ends is also stopped by the three-second limit.
Reset to starter
Asks before replacing this lesson’s code with its intentionally broken starter. Prediction and notes remain.
Show verified answer
Reveals the worked repair. Copy or apply it yourself if needed, then rerun checks. Revealing an answer does not record a pass.
Explain / Record explanation self-review
Record your reasoning against the visible rubric after current code checks pass. A minimum length prevents empty notes; correctness still needs your or your teacher’s judgment. Editing code invalidates the current review evidence.
Reflect / Extend
Explain limitations and try a new scenario. This is the transfer task beyond the prepared checks.
Refresh prompts / Copy
Build three optional, editable AI help prompts containing your actual code and latest checks. Copying sends nothing automatically. Keep secrets out.
Save lesson & progress
Saves all workspace state to this browser, including selected lesson, code drafts, predictions, reflections and evidence. Imported evidence is cleared until you rerun checks.
Direct lesson link
Opens the lesson by URL, such as ?lesson=24. Useful for teaching or returning to a particular topic.
Open the complete Apps Script project
Switches to the actual feedback-classifier export. Lesson functions teach isolated concepts; the export supplies real Google service adapters.

Classification workbench: your first successful run

  1. Open the studio and select Build Studio.
  2. Read the five input rows. Each has a numeric ID and message.
  3. Read the allowed category list. Each category occupies one line.
  4. Read the authored response. This is a prepared example, not a generated answer.
  5. Select Run pipeline. Expect five updated preview rows and no errors.
  6. Select Load invalid category, then Run pipeline. Expect an invalid-category error and no updated rows.
  7. In Response, change Urgent to Account support. Run again. Expect success.
  8. Change a message. Run again. Notice that the response does not change. Explain why human review is needed.
  9. Select Run 10 contract tests. Expect 10 passes. The final case shows that structural validation cannot detect a wrong meaning.
  10. Select Save locally. Then export a backup to retain a portable copy.
  11. Open Projects, inspect Code.gs, and download the complete project.

What each area teaches

Start Here
Explains Gemini, Apps Script, the fixture boundary and the six-step first activity.
Learn
60 coding lessons in 12 modules with three pathways, lesson search, direct selection, code walkthroughs, runnable examples, editable exercises, tests, hints and saved notes.
Build Studio
Actual JSON parsing, validation, ID matching and local spreadsheet preview. No remote spreadsheet is modified.
Automation
Estimate labor savings, review burden and break-even using your own assumptions.
Projects
Inspect and download the complete Apps Script source and setup instructions.
Showcase
Five-minute presenter rehearsal and downloadable script.
Help
This consolidated guide. Navigation stays clear of individual help icons.

Every control in the workbench

Learning mode
Beginner shows extra instructions. Guided Builder uses the same tools. Advanced Developer hides beginner guidance. Edits stay intact.
Save locally
Explicitly saves your current draft to this browser's IndexedDB. Clearing browser data removes it. Private browsing may not retain it.
Export backup / Import backup
Download or restore a version 1 JSON workspace. Import replaces the current in-memory draft, not the saved draft until you select Save locally. Export before importing if you need both versions.
Inputs / Categories / Response
Edit source rows, the allowlist and the proposed answer. They are separate inputs. Never paste secrets.
Inspect constructed prompt
Shows the actual prompt made from the current rows and categories. It makes no API request.
Run pipeline
Parses JSON, validates all IDs and categories, and joins valid candidates to rows. Errors block the entire local result.
Load valid fixture
Replaces Response with the original five authored answers. It does not reset edited input.
Load invalid category / Load malformed JSON
Replace Response with a prepared failure. Run the pipeline to observe it.
Run 10 contract tests
Tests the built-in validator against known positive and negative cases. These are local contract tests, not a Google integration test.
Inspect actual validation source
Read the exact function the workbench uses. Edit the exported Code.gs to extend it. For editable JavaScript, select Learn validation step by step or Learn row matching code above the workbench.
Learn validation step by step / Learn row matching code
Open coding Lessons 24 and 28 with explanations and real editable JavaScript.
Calculate impact
Computes weekly, monthly and annual hours, estimated financial value and break-even. All time entries are minutes except maintenance and implementation, which are hours.
Inspect exported file
Choose a file to view. Export includes complete source, manifest, data and setup instructions.
Download complete Apps Script project
Creates a ZIP from your current input and categories. It does not deploy anything.
Project notes / Prediction / Reflection
Write your reasoning and extension plan. Save locally or export a backup to keep them.

Get finished code into Google

  1. Download the project ZIP and extract it.
  2. Create a new disposable spreadsheet. Open Extensions → Apps Script.
  3. Replace the default script with Code.gs. Enable the manifest in Project Settings and copy appsscript.json.
  4. Add SPREADSHEET_ID, GEMINI_API_KEY and GEMINI_MODEL under Script Properties. Keep keys out of browser files and backups. Project editors can access these properties.
  5. Select a currently supported model that accepts generateContent. Verify account availability and costs in Google AI Studio.
  6. Run install. Authorize scopes only after reviewing the source. The script refuses to overwrite existing Messages or Review sheets.
  7. For an offline rehearsal, enter the exact input snapshot JSON into Review!A2, candidate classification JSON into B2, and TRUE into C2 after reviewing every answer.
  8. For a real request, explicitly run generateDraft. It sends the Messages data to Google and may incur charges. Check the response and its meaning before entering TRUE in Review!C2.
  9. Run writeApproved. Categories go into Messages column C. Input changes invalidate the saved snapshot. Approval resets after execution.
  10. Test failures and duplicate runs on disposable data before adapting the project.

No web deployment or public endpoint is needed for this bound-script project. There are no scheduled triggers or automatic retries.

Troubleshooting and expected outcomes

Compatibility and privacy

Reference check: 17 November 2026. Models, access and quotas change. Configure a supported model rather than relying on a hardcoded model name. The website requires modern JavaScript modules and IndexedDB. Your data remains local unless you copy it or run the configured Apps Script export.

Gemini generateContent reference · Current models · Script Properties · Apps Script quotas · Gemini in the Apps Script editor

HTML service client/server communication · Google service authorization · Trigger restrictions

Gemini editor assistance is different from making a Gemini API request in your application. This export uses the latter. No live Google integration has been tested in this package.