Google Sheets Data Cleaner
An n8n workflow template that keeps one Google Sheet tidy on autopilot: phone
numbers get formatted consistently, emails get lowercased and validated, dates get coerced to a
single ISO format โ and only the rows that actually needed a fix get rewritten.
$14.99 one-time, no recurring cost
Buy now
๐ Secure checkout by Stripe, your card details never touch our servers ยท 7-day
money-back guarantee, no questions asked (deus@lumnika.com)
ยท instant download, no account required.
Who it's for
Anyone running lead lists, CRMs, or ops sheets in Google Sheets where messy phone/email/date
formatting quietly breaks downstream automations (SMS tools rejecting numbers, dedupe failing on
case-mismatched emails, date sorts breaking on mixed formats).
What it does
- Runs on a schedule (hourly by default, easy to change) and reads your sheet.
- Normalizes phone numbers to a consistent digits-with-country-code format.
- Lowercases and trims emails, and flags invalid ones in a new column.
- Coerces any parseable date format to
YYYY-MM-DD.
- Only rewrites rows that actually changed โ no unnecessary API calls or edit history noise.
What you get
The workflow file (sheets-data-cleaner.json), ready to import into n8n, delivered
immediately after payment.
Installation
- Import the JSON file into your n8n instance (self-hosted or cloud).
- Connect your Google Sheets account in the two Google Sheets nodes.
- Set
documentId/sheetName to your spreadsheet and tab.
- In the code node, set
PHONE_COL/EMAIL_COL/DATE_COL to your column headers.
- Activate the workflow.
FAQ
- Does this need an n8n subscription?
- No, it runs on any n8n instance โ self-hosted (free) or n8n Cloud, whichever you already use.
- Will it touch columns I didn't ask it to?
- No, only the phone/email/date columns you configure are modified; the rest of each row passes through untouched.
- Is this a subscription?
- No. $14.99 once, yours to keep and modify.
Buy now โ $14.99