{"product_id":"n8n-lead-filter-workflow-spam-pitches-to-google-sheets","title":"n8n Lead Filter Workflow: Spam\/Pitches to Google Sheets","description":"\u003ch3\u003eTurn contact-form submissions into real leads—automatically filter spam and pitches\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Lead Filter Workflow\u003c\/strong\u003e captures website form submissions, validates and enriches them with \u003cstrong\u003eTwilio Lookup\u003c\/strong\u003e and \u003cstrong\u003eOpenAI\u003c\/strong\u003e, then files each entry into the right \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tab—\u003cstrong\u003eLeads\u003c\/strong\u003e, \u003cstrong\u003ePitches\u003c\/strong\u003e, or \u003cstrong\u003eSpam\u003c\/strong\u003e—while notifying you via \u003cstrong\u003eGmail\u003c\/strong\u003e (and optional \u003cstrong\u003eTwilio SMS\u003c\/strong\u003e).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers\u003c\/strong\u003e when a website form posts to a webhook, when an n8n built-in form is submitted, on a scheduled \u003cstrong\u003eMonday 7am\u003c\/strong\u003e run, or via a one-time manual setup.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes inputs\u003c\/strong\u003e (name, email, phone, message, etc.) and checks the recent “Leads” tab to detect repeat contacts.\u003c\/li\u003e\n  \u003cli\u003eRuns \u003cstrong\u003erule-based spam checks\u003c\/strong\u003e including honeypot detection, too-fast submissions, excessive links, disposable emails, and missing contact details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates phone numbers\u003c\/strong\u003e using the \u003cstrong\u003eTwilio Lookup API\u003c\/strong\u003e when applicable.\u003c\/li\u003e\n  \u003cli\u003eReads your \u003cstrong\u003eServices\u003c\/strong\u003e definitions from Google Sheets and sends the submission plus validation results to \u003cstrong\u003eOpenAI\u003c\/strong\u003e to classify it as: \u003cem\u003ecustomer\/vendor pitch\/job seeker\/spam\/unclear\u003c\/em\u003e, including urgency, summary, and a suggested reply.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends\u003c\/strong\u003e the classified result into the proper Google Sheets tab: \u003cstrong\u003eLeads\u003c\/strong\u003e, \u003cstrong\u003ePitches\u003c\/strong\u003e, or \u003cstrong\u003eSpam\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies you\u003c\/strong\u003e by email via \u003cstrong\u003eGmail\u003c\/strong\u003e for leads (and optionally sends you \u003cstrong\u003eTwilio SMS\u003c\/strong\u003e), with an optional acknowledgment email to the customer.\u003c\/li\u003e\n  \u003cli\u003eSends a \u003cstrong\u003eweekly Gmail summary\u003c\/strong\u003e every Monday at 7am based on the last 7 days across the three tabs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eStop spam and low-quality pitches from polluting your CRM spreadsheets.\u003c\/li\u003e\n  \u003cli\u003eAuto-route inbound messages into “Leads” vs “Pitches” vs “Spam” with AI-assisted classification.\u003c\/li\u003e\n  \u003cli\u003eEnrich submissions with Twilio phone validation and a suggested response to speed up follow-up.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/nodes:\u003c\/strong\u003e if, set, code, gmail, switch, twilio\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData storage:\u003c\/strong\u003e Google Sheets (“Leads” tab plus destinations for Pitches and Spam)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI + enrichment:\u003c\/strong\u003e Twilio Lookup API + OpenAI classification using your Google Sheets “Services” definitions\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232445878451,"sku":"N8N-21024","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/dl_qxsyIuIPNrKXwh-Bto_NzHbk8AB.png?v=1792142634","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-filter-workflow-spam-pitches-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}