{"product_id":"hourly-n8n-google-sheets-cleanup-phone-email-dates","title":"Hourly n8n Google Sheets Cleanup: Phone, Email \u0026 Dates","description":"\u003ch3\u003eKeep your Google Sheets data clean—automatically, every hour\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003ehourly n8n Google Sheets cleanup workflow\u003c\/strong\u003e reads rows from your worksheet, \u003cstrong\u003enormalizes phone numbers, email addresses, and dates\u003c\/strong\u003e, and writes back \u003cem\u003eonly the rows that actually changed\u003c\/em\u003e—adding an \u003ccode\u003e_email_valid\u003c\/code\u003e flag for downstream filtering.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on an hourly schedule\u003c\/strong\u003e using an n8n Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads all rows\u003c\/strong\u003e from a specified Google Sheets worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes configured fields\u003c\/strong\u003e (phone, email, and date) based on the column headers you set in the workflow’s code step, including a \u003cstrong\u003edefault country dialing prefix\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects changes\u003c\/strong\u003e by comparing normalized values to the originals.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters to updates only\u003c\/strong\u003e, updating Google Sheets only for rows where at least one normalized field differs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites updates back safely\u003c\/strong\u003e by matching on the worksheet’s \u003ccode\u003erow_number\u003c\/code\u003e column returned by the Google Sheets read operation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAdds \u003ccode\u003e_email_valid\u003c\/code\u003e\u003c\/strong\u003e (boolean) so you can easily filter valid vs. invalid emails later in your automation chain.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eEnsure contact sheets stay reliable by standardizing \u003cstrong\u003ephone numbers\u003c\/strong\u003e and \u003cstrong\u003eemail addresses\u003c\/strong\u003e before lead outreach.\u003c\/li\u003e\n  \u003cli\u003eClean up \u003cstrong\u003edate fields\u003c\/strong\u003e so downstream automations (timers, reminders, CRM sync) don’t break due to inconsistent formats.\u003c\/li\u003e\n  \u003cli\u003ePrepare SaaS exports or dashboards by keeping Google Sheets values normalized without manual edits.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger:\u003c\/strong\u003e Schedule Trigger (runs hourly)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore logic:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, and \u003ccode\u003eno op\u003c\/code\u003e steps to normalize and route only changed rows\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData source:\u003c\/strong\u003e Google Sheets (OAuth2 credential)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration:\u003c\/strong\u003e Set \u003ccode\u003edocumentId\u003c\/code\u003e and \u003ccode\u003esheetName\u003c\/code\u003e in both Google Sheets nodes; update \u003ccode\u003ePHONE_COL\u003c\/code\u003e, \u003ccode\u003eEMAIL_COL\u003c\/code\u003e, \u003ccode\u003eDATE_COL\u003c\/code\u003e, and \u003ccode\u003eDEFAULT_COUNTRY_PREFIX\u003c\/code\u003e in the code step\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdate matching:\u003c\/strong\u003e Requires a \u003ccode\u003erow_number\u003c\/code\u003e column from the Google Sheets read operation\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eWant more automation power? Explore the full data-cleaning suite: \u003ca href=\"https:\/\/shop.lumnika.com\/sheets-data-cleaner.html?src=n8ncreators\"\u003ehttps:\/\/shop.lumnika.com\/sheets-data-cleaner.html?src=n8ncreators\u003c\/a\u003e\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938307793075,"sku":"N8N-18927","price":35.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/o-Zqze1OmL5oO777TW_dz_vf1ROPhV.png?v=1788341740","url":"https:\/\/buyflowscripts.com\/products\/hourly-n8n-google-sheets-cleanup-phone-email-dates","provider":"N8N Commerce","version":"1.0","type":"link"}