Email New Leads from Google Sheets via Outlook Daily

This n8n workflow sends templated outreach emails to new leads stored in a Google Sheet on a daily schedule, ensuring each lead is contacted only once. It fetches leads, filters uncontacted ones, sends emails via Outlook, and updates the sheet to mark them as processed, creating a simple CRM-lite system without additional tools.

Perfect for sales teams, solo founders, consultants, or marketers collecting leads from forms, ads, or manually in Sheets. It saves hours of manual emailing, ensures timely follow-ups, reduces errors like duplicate contacts, and scales for growing lead volumes while maintaining compliance with one-touch outreach.

Key steps: 1) Schedule Trigger runs daily (e.g., 09:00). 2) Google Sheets retrieves all rows. 3) Filter node selects only rows with empty 'Contacted' field. 4) Outlook Send Email uses dynamic 'to' from lead's email. 5) Google Sheets appendOrUpdate sets 'Contacted=Yes' by matching email.

Setup requires Google Sheets OAuth2 (select lead sheet with Email/Contacted columns) and Outlook Microsoft Graph OAuth2 (quick connect on n8n Cloud or Azure app for self-hosted). Customize email template, schedule, and sheet matching for instant use. High ROI for top-of-funnel automation.