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
At a glance
Cold email outreach with Gmail and Google Sheets status tracking is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets
- Modules
- 5
- Price
- Free
- Version
- v1.0

About this workflow
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 Authenticate Google Sheets and Gmail nodes via OAuth2 in your n8n credentials settings. 2. Prepare Your Google Sheet Your Google Sheet must contain the following columns: Example: | Email | Name | Is Email Sent | |--------------------|---------------|----------------| | test@example.com | John Doe | | | jane@company.com | Jane Smith | yes | Only rows where "Is Email Sent" is not marked as "yes" will be processed. 3. Customize the Email Template Open the “Send Personalized Email” node and update the message field. You can use variables like: Example Message: 4. Schedule the Workflow Edit the Schedule Trigger node to your preferred time (currently set to 2 PM daily): --- Customization Tips Replace the email copy with your branding or offer. Add more fields (like company or industry) and update the message for deeper personalization. Modify the batch size in the Split In Batches node for rate control. --- Notes & Limitations Gmail Quotas: Gmail has sending limits (e.g., 500 emails/day for free accounts). OAuth2 Scope Approval: Ensure the necessary scopes (e.g., Gmail send and Sheets read/write) are granted. Rate Limiting: If working with large lists, consider time delays or throttle controls. --- Google Sheet Template You can make a copy of this sample Google Sheet to get started. ---
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Filter rows in Google Sheets and create records in Airtable
Daily WordPress blogging: automate your posts with Google Sheets + HARPA
Send data to an HTTP endpoint and add a new row in Google Sheets
Gmail MCP workflow - AI-powered email management
Send an OTP in MSG91 from new Google Sheets spreadsheet rows
Automated LinkedIn profile discovery with Airtop and Google Search
Automated YouTube video scheduling & AI metadata generation 🎬
Route Telegram channel posts to X, Threads, and LinkedIn using @mentions
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you