# =HASHEMAIL() Formula for Google Sheets

> Reference for =HASHEMAIL(email, algorithm), which trims, lowercases, and hashes email addresses for privacy-safe Google Ads and Meta audience uploads.

- Source: https://www.8apps.co/docs/hash-data/using-hash-data/hash-email
- Markdown: https://www.8apps.co/docs/hash-data/using-hash-data/hash-email.md
- Language: en

---
# =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:

| Parameter              | Description                                          | Example                    |
| ---------------------- | ---------------------------------------------------- | -------------------------- |
| `email`                | The 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.
:::