The Anonymize processor lets you mask sensitive data before it reaches its destination. Use it to protect personally identifiable information (PII) — such as names, emails, or ID numbers — while still automating your data flows. The original data in your source file is never touched.
When to use it
The Anonymize processor is ideal when you need to:
Share reports with teams or stakeholders who should not see raw personal data
Comply with data protection regulations such as GDPR or LGPD
Route data through shared destinations without exposing sensitive columns
Adding the Anonymize processor
Open your automation and click Edit.
In the automation editor, click the + button between the source and the destination.
On the Select a data processor screen, choose Anonymize under Transform Data.
Choose an Anonymization Mode (see below) and configure the masking settings.
Click Done editing to continue to the destination step, then save your automation.
Anonymization modes
When you add the Anonymize processor, you choose one of two modes:
Automatic (DLP Powered PII detection) | Sheetgo automatically detects columns that contain PII — such as names, emails, and ID numbers — and applies masking to them. No manual configuration needed. |
Custom (Configure masking per column) | You choose a masking method for each column individually. Columns set to No masking pass through unchanged. |
Masking methods (Custom mode)
In Custom mode, each column gets its own masking method. Click the dropdown next to any column to choose:
No masking | Column passes through to the destination unchanged. |
Salted Hash | Hashes the value with a random salt — consistent within a run but not reversible or comparable across runs. |
Hash | Produces a deterministic hash of the value — the same input always yields the same output, useful for joining anonymized datasets. |
Nullify | Replaces the value with an empty cell. |
Redact | Replaces the value with a fixed redaction marker (e.g. [REDACTED]). |
Partial Email | Masks the local part of an email address while keeping the domain visible (e.g. ***@company.com). |
Partial Start | Masks the beginning of the value, keeping the end visible. |
Partial End | Masks the end of the value, keeping the beginning visible. |
Numerical Grouping | Replaces exact numbers with a range (e.g. 25 → 20–30), reducing precision while preserving trends. |
Tip: Use Hash when you need to join anonymized data across automations — the same source value always produces the same hash. Use Salted Hash when you need stronger privacy and don't require cross-automation joins.
FAQ
Is the original data affected?
No. The Anonymize processor only affects the destination output. Your source file is never modified.
Can I combine it with other processors?
Yes. You can chain the Anonymize processor with Filter Rows, Filter Columns, or Merge. Click the + button again after adding Anonymize to insert additional processors in the same automation.