{"product_id":"n8n-lead-follow-up-workflow-google-sheets-email","title":"n8n Lead Follow-Up Workflow: Google Sheets + Email","description":"\u003ch3\u003eAutomatically follow up new leads from a webhook—Google Sheets tracking, compliant emails, and stop-on-reply\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Lead Follow-Up Workflow\u003c\/strong\u003e captures new leads via a \u003cstrong\u003ewebhook\u003c\/strong\u003e, sends a compliant acknowledgment email using a guardrail sub-workflow, logs everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and then runs a \u003cstrong\u003edaily email follow-up sequence\u003c\/strong\u003e that automatically stops when the lead replies (via \u003cstrong\u003eIMAP\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 new lead submissions:\u003c\/strong\u003e A webhook ingests lead details (name, email, phone, practice area) and normalizes them into a tracking record.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a compliant acknowledgment email:\u003c\/strong\u003e The workflow generates an acknowledgment message and routes it through a \u003cstrong\u003ecompliance\/opt-out guardrail sub-workflow\u003c\/strong\u003e. It emails the lead via \u003cstrong\u003eSMTP\u003c\/strong\u003e only when approved.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs leads to Google Sheets:\u003c\/strong\u003e It appends each lead to the \u003cstrong\u003e“Lead Follow-Up Tracker”\u003c\/strong\u003e sheet for ongoing tracking—regardless of whether the acknowledgment email is sent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily follow-ups:\u003c\/strong\u003e On a schedule, it reads the tracker from Google Sheets, determines which leads are due for the next stage, and builds stage-specific follow-up emails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends follow-ups with guardrails:\u003c\/strong\u003e Each follow-up is again processed through the same compliance\/opt-out guardrail and sent via \u003cstrong\u003eSMTP\u003c\/strong\u003e only when approved, then updates the lead’s last sent timestamp and stage in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts the attorney at the final stage:\u003c\/strong\u003e If a lead reaches the final configured follow-up stage without responding, it sends an internal no-response alert email to the attorney via SMTP.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStops outreach when replies arrive:\u003c\/strong\u003e Using \u003cstrong\u003eIMAP\u003c\/strong\u003e, it watches the sending mailbox for incoming replies, matches the sender by email address, and marks the lead as responded in Google Sheets to prevent further follow-up.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLaw firm or legal intake teams that want \u003cstrong\u003estructured lead nurturing\u003c\/strong\u003e with compliance-friendly email controls.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing high-volume inquiries who need \u003cstrong\u003eGoogle Sheets-based pipeline tracking\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers implementing a \u003cstrong\u003ewebhook-to-email follow-up\u003c\/strong\u003e system with “stop when replied” logic.\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 webhook, if, code, no op, email send, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (Lead Follow-Up Tracker), SMTP for outbound email, IMAP for reply detection.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompliance control:\u003c\/strong\u003e guardrail sub-workflow to manage opt-out\/compliance approval before sending.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46058954752179,"sku":"N8N-19680","price":6.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ykFZLMlHrKdLBkm4xPhQo_sVYI2SLn.png?v=1789722767","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-follow-up-workflow-google-sheets-email","provider":"N8N Commerce","version":"1.0","type":"link"}