Skip to main content

Automated cold email outreach with Gmail & Google Sheets

Workflow preview

Workflow preview
100%
Automated cold email outreach with Gmail & Google Sheets preview
Open on n8n.io
n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER Hostinger Early Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

Description: Boost your sales pipeline with this fully automated Cold Email Outreach workflow in n8n, integrating Gmail and Google Sheets. This template sends cold emails daily at 2 PM to leads fet...

Best for

  • Lead Nurturing automation workflows
  • intermediate n8n builders looking for reusable templates

Tools used

n8n-nodes-base.scheduletrigger, n8n-nodes-base.stickynote, n8n-nodes-base.splitinbatches, n8n-nodes-base.gmail, n8n-nodes-base.googlesheets

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Rahul Joshi.

Original n8n.io source

1.1 Workflow description

Title
Automated cold email outreach with Gmail & Google Sheets
Workflow name
Automated cold email outreach with Gmail & Google Sheets

Description:

Boost your sales pipeline with this fully automated Cold Email Outreach workflow in n8n, integrating Gmail and Google Sheets. This template sends cold emails daily at 2 PM to leads fetched from a Google Sheet. Once an email is sent, the workflow updates the lead's status to prevent duplicates.

✅ Features:

  • Daily scheduled trigger at 2 PM
  • Fetches leads with status "not emailed" from Google Sheets
  • Sends emails via Gmail
  • Updates lead status in Google Sheets post-email
  • Batch processing for efficient outreach

Perfect for freelancers, agencies, and startups looking to automate lead engagement and track responses in real-time — all without writing a single line of code.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Schedule Trigger

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.2

Block 2 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 3 - Batch Processing of Leads

Type / Role
n8n-nodes-base.splitInBatches - splitInBatches
Config choices
Version 3

Block 4 - Send Personalized Email

Type / Role
n8n-nodes-base.gmail - gmail
Config choices
Version 2.1

Block 5 - Fetch Leads

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.5

Block 6 - Update Lead Status

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.5

3. Summary Table

Workflow Automated cold email outreach with Gmail & Google Sheets
Complexity intermediate
Nodes 6
Categories Lead Nurturing
Author Rahul Joshi
Published 12 Jun 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/4896/4896.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Download workflow JSON Original n8n.io source Lead Nurturing workflows

Frequently asked questions

What does Automated cold email outreach with Gmail & Google Sheets do?

Description: Boost your sales pipeline with this fully automated Cold Email Outreach workflow in n8n, integrating Gmail and Google Sheets. This template sends cold emails daily at 2 PM to leads fet...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Lead Nurturing use case.