Archives
All the articles I've archived.
Google Apps Script Batch Update Performance Optimization Guide
Master Google Apps Script batch updates using getValues and setValues to eliminate API latency and scale enterprise spreadsheet operations effectively.
Scaling Financial Models in Google Sheets with Lambda Helper Functions MAP BYROW SCAN and REDUCE
Master Google Sheets lambda helper functions MAP BYROW SCAN and REDUCE to eliminate volatile array formulas and optimize enterprise financial models.
Automate Google Sheets PDF Export and Email Delivery with Apps Script
Architect an enterprise Google Apps Script solution to export sheets as PDFs and email them automatically on schedule, eliminating manual reporting errors.
Advanced Google Sheets REGEXEXTRACT Patterns for Enterprise Data Cleansing
Master advanced Google Sheets REGEXEXTRACT formula pattern matching for enterprise data cleansing. Extract complex strings, parse logs, and scale FP&A workflows.
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.