Posts
All the articles I've posted.
Automating Google Sheets API Data Pipelines with Google Apps Script
Architect scalable Google Apps Script workflows to ingest JSON REST APIs directly into Google Sheets, eliminating manual data entry and stale metrics.
Vectorizing Lookups in Google Sheets MAP LAMBDA and XLOOKUP Dynamic Array Alternatives
Replace slow VLOOKUP ARRAYFORMULA patterns with performant MAP LAMBDA and XLOOKUP arrays to build scalable Google Sheets financial models.
Mastering Google Sheets QUERY Function: Multiple Conditions, Dynamic Dates, and Aggregations
A production-grade guide to mastering the Google Sheets QUERY function. Learn how to combine multiple WHERE clauses, parse dynamic dates safely, and build relational summaries without script overhead.