— Insights & tutorials

Notes from the Apps Script studio.

Engineering deep-dives, marketplace API tutorials, and lessons from 400+ shipped projects. New posts roughly monthly.

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

Want an article on a specific topic?

WhatsApp us a topic suggestion, or send us a question you've been stuck on — we publish answers regularly.