AutomationMart
Home/Browse/Cold email outreach with Gmail and Google Sheets status tracking
n8n

Cold email outreach with Gmail and Google Sheets status tracking

n8nn8n5 modulesv1.0
GmailGoogle Sheets

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
Cold email outreach with Gmail and Google Sheets status tracking workflow diagram

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. ---

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Automatically filter rows in Google Sheets and create corresponding records in Airtable. Streamline data management by connecting Google Sheets with Airtable effortlessly.

Free

Daily WordPress blogging: automate your posts with Google Sheets + HARPA

This scenario automates content posting to your WordPress website. It requires minimal setup and runs using an existing HARPA AI Command. To use it, simply add useful article links to a Google Sheet. The script will run at set intervals, pick an unprocessed article, rewrite it, and post it to your WordPress blog or website. This lets you automate daily content publishing without constant monitoring. AI Command: https://harpa.ai/library/word-press-blog-writer/67c052c183301be3e7101ef1 Google Sh

Free

Send data to an HTTP endpoint and add a new row in Google Sheets

Automatically send data to two HTTP endpoints and add a new row in Google Sheets for streamlined data management and record-keeping.

Free

Gmail MCP workflow - AI-powered email management

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. MCP Gmail Workflow – AI-Powered Email Management ✨ What It Does A smart n8n workflow that connects Gmail with an AI agent (via MCP), letting you send, read, and organize emails using natural language. ⚙️ Key Features 🧠 AI Commands: “Send email to John about the budget” 📥 Inbox Control: Mark read/unread, apply/remove labels 🗂 Smart Organization: Auto-label based on content 🤖 MCP-Ready: Works with

Free

Send an OTP in MSG91 from new Google Sheets spreadsheet rows

Every time a new row is added to a Google Sheets spreadsheet, Make will automatically send an OTP in MSG91. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/18BIel_87gJRo-a5XFSUvYiyCw3ve5P6naZJlypAkLTI/edit?usp=sharing).

Free

Automated LinkedIn profile discovery with Airtop and Google Search

About The LinkedIn Profile Discovery Automation Are you tired of manually searching for LinkedIn profiles or paying expensive data providers for often outdated information? If you spend countless hours trying to find accurate LinkedIn URLs for your prospects or candidates, this automation will change your workflow forever. Just give this workflow the information you have about a contact, and it will automatically augment it with a LinkedIn profile. How to find a LinkedIn Profile Link

Free

Automated YouTube video scheduling & AI metadata generation 🎬

Who Is This For? Content creators, marketing teams, and channel managers who need to streamline video publishing with optimized metadata and scheduled releases across multiple videos. 🛠 What Problem Does This Solve? Manual YouTube video publishing is time-consuming and often results in inconsistent descriptions, tags, and scheduling. This workflow fully automates: Extracting video transcripts via Apify for metadata generation Creating SEO-optimized descriptions and tags for each v

Free

Route Telegram channel posts to X, Threads, and LinkedIn using @mentions

This workflow listens to messages in a designated Telegram channel and automatically posts them to X (Twitter), Threads, and LinkedIn based on simple @mention tags. Write your content once, tag which platforms you want, and let automation handle the rest. Key Features 1. Smart Channel Routing: Use @mentions to specify destinations (@x, @threads, @linkedin, or @all) 2. Clean Message Parsing: Automatically removes @mentions and hashtags before posting 3. Success Notifications: Get confirmation mes

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free