Is this workflow free to use?

Yes, it runs on the free tier of n8n Cloud or any self-hosted instance.

What credentials do I need?

Google Sheets OAuth2 and Microsoft Outlook OAuth2 (or Azure app registration for self-hosted).

How do I import this workflow?

Copy the JSON workflow file into n8n via the import menu or create the nodes manually following the steps.

Email new leads from Google Sheets via Outlook on a schedule

Verified

Email new leads from Google Sheets via Outlook on a daily schedule.

n8nSales & CRMBeginner👁 66 views

Open template

Updated 2026-06-15

What this workflow does

This automation pulls leads from Google Sheets on a schedule, filters out previously contacted rows, sends personalized outreach via Outlook, and logs the contact status back to the sheet to prevent duplicates.

It serves teams managing leads in spreadsheets, solo founders needing simple automated follow-ups, and users building lightweight CRM processes in n8n.

Who is this for?

Teams that collect leads in Google Sheets and want automatic, once-per-lead outreach. Solo founders and consultants running simple top-of-funnel follow-ups.

What problem it solves

Manually emailing new leads from a spreadsheet and tracking who has already been contacted is repetitive and error-prone. This workflow automates daily outreach while preventing duplicate sends.

Live workflow preview

Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.

Open the template on n8n to import and run it. View source template →

What it automates

Daily sales outreach

A solo consultant adds new leads to a shared Sheet each evening; the workflow sends templated emails every morning and marks them contacted.

Marketing lead follow-up

A small marketing team collects webinar sign-ups in Sheets and uses the flow to send personalized welcome emails without spamming existing contacts.

CRM-lite prototyping

Founders testing lightweight lead processes can run this flow before investing in a full CRM tool.

How the workflow works

The 2 nodes in this automation, in order.

1Google SheetsgoogleSheets
2Microsoft OutlookmicrosoftOutlook

Apps & integrations used

Google SheetsMicrosoft Outlook

How to set up Email new leads from Google Sheets via Outlook on a schedule

1Create Google Sheets OAuth2 credential in n8n and connect your account.
2Add Schedule Trigger node set to daily at 09:00.
3Add Google Sheets node (Get rows) pointing to your Leads sheet.
4Insert Filter node to keep only rows where Contacted column is empty.
5Add Outlook Send Email node using {{$json.Email}} as recipient.
6Add final Google Sheets node (appendOrUpdate) to set Contacted = Yes matched on Email.

How to customize this workflow

→Change Schedule Trigger to hourly or weekly
→Add more columns from the sheet into the email template
→Replace Outlook with Gmail or SMTP node
→Insert IF node for lead-score filtering before sending