AutomationFlowsAI & RAG › Cold Email Outreach Personalized by Business with Gmail, Google Sheet and Gemini

Cold Email Outreach Personalized by Business with Gmail, Google Sheet and Gemini

ByZain Khan @zain on n8n.io

Categories: Lead Generation, Business Automation, AI

Cron / scheduled trigger★★★★☆ complexityAI-powered13 nodesAgentGoogle Gemini ChatGmail ToolGoogle Sheets ToolHTTP Request ToolGoogle Sheets
AI & RAG Trigger: Cron / scheduled Nodes: 13 Complexity: ★★★★☆ AI nodes: yes Added:

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

This workflow follows the Agent → Gmail Tool 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
{
  "nodes": [
    {
      "id": "49878243-142e-4b32-a3e2-76c8dca37d96",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        624,
        0
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "12d2a156-40af-47a2-b3bf-d26ae44ed763",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -176,
        -176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1faffda1-ca81-40e6-a0f3-cbf92bb0282f",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -864,
        -176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "154ea153-3e9d-48cc-934a-18ce2b77f94b",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -864,
        -544
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ae363ca2-083b-4382-8a30-48289dbf890c",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -80,
        0
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "ae9d8cb1-e1bf-4b72-bfc4-e1b40da73e03",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1280,
        32
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "7bdc8f65-61b7-4d4a-8f53-b6a72ca61845",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        1184,
        320
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b4287490-44a5-4e82-9aef-e7242ace6bc7",
      "name": "Send a message in Gmail",
      "type": "n8n-nodes-base.gmailTool",
      "position": [
        1680,
        320
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "13a93835-87ca-4ab5-a917-032d007eaa66",
      "name": "Update Status",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        1536,
        320
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "a13efb7d-e848-4bd0-9bfa-861091336787",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequestTool",
      "position": [
        1408,
        320
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "717dd4b7-b1d9-4edb-af2e-d433164027dd",
      "name": "If Email Exists",
      "type": "n8n-nodes-base.if",
      "position": [
        912,
        16
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "b5b8aad7-24f2-4a48-9603-54aa21488f17",
      "name": "Get Leads",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        416,
        0
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "fd8aa925-25cc-4d22-9e6a-ee100332f07c",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        176,
        0
      ],
      "parameters": {},
      "typeVersion": 3.4
    }
  ],
  "connections": {
    "AI Agent": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Leads": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Get Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Update Status": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "If Email Exists": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "If Email Exists",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message in Gmail": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

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

About this workflow

Categories: Lead Generation, Business Automation, AI

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

More AI & RAG workflows → · Browse all categories →

Related workflows

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

AI & RAG

This template is for clinics, hospitals, care teams, and telemedicine providers who need a structured, automated system for post-surgery follow-up. It helps reduce manual workload while ensuring every

Google Sheets, Telegram, Telegram Trigger +7
AI & RAG

Schedules automated vendor pricing analysis across multiple sources. Fetches delivery reliability and contract data, analyzes vendor performance using Claude AI, then distributes consolidated reports

HTTP Request, Airtable, OpenAI Chat +9
AI & RAG

This workflow is the AI analysis and alerting engine for a complete social media monitoring system. It's designed to work with data scraped from X (formerly Twitter) using a tool like the Apify Tweet

Google Sheets, Google Gemini Chat, Google Sheets Tool +4
AI & RAG

Template Name: AI Personal Assistant - Task & Email Management Price: $27 Category: Productivity & Automation Difficulty: Intermediate Use Case: Personal productivity automation for busy professionals

Telegram, HTTP Request, OpenAI +8
AI & RAG

This workflow automates end-to-end ESG (Environmental, Social, and Governance) sustainability reporting for enterprise sustainability teams, compliance officers, and green governance leads. It solves

Agent, OpenAI Chat, Output Parser Structured +12