Capture leads from forms to Google Sheets and send Gmail reminders
n8n16 modulesv1.0System Overview Workflow Name: New Lead and Reminder System What This System Does: This n8n automation captures new leads from a form submission and automatically: Saves them to a Google Sheet database Sends personalized emails to prospects based on their budget Sends you admin notifications of new leads Reminds you daily about leads you haven't called yet Helps you track which leads have been contacted How It Works - Step by Step: PART 1: NEW LEAD CAPTURE Form Submission Trigger - Someone fills
At a glance
Capture leads from forms to Google Sheets and send Gmail reminders is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, Calendly. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets, Calendly
- Modules
- 16
- Price
- Free
- Version
- v1.0
About this workflow
System Overview Workflow Name: New Lead and Reminder System What This System Does: This n8n automation captures new leads from a form submission and automatically: Saves them to a Google Sheet database Sends personalized emails to prospects based on their budget Sends you admin notifications of new leads Reminds you daily about leads you haven't called yet Helps you track which leads have been contacted How It Works - Step by Step: PART 1: NEW LEAD CAPTURE Form Submission Trigger - Someone fills out "Test Form" with: First Name Last Name Email Budget (dropdown: 0-100, 0-1000, 1000+) Message Budget Filter - Rejects leads with "0-100" budget (too small) Google Sheets - Stores the lead with: All form data Submission date "Called" status (starts as FALSE) "Rejected" status (TRUE if budget < 1000, FALSE if 1000+) Lead Routing (Switch Node) - Routes leads to different email templates: Budget 0-1000: Gets email saying "I'll give you a call later this week" Budget 1000+: Gets email saying "Book a call on my Calendly link" Your Notifications - You receive 2 admin emails for every lead: One showing lead details Another with full lead summary PART 2: DAILY REMINDER SYSTEM Schedule Trigger - Runs every day at 8 PM (20:00) Google Sheets Query - Pulls all leads from today that have Called = FALSE Data Processing: Filter1 - Checks if Called = TRUE and deletes completed leads Filter2 - Checks if Called = FALSE and keeps uncalled leads Code Node - Formats uncalled leads into readable text: text Name: [First Name] [Last Name] Email: [Email] Budget: [Budget] Message: [Message] Reminder Email - Sends you the formatted list of uncalled leads to your Gmail After You Call - Mark Called = TRUE in the spreadsheet to remove from tomorrow's reminder Key Features: ✅ Automatic lead qualification - Only accepts budgets of 1000+ ✅ Personalized outreach - Different emails based on budget ✅ Lead database - All leads tracked in Google Sheet ✅ Daily reminders - Never forget uncalled leads ✅ Admin alerts - You get notified immediately when new leads arrive ✅ Lead tracking - Mark "Called" status to track progress
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Personalize an introduction message with ChatGPT for new HubSpot CRM leads and store them on a Google Sheet for review
🗞️ AI-powered sustainability newsletter for marketing with Gmail, GPT-4o
Clone viral TikToks with AI avatars & auto-post to 9 platforms using Perplexity & Blotato
Interview Scheduling Automation with Google Sheets, Calendar, Gmail & GPT-4o'
Monitor competitors' websites for changes with OpenAI and Firecrawl
Import new attachments from Gmail to PowerOffice
Automate Zoom 🎦 user onboarding with OAuth token management and data tables
Generate trend-based marketing videos with Seedance AI, Perplexity, and GPT
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you