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.
Gmail to Google Sheets with Apps Script: Complete Guide
Marianne Gatlabayan shows how to parse Gmail emails into a Google Sheets database using free Apps Script. Copy-paste code, hourly triggers, live examples. Read now.
Sep 24, 2026 · 12 min read
Google Sheets QUERY Function: 12 Real Marketing Examples
Marianne Gatlabayan explains the Google Sheets QUERY function with 12 real marketing examples. Filter, aggregate, and pivot in one formula. Start using QUERY today.
Sep 24, 2026 · 15 min read
Looker Studio Calculated Fields: 10 Formulas Every Marketer Should Know
Marianne Gatlabayan covers 10 Looker Studio calculated fields every marketer needs. Free tool, real examples, formulas that turn dashboards into decisions. Try them.
Sep 24, 2026 · 14 min read
Clean CRM Data with Python Pandas: A Beginner-Friendly Walkthrough
Marianne Gatlabayan walks through cleaning messy CRM data with Python Pandas. Dedupe, standardize, validate. Free tool, under 100 lines. Start cleaning today.
Sep 24, 2026 · 16 min read
Regex for Non-Programmers: 10 Patterns to Extract Anything from a Spreadsheet
Marianne Gatlabayan shares 10 regex patterns for spreadsheets. Extract emails, phones, URLs, and dates in Google Sheets and Excel. Copy the patterns now.
Sep 24, 2026 · 13 min read
Make.com vs Zapier for Small Business Owners: An Honest Field Comparison
Marianne Gatlabayan compares Make.com vs Zapier for small business owners. Pricing, ease, best-fit use cases. Honest hands-on comparison. Read before you pick.
Sep 24, 2026 · 15 min read
How to Build a Weekly Client Reporting Dashboard in Under an Hour
Marianne Gatlabayan shows how to build a weekly client reporting dashboard free with Sheets and Looker Studio. Automated email delivery included. Start now.
Sep 24, 2026 · 14 min read
The Beginner's Guide to Google Apps Script for Automating Recurring Reports
Marianne Gatlabayan explains Google Apps Script from zero. Automate Sheets, send emails, run schedules. Free tool, copy-paste code, clear steps. Start today.
Sep 24, 2026 · 18 min read
How to Audit Backlinks Using a Google Sheet and Free Tools
Marianne Gatlabayan runs backlink audits with Google Sheets, Search Console, and free tools. Save $3,816 per year. Full process with scoring formula. Learn the steps.
Sep 24, 2026 · 16 min read
Data Pipeline for Beginners: A Non-Technical Founder's Guide
Marianne Gatlabayan explains data pipelines for non-technical founders. What ETL means, when you need one, how to build free with Sheets. Get started today.
Sep 24, 2026 · 17 min read