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 – Ru...
Template notes
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
---
Setup Instructions
1. Connect Accounts