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.

n8n workflow diagram: schedule trigger, read Google Sheet, normalize code node, write back changed rows
$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

What you get

The workflow file (sheets-data-cleaner.json), ready to import into n8n, delivered immediately after payment.

Installation

  1. Import the JSON file into your n8n instance (self-hosted or cloud).
  2. Connect your Google Sheets account in the two Google Sheets nodes.
  3. Set documentId/sheetName to your spreadsheet and tab.
  4. In the code node, set PHONE_COL/EMAIL_COL/DATE_COL to your column headers.
  5. 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