Skip to main content

=HASHEMAIL(email, [algorithm])

The =HASHEMAIL() function is purpose-built for email addresses. It cleans, normalises, and hashes email strings using secure cryptographic algorithms, ensuring consistent, privacy-preserving representations ideal for audience uploads and data exports.

Parameters:​

ParameterDescriptionExample
emailThe email address or cell reference you want to hash=HASHEMAIL(B2)
algorithm (optional)Choose from: SHA256, MD5, SHA1, SHA512 and SHA3-256=HASHEMAIL(A2, "SHA256")

What it does:​

  • Trims whitespace
  • Converts to lowercase
  • Hashes the cleaned email

Use Cases:​

  • Preparing clean, hashed emails for Google Ads or Meta Ads audience lists
  • Ensuring consistent anonymisation across rows or datasets
  • Sharing email datasets securely while maintaining privacy
info

HASHEMAIL expects the input to be a valid email address.