{"product_id":"n8n-lead-validation-google-sheets-dedup-slack-alerts","title":"n8n Lead Validation: Google Sheets Dedup + Slack Alerts","description":"\u003ch3\u003eInstant lead validation with duplicate prevention + Slack notifications (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation receives lead submissions via a webhook, checks them against your Google Sheets to prevent duplicates, validates email and Pakistani phone formats, saves the result to the right tab, and immediately alerts your team in \u003cstrong\u003eSlack\u003c\/strong\u003e—valid leads to \u003cstrong\u003e#valid-leads\u003c\/strong\u003e and invalid leads to \u003cstrong\u003e#invalid-leads\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a POST request\u003c\/strong\u003e on an n8n \u003cstrong\u003ewebhook\u003c\/strong\u003e endpoint containing lead details (name, email, phone number, and message).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads existing leads\u003c\/strong\u003e from the Google Sheets tabs \u003cem\u003e“Valid Leads”\u003c\/em\u003e and \u003cem\u003e“Invalid Leads”\u003c\/em\u003e and aggregates rows for duplicate checking.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects duplicates\u003c\/strong\u003e by comparing the incoming submission to stored rows; if a match is found, it stops processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates inputs\u003c\/strong\u003e using JavaScript: verifies email format and a Pakistani phone number pattern of \u003cstrong\u003e+92\u003c\/strong\u003e followed by \u003cstrong\u003e10 digits\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes and stores leads\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eIf valid: appends to \u003cem\u003e“Valid Leads”\u003c\/em\u003e and posts to \u003cstrong\u003eSlack #valid-leads\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003eIf invalid: appends to \u003cem\u003e“Invalid Leads”\u003c\/em\u003e and posts to \u003cstrong\u003eSlack #invalid-leads\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCapture leads from a landing page form and instantly triage quality before sales follow-up.\u003c\/li\u003e\n  \u003cli\u003ePrevent wasted outreach by stopping duplicate entries across both valid and invalid records.\u003c\/li\u003e\n  \u003cli\u003eEnable real-time team awareness via Slack alerts whenever a submission fails validation.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ building blocks\u003c\/strong\u003e: \u003cem\u003ewebhook\u003c\/em\u003e, \u003cem\u003eaggregate\u003c\/em\u003e, \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e (for JS email + Pakistani phone validation), \u003cem\u003eno op\u003c\/em\u003e, \u003cem\u003eGoogle Sheets\u003c\/em\u003e, and \u003cem\u003eSlack\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: Requires a spreadsheet with \u003cem\u003e“Valid Leads”\u003c\/em\u003e and \u003cem\u003e“Invalid Leads”\u003c\/em\u003e tabs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e: Uses Slack OAuth2 and posts to two configurable channels for valid vs. invalid leads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup\u003c\/strong\u003e: Update sheet references\/tabs, add Google Sheets OAuth2, add Slack OAuth2, then configure your webhook URL.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46094160560307,"sku":"N8N-19941","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/s_UIOGHLPmMQDwqnwxqRt_8kiVUVoW.png?v=1790413748","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-validation-google-sheets-dedup-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}