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