Email New Leads from Google Sheets via Outlook on Schedule

This n8n workflow sends templated outreach emails to new leads stored in a Google Sheet on a daily schedule. It starts with a Schedule Trigger at a set time (e.g., 09:00), retrieves rows from the sheet, filters for leads where the 'Contacted' field is empty, sends personalized emails via Outlook using the lead's email address, and finally updates the sheet to mark each lead as 'Contacted = Yes' by matching on the email field. This ensures no lead is emailed twice, creating a simple CRM-lite system.

Ideal for teams collecting leads in Sheets who need automatic top-of-funnel follow-ups, solo founders prototyping sales automation, or anyone wanting hands-off lead nurturing without complex tools. It saves hours of manual emailing, reduces errors, and scales effortlessly as leads grow.

Benefits include seamless integration between Google Sheets and Outlook, built-in deduplication logic, and easy customization for templates or schedules. Setup requires Google Sheets OAuth2 credentials, Outlook (Microsoft Graph) OAuth2, and a sheet with 'Email' and 'Contacted' columns. Perfect for marketing automation without coding.