Notes from the field
Practical guides for people who run operations.
Everything here comes from builds I have shipped: parsing inboxes, cleaning messy exports, wiring reporting that updates itself. No theory-only posts — each guide ends with something you can run this week.
How to Parse Gmail Emails into a Google Sheets Database Using Apps Script
Turn any Gmail inbox into a searchable Google Sheets database with a free Apps Script. Full walkthrough with sample code.
Sep 24, 2026 · 12 min read
The Google Sheets QUERY Function Explained with 12 Real Marketing Examples
Filter, aggregate, and pivot spreadsheet data with a single formula. Includes syntax cheat sheet.
Sep 24, 2026 · 15 min read
Looker Studio Calculated Fields Every Marketer Should Know
A working guide to Looker Studio calculated fields with 10 marketing examples. Free tool, forever.
Sep 24, 2026 · 14 min read
Cleaning Messy CRM Data with Python Pandas: A Beginner-Friendly Walkthrough
Clean any messy CRM export with Python Pandas in under 100 lines — duplicates, phone formatting, email validation.
Sep 24, 2026 · 16 min read
Regex Patterns for Non-Programmers: Extract Emails, Phones, and URLs from Any Spreadsheet
Copy-paste regex patterns for emails, phones, URLs, dates, and addresses that work in Google Sheets and Excel.
Sep 24, 2026 · 13 min read
Make.com vs Zapier for Small Business Owners: An Honest Field Comparison
Pricing, ease of use, use cases, and where each platform breaks — based on hands-on production work.
Sep 24, 2026 · 15 min read
How to Build a Weekly Client Reporting Dashboard in Under an Hour
Step-by-step build of a weekly client dashboard in Looker Studio, connected to Google Sheets, with automated email delivery.
Sep 24, 2026 · 14 min read
The Beginner's Guide to Automating Recurring Reports with Google Apps Script
Learn Google Apps Script from zero. Automate reports, send scheduled emails, and connect Sheets to Gmail.
Sep 24, 2026 · 18 min read
How to Audit Backlinks Using a Google Sheet and Free Tools
Full backlink audit process using Google Sheets and free tools. No Ahrefs or Semrush subscription needed.
Sep 24, 2026 · 16 min read
Setting Up Your First Data Pipeline: A Non-Technical Founder's Guide
A plain-English guide to your first data pipeline. What ETL means, when you need one, and how to build one free.
Sep 24, 2026 · 17 min read