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