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