Format Phone Numbers to E.164 in Google Sheets
8apps Team ·
E.164 is the format ad platforms and APIs expect – and the one spreadsheets quietly destroy. Here's how to get +6591234567 out of whatever your column holds now.
Google Workspace
16 articles
Gmail Add-On Permissions, Explained Honestly
8apps Team ·
That consent screen is asking a real question. Here's what Workspace add-on permissions actually mean, what to check about any vendor, and how to revoke access in one minute.
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.
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.