Lead Outreach Automation with Google Sheets, Gmail, and n8n Workflow

<h1>🎯 Goal</h1>
<p>Every 60 minutes:</p>
<ul>
<li>Fetch only “New” leads from a Google Sheet</li>
<li>Send them a personalized email</li>
<li>Update their status to “Contacted” in the same sheet</li>
</ul>

<h2>🧩 Step-by-Step Explanation</h2>

<div>
<h3>1️⃣ 🕒 Trigger: Run Every Day</h3>
<strong>Node Name:</strong> Schedule Trigger
<div>
<strong>What it does:</strong> Automatically starts the workflow every 60 minutes (or your chosen interval).<br>
<strong>Why it's needed:</strong> You don’t need to run the workflow manually — it runs on a timer, like a robot doing your follow-up.
</div>
</div>

<div>
<h3>2️⃣ 📄 Fetch Leads from Google Sheet</h3>
<strong>Node Name:</strong> Fetch Leads from Google Sheet
<div>
<strong>What it does:</strong> Connects to your Google Sheet and pulls all the rows of leads.<br>
<strong>Expected columns:</strong>
<ul>
<li>Name</li>
<li>Email</li>
<li>Status (should be "New" if not yet emailed)</li>
</ul>
</div>
</div>

<div>
<h3>3️⃣ 🔍 Filter Only New Leads</h3>
<strong>Node Name:</strong> Filter Only New Leads
<div>
<strong>What it does:</strong> Filters only rows where Status = New.<br>
<strong>Why it's needed:</strong> Prevents emailing the same lead twice. Old leads are ignored.
</div>
</div>

<div>
<h3>4️⃣ 🔁 Batch Process Leads</h3>
<strong>Node Name:</strong> Batch Process Leads
<div>
<strong>What it does:</strong> Splits filtered leads into individual batches (usually one-by-one).<br>
<strong>Why it's useful:</strong> Helps avoid API rate limits or spam blocks by sending emails one at a time.
</div>
</div>

<div>
<h3>5️⃣ ✉️ Send Email to Lead</h3>
<strong>Node Name:</strong> Send Email to Lead
<div>
<strong>What it does:</strong> Sends a personalized email to each lead using their name and email.<br>
<strong>How personalization works:</strong> Use variables like <code>{{ $json["Name"] }}</code> in the subject/body.
</div>
</div>

<div>
<h3>6️⃣ ✅ Mark Lead as Contacted</h3>
<strong>Node Name:</strong> Mark Lead as Contacted
<div>
<strong>What it does:</strong> Updates the row in Google Sheet, changing Status from New to Contacted.<br>
<strong>Why it's important:</strong> Ensures this lead won't be processed again next time.
</div>
</div>

<div>
<h2>🔁 Loop Back</h2>
<p>After updating the lead status, the flow loops back to process the next lead from the batch.</p>
</div>

<div>
<h2>✨ Bonus Touch</h2>
<p>This automation is clean, efficient, and scalable. You can later enhance it by:</p>
<ul>
<li>Adding AI to write emails dynamically</li>
<li>Sending follow-up reminders</li>
<li>Tracking performance stats in another sheet</li>
</ul>
</div>