Lead outreach automation with Google Sheets, Gmail, and n8n 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)