This workflow corresponds to n8n.io template #4214 — we link there as the canonical source.

This workflow follows the Gmail → Google Sheets recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json

{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "07cbdd82-2df1-41eb-80f3-cfe762ce1d5e",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -40,
        40
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "bbc2f2fe-8f33-4a92-80ab-408655000baa",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "166afe50-aa7b-4e46-8ebc-bd964d670e34",
      "name": "Batch Processing of Leads",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        400,
        40
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "0284614d-d43e-42a1-85cf-2677e06fc1f4",
      "name": "Send Personalized Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        680,
        -60
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "ae48ba04-d428-4aa3-9212-fb49af92c7ae",
      "name": "Fetch Leads",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        180,
        40
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "62e831c3-c67c-4b0c-a0bd-5e4a8fcb23f6",
      "name": "Update Lead Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        880,
        40
      ],
      "parameters": {},
      "typeVersion": 4.5
    }
  ],
  "connections": {
    "Fetch Leads": {
      "main": [
        [
          {
            "node": "Batch Processing of Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Fetch Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Lead Status": {
      "main": [
        [
          {
            "node": "Batch Processing of Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Personalized Email": {
      "main": [
        [
          {
            "node": "Update Lead Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Batch Processing of Leads": {
      "main": [
        [],
        [
          {
            "node": "Send Personalized Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Automated Scheduling – Runs daily at a specified hour via the Schedule Trigger node. Google Sheets Integration – Fetches leads whose value is empty. Batch Processing – Processes leads in manageable batches. Personalized Gmail Outreach – Sends custom emails using a pre-written…

Source: https://n8n.io/workflows/4214/ — original creator credit. Request a take-down →

More Email & Gmail workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Email & Gmail

Extract Structured Data From Gmail Attachments to Google Sheets, Gpt Vision

Automatically extract structured information from emails using AI-powered document analysis. This workflow processes emails from specified domains, classifies them by type, and extracts structured dat

Gmail, HTTP Request, AWS S3 +1

Email & Gmail

Get Gmail Alerts for Dropped Top 10 Keyword Rankings with Dataforseo

This weekly workflow helps you stay on top of SEO visibility losses by automatically detecting when your previously strong keywords fall out of Google’s top 10 results.

N8N Nodes Dataforseo, Google Sheets, Gmail

Email & Gmail

Weekly Stock/etf Analysis with Claude & Gmail — Monthly Index Fund Review

What This Flow Does

Gmail, Google Sheets, HTTP Request +1

Email & Gmail

Send Validated Outreach Emails with Gmail & Google Sheets Anti-spam Controls

This n8n workflow sends personalized outreach emails automatically while enforcing strict safety rules such as email validation, spam checks, daily limits, and human-like delays.

Google Drive, Google Sheets, Gmail

Email & Gmail

Monitor Company Budgets with Bexio, Google Sheets and Gmail Alerts

This n8n template allows you to automatically monitor your company's budget by comparing live Bexio accounting data against targets defined in Google Sheets, sending automated weekly email reports. It

Google Sheets, HTTP Request, Gmail

Cold Email Outreach with Gmail and Google Sheets Status Tracking

The workflow JSON

About this workflow

Related workflows