Hourly n8n Google Sheets Cleanup: Phone, Email & Dates

Keep your Google Sheets data clean—automatically, every hour

This hourly n8n Google Sheets cleanup workflow reads rows from your worksheet, normalizes phone numbers, email addresses, and dates, and writes back only the rows that actually changed—adding an _email_valid flag for downstream filtering.

What this workflow does

• Runs on an hourly schedule using an n8n Schedule Trigger.
• Reads all rows from a specified Google Sheets worksheet.
• Normalizes configured fields (phone, email, and date) based on the column headers you set in the workflow’s code step, including a default country dialing prefix.
• Detects changes by comparing normalized values to the originals.
• Filters to updates only, updating Google Sheets only for rows where at least one normalized field differs.
• Writes updates back safely by matching on the worksheet’s row_number column returned by the Google Sheets read operation.
• Adds _email_valid (boolean) so you can easily filter valid vs. invalid emails later in your automation chain.

Use cases

• Ensure contact sheets stay reliable by standardizing phone numbers and email addresses before lead outreach.
• Clean up date fields so downstream automations (timers, reminders, CRM sync) don’t break due to inconsistent formats.
• Prepare SaaS exports or dashboards by keeping Google Sheets values normalized without manual edits.

Technical details

• Trigger: Schedule Trigger (runs hourly)
• Core logic: if, code, and no op steps to normalize and route only changed rows
• Data source: Google Sheets (OAuth2 credential)
• Configuration: Set documentId and sheetName in both Google Sheets nodes; update PHONE_COL, EMAIL_COL, DATE_COL, and DEFAULT_COUNTRY_PREFIX in the code step
• Update matching: Requires a row_number column from the Google Sheets read operation

Want more automation power? Explore the full data-cleaning suite: https://shop.lumnika.com/sheets-data-cleaner.html?src=n8ncreators