Email new leads from Google Sheets via Outlook on a schedule

Automatically emails new leads from Google Sheets via Outlook on a daily schedule and marks them as contacted to prevent duplicates.

workflowlead_generation

by Robert Breenon n8n

Nodes

Triggers

Platform

n8n

Tech Stack

Microsoft Outlook

Google Sheets

How It Works

This workflow runs daily to pull leads from Google Sheets, filters for uncontacted prospects, and sends personalized outreach emails through Outlook. After sending each email, it updates the spreadsheet to mark leads as contacted, ensuring no duplicate emails are sent.

Schedule daily execution

A scheduled trigger runs the workflow daily at a specified time, such as 9:00 AM, to automatically process new leads.

Fetch leads from Google Sheets

Retrieves all rows from your designated Google Sheets document containing lead information including email addresses and contact status.

Filter uncontacted leads

Filters the retrieved data to include only leads where the Contacted column is empty, preventing duplicate outreach to previously contacted prospects.

Send outreach emails via Outlook

Sends a templated email to each filtered lead using their email address from the spreadsheet through Microsoft Outlook.

Attached Files

workflow.json