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.
#sha256
6 articles
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.
MD5, SHA-1 or SHA-256 for Customer Data?
8apps Team ·
The tool offers five algorithms; the upload needs exactly one. What Google, Meta and TikTok actually accept, how to recognise each digest on sight, and the one-line rule.
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.
Salted vs Unsalted Hashes for Audience Uploads
8apps Team ·
Security guides say always salt your hashes. Ad platforms can't match salted data. Both are right – here's the difference, and what it means for how you handle upload files.
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.