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

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
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
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.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.