Apps Script
Self-chaining triggers: how to safely batch process 50K rows in Apps Script
Apps Script's 6-minute execution limit is famously frustrating — until you learn how to pick up where you left off. A complete pattern for resumable batch processing using time-driven triggers and PropertiesService.
15 min read
Coming Q2 2026
Shopify
Bulk vs. individual Shopify product updates: a 200x speed comparison
We migrated a 12,000-product inventory sync from individual REST calls to productVariantsBulkUpdate. The numbers are absurd. Here's the architecture and gotchas we learned.
12 min read
Coming Q2 2026
Amazon
Amazon SP-API + Ads API v2 multi-region setup with Apps Script
NA + EU regions need separate refresh tokens, but the rest of the architecture can stay unified. A walkthrough of our standard SP-API integration template.
20 min read
Coming Q2 2026
TikTok Shop
Synchronous TikTok Shop webhook handlers in Apps Script: lessons learned
Why we use synchronous doPost with LockService instead of queued processing for TikTok Shop orders. Trade-offs explained.
10 min read
Coming Q2 2026
Architecture
Named ranges, dynamic headers, and other architectural choices that pay for themselves
The five Sheets engineering decisions that have saved us hundreds of debugging hours over 400+ projects.
8 min read
Coming Q2 2026
AI Integration
Streaming OpenAI & Claude responses inside Google Sheets
A complete pattern for building =AI(prompt) functions with streaming response display, conversation memory, and markdown table rendering.
14 min read
Coming Q2 2026