Lead outreach automation with Google Sheets, Gmail, and n8n workflow
n8n6 modulesv1.0Goal Every 60 minutes: - Fetch only “New” leads from a Google Sheet - Send them a personalized email - Update their status to “Contacted” in the same sheet 🧩 Step-by-Step Explanation 1️⃣ 🕒 Trigger: Run Every Day Node Name: Schedule Trigger What it does: Automatically starts the workflow every 60 minutes (or your chosen interval). Why it's needed: You don’t need to run the workflow manually — it runs on a timer, like a robot doing your follow-up. --- 2
At a glance
Lead outreach automation with Google Sheets, Gmail, and n8n workflow is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets
- Modules
- 6
- Price
- Free
- Version
- v1.0
About this workflow
Goal Every 60 minutes: - Fetch only “New” leads from a Google Sheet - Send them a personalized email - Update their status to “Contacted” in the same sheet 🧩 Step-by-Step Explanation 1️⃣ 🕒 Trigger: Run Every Day Node Name: Schedule Trigger What it does: Automatically starts the workflow every 60 minutes (or your chosen interval). Why it's needed: You don’t need to run the workflow manually — it runs on a timer, like a robot doing your follow-up. --- 2️⃣ 📄 Fetch Leads from Google Sheet Node Name: Fetch Leads from Google Sheet What it does: Connects to your Google Sheet and pulls all the rows of leads. Expected columns: - Name - Email - Status (should be "New" if not yet emailed) --- 3️⃣ 🔍 Filter Only New Leads Node Name: Filter Only New Leads What it does: Filters only rows where Status = New. Why it's needed: Prevents emailing the same lead twice. Old leads are ignored. --- 4️⃣ 🔁 Batch Process Leads Node Name: Batch Process Leads What it does: Splits filtered leads into individual batches (usually one-by-one). Why it's useful: Helps avoid API rate limits or spam blocks by sending emails one at a time. --- 5️⃣ ✉️ Send Email to Lead Node Name: Send Email to Lead What it does: Sends a personalized email to each lead using their name and email. How personalization works: Use variables like {{ $json["Name"] }} in the subject/body. --- 6️⃣ ✅ Mark Lead as Contacted Node Name: Mark Lead as Contacted What it does: Updates the row in Google Sheet, changing Status from New to Contacted. Why it's important: Ensures this lead won't be processed again next time. --- 🔁 Loop Back After updating the lead status, the flow loops back to process the next lead from the batch. --- ✨ Bonus Touch This automation is clean, efficient, and scalable. You can later enhance it by: - Adding AI to write emails dynamically - Sending follow-up reminders - Tracking performance stats in another sheet
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
Automate lead meeting scheduling with Zoho CRM, Google Calendar & Gemini AI
Update a cell in Google Sheets with new emails
Compare hotel prices across booking platforms with Scrape.do and Google Sheets
Fetch Google Sheets data and send it via HTTP request
Scrape Linkedin Profile (Company) and Store in Google Sheets
Add Google Sheets rows for new Tally responses
🤖 Build a Documentation Expert Chatbot with Gemini RAG Pipeline
IT support chatbot with Google Drive, Pinecone & Gemini | AI doc processing
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