Guides
Practical fundamentals that make every automation more reliable.
Plan a script for long-term maintainability
Documentation, comments, and handover habits for Northwind's enduring automations.
Updated Oct 19, 2025
Schedule reliable recurring jobs
Design Northwind time-driven automations that don't drift, double-run, or miss.
Updated Oct 15, 2025
Understand execution context and identity
Know who a Northwind script runs as — and why it matters for permissions.
Updated Oct 11, 2025
Build a configuration system for your scripts
Manage Northwind script settings without hardcoding — environment-aware config.
Updated Oct 7, 2025
Diagnose and fix a slow workbook
Find and remove Northwind spreadsheet bottlenecks — formulas, ranges, references.
Updated Oct 3, 2025
Handle API rate limits and retries
Exponential backoff done right for Northwind's outbound HTTP.
Updated Sep 29, 2025
Use installable triggers for event-driven design
Build reactive Northwind automations — fire on edits, form submits, calendar events.
Updated Sep 25, 2025
Build a logging and monitoring system
Track every Northwind script run in a Sheet or Cloud Logging — never wonder if a cron fired.
Updated Sep 21, 2025
Design idempotent, re-runnable automations
Make Northwind scripts safe to run twice — same outcome, no duplicate side effects.
Updated Sep 17, 2025
Send reliable email at scale
Avoid Gmail spam folders and quota limits when Northwind sends thousands of emails.
Updated Sep 13, 2025
Parse and build JSON safely
Patterns for handling messy API responses in Northwind scripts.
Updated Sep 9, 2025
Unlock the Advanced Google Services
Reach APIs the basic Apps Script services don't cover — Drive API, People API, BigQuery.
Updated Sep 5, 2025
Secure a web app: authentication and access
Control who can reach Northwind's web-app endpoints — three layers from URL to logic.
Updated Sep 1, 2025
Process large datasets without timeouts
Chunk Northwind work across multiple executions — survive Apps Script's 6-minute limit.
Updated Aug 28, 2025
Build and publish a reusable library
Share Northwind code across many Apps Script projects — one source, many consumers.
Updated Aug 24, 2025
Write testable Apps Script code
Structure Northwind functions so you can verify them — pure logic separate from Google services.
Updated Aug 20, 2025
Use clasp and Git for Apps Script
Develop Northwind scripts locally with real version control — branches, diffs, code review.
Updated Aug 16, 2025
Move from container-bound to standalone scripts
When to migrate a Northwind script from a Sheet to a standalone project — and how.
Updated Aug 12, 2025
Handle dates and time zones without bugs
A reliable approach to date math in Northwind scripts — TZ-aware comparisons and formatting.
Updated Aug 8, 2025
Manage triggers programmatically at scale
Create, audit, and clean up Northwind triggers in code — never click through the UI.
Updated Aug 4, 2025
Authorize and scope a script correctly
Understand OAuth scopes and consent screens for Northwind's Apps Script projects.
Updated Jul 31, 2025
Prevent race conditions with LockService
Synchronise concurrent Northwind executions safely — single-writer invariants.
Updated Jul 27, 2025
Pick the right storage: Cache vs Properties
Match each Apps Script storage service to the right Northwind job.
Updated Jul 23, 2025
Structure a large Apps Script project
Files, modules, and naming for maintainability — when Northwind's script grows past 500 lines.
Updated Jul 19, 2025
Debug Apps Script effectively
Logging, breakpoints, and execution transparency — find bugs faster in Northwind scripts.
Updated Jul 15, 2025
Make slow scripts fast with batch operations
Why cell-by-cell loops kill Apps Script performance — and the in-memory pattern that fixes it.
Updated Jul 11, 2025
Understand and design around Apps Script quotas
Limits, costs, and how Northwind scripts stay under them at scale.
Updated Jul 7, 2025
Store API keys and secrets securely
Use Script Properties the right way — never paste keys into code.
Updated Jul 3, 2025
Design automations that never fail silently
Error handling, logging, and alerting patterns for Northwind's production scripts.
Updated Jun 29, 2025
Triggers explained: simple, installable, and time-based
When to use each type of Apps Script trigger and the gotchas to avoid.
Updated Jun 25, 2025