Prepare a Google Ads Customer Match List in Sheets
8apps Team ·
The upload succeeds either way – the match rate is what fails. Here's the Sheets-to-Customer-Match workflow with Google's own formatting rules at each step.
Google Workspace
Page 4
Hash Email Addresses Correctly in Google Sheets
8apps Team ·
Email hashing fails on casing, invisible spaces and Gmail's dot rules – not on the hash. The normalisation order that makes digests actually match, platform by platform.
Prepare a Meta Custom Audience File from Google Sheets
8apps Team ·
Meta's phone format is not Google's – the same number needs two different hashes. Here's the Sheets workflow that follows Meta's documented rules exactly.
How to Extract Email Addresses from Gmail to a Spreadsheet (4 Ways)
8apps Team ·
Gmail has no export-these-addresses button. Here are the four routes that actually work - Other contacts, Contacts export, Takeout and Apps Script - and which one fits your situation.
Gmail Search Operators for Building a Contact List
8apps Team ·
A working reference for the Gmail search operators that define a contact list: labels, senders, dates, categories and attachments - plus the combinations that actually scope an export.
How to Hash Phone Numbers and Emails in Google Sheets
8apps Team ·
Sheets has no built-in SHA-256 function. Here is how to hash a customer list properly - and why the same phone number needs two different hashes for Google Ads and Meta.
Shipping a Google Workspace Add-on with clasp and GitHub Actions
8apps Team ·
A step-by-step guide to deploying Apps Script add-ons straight from a git push — install clasp, wire up .clasp.json, and let GitHub Actions handle the rest.
Stop Tabbing Around: Gmail's 'Go-To' Navigation With g then …
8apps Team ·
Learn how to use Gmail's "g then …" shortcuts to jump instantly to Inbox, Starred, Sent, Drafts, Labels and more. A simple guide for beginners and intermediates.
Gmail's 16 One-Key Shortcuts You'll Actually Use This Week
8apps Team ·
Learn 16 essential one-key Gmail shortcuts you'll actually use daily. Faster replies, cleaner inbox, quicker search, smoother navigation. Includes drills, tips, and a printable mini-card.
Turn Gmail Shortcuts ON - Then Let Your Screen Teach You
8apps Team ·
Learn how to turn on Gmail keyboard shortcuts in seconds, view the built-in list, and let on-screen hints teach you the keys as you work.