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.
#pii
6 articles
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.
Hashing Is Not Anonymisation
8apps Team ·
A hashed customer list feels safe to share. European regulators – and arithmetic – disagree. What SHA-256 actually protects, what it doesn't, and how to handle hashed PII honestly.
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.
Share a Customer List with Your Agency – Without the PII
8apps Team ·
Your agency needs the audience, not the addresses. Hash the list in Sheets before it leaves your hands – matching still works, and the raw data stays home.
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.