Manage lead follow-ups with Google Sheets, SMTP, and IMAP email
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 26 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Parse Incoming Lead Data (Code): runs custom JavaScript code
- Fetch Follow-Up Tracker Data (Google Sheets): read
- Parse Reply Email Sender (Code): runs custom JavaScript code
- Build Acknowledgment Email Content (Code): runs custom JavaScript code
- Calculate Due Follow-Up Stage (Code): runs custom JavaScript code
- Read Tracker For Reply Match (Google Sheets): read
- Check Ack Email Compliance (Execute Sub-workflow): calls another n8n workflow
- Build Follow-Up Email Content (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Match Reply To Lead Tracker (Code): runs custom JavaScript code
…plus 10 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - If
n8n-nodes-base.if - Send Email
n8n-nodes-base.emailSend - No Operation, do nothing
n8n-nodes-base.noOp - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Email Trigger (IMAP)
n8n-nodes-base.emailReadImap
From the author
Quick Overview This workflow captures new leads via a webhook, sends a compliant acknowledgment email via a guardrail sub-workflow, and logs the lead to Google Sheets. It then runs a daily follow-up sequence via email (SMTP), alerts an attorney after the…