Cold Email Outreach with Gmail and Google Sheets Status Tracking

This workflow automates personalized cold email outreach by pulling lead data from a Google Sheet, sending emails via Gmail, and updating the sheet to track who has been contacted.

Features

- Automated Scheduling – Runs daily at a specified hour via the Schedule Trigger node.

- Google Sheets Integration – Fetches leads whose "Is Email Sent" value is empty.

- Batch Processing – Processes leads in manageable batches.

- Personalized Gmail Outreach – Sends custom emails using a pre-written template.

- Status Tracking – Updates each lead’s row after an email is sent to prevent duplicates.

Requirements

- Google Sheets OAuth2 credentials

- Gmail account with OAuth2

- Access to n8n with a deployed instance