Six lessons on writes — send, create, append, update, plus the idempotency mindset and the dedup pattern. Eight questions, 80% pass.
Week 3 is composition: chaining reads and writes into small, reliable workflows.
| Lesson | Concept |
|---|---|
| 8 | GMAIL_SEND_EMAIL — first true side effect; verify by inbox search with retry |
| 9 | GOOGLECALENDAR_CREATE_EVENT — server-assigned ID returned in response |
| 10 | GOOGLESHEETS_VALUES_APPEND — list-shaped writes; values is rows-of-cells |
| 11 | GOOGLECALENDAR_UPDATE_EVENT — needs prior ID; full update overwrites omitted fields |
| 12 | Idempotency — predict whether a script's effect doubles on re-run |
| 13 | Dedup keys — set() + continue to skip already-processed items |
Week 3 builds the smallest end-to-end workflows from these primitives.
Create a free account to get started. Paid plans unlock all tracks.
Six lessons on writes — send, create, append, update, plus the idempotency mindset and the dedup pattern. Eight questions, 80% pass.
Week 3 is composition: chaining reads and writes into small, reliable workflows.
| Lesson | Concept |
|---|---|
| 8 | GMAIL_SEND_EMAIL — first true side effect; verify by inbox search with retry |
| 9 | GOOGLECALENDAR_CREATE_EVENT — server-assigned ID returned in response |
| 10 | GOOGLESHEETS_VALUES_APPEND — list-shaped writes; values is rows-of-cells |
| 11 | GOOGLECALENDAR_UPDATE_EVENT — needs prior ID; full update overwrites omitted fields |
| 12 | Idempotency — predict whether a script's effect doubles on re-run |
| 13 | Dedup keys — set() + continue to skip already-processed items |
Week 3 builds the smallest end-to-end workflows from these primitives.