This workflow corresponds to n8n.io template #5603 — we link there as the canonical source.
This workflow follows the Agent → Gmail 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 →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "5646092f-6ced-4e85-afb5-550b8e3d24ff",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1260,
-560
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "36ad95fb-2057-4f63-a712-1a9e1e2e5dce",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"position": [
-780,
-460
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "cd1445a8-e6e5-400c-aac9-1f081b7cdbbb",
"name": "Edit Fields",
"type": "n8n-nodes-base.set",
"position": [
-1000,
-460
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "502c2e3e-c297-4788-b614-906017a79b56",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
460,
-580
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7e42b798-8dc2-4460-8d85-aa4f0107b174",
"name": "Remove Duplicates",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
-560,
-460
],
"parameters": {},
"typeVersion": 2
},
{
"id": "6d344b97-86c4-409e-a9ec-5de067d6f440",
"name": "Clear sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1040,
-620
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "5891472b-e095-4761-b754-39dd84918fcf",
"name": "Send a message",
"type": "n8n-nodes-base.gmail",
"position": [
-320,
-160
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "22781c7b-258b-4caa-8643-f8d67c3e5a70",
"name": "Google Vertex Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleVertex",
"position": [
780,
-360
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2a0bdef4-0526-42e5-aa0e-4978312a2f92",
"name": "Update Google Sheet with Leads",
"type": "n8n-nodes-base.googleSheets",
"position": [
-340,
-460
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "c2e589ec-8bcb-4e0c-a58d-2fa7e98cd7de",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
780,
-580
],
"parameters": {},
"executeOnce": true,
"retryOnFail": false,
"typeVersion": 2
},
{
"id": "10e1a702-0b83-48f0-ba20-024596856af1",
"name": "Code",
"type": "n8n-nodes-base.code",
"position": [
1100,
-580
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ecea920d-2618-4e02-a861-a437fe7321a3",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
960,
-340
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "87beb742-874f-4bbc-973f-f43257fd8147",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
80,
-740
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "aecd7af3-bec2-4ea4-b2ff-9f6ca3d3ba76",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1900,
-740
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"connections": {
"Code": {
"main": [
[]
]
},
"AI Agent": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Clear sheet": {
"main": [
[]
]
},
"Edit Fields": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Remove Duplicates",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Clear sheet",
"type": "main",
"index": 0
},
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Remove Duplicates": {
"main": [
[
{
"node": "Update Google Sheet with Leads",
"type": "main",
"index": 0
}
]
]
},
"Google Vertex Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "AI Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Update Google Sheet with Leads": {
"main": [
[
{
"node": "Send a message",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Built this workflow because most of our users signed up, then vanished after ~30 days. It runs daily, grabs those stale users from Supabase, updates a Google Sheet for tracking, and automatically sends each one a personalized HTML email through Gmail to bring them back.
Source: https://n8n.io/workflows/5603/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This n8n workflow automates the transformation of spreadsheet data into professional charts and graphs using AI-driven analysis. Triggered via Slack, it processes uploaded files (Excel, CSV, Google Sh
• Multi-Layer Message Analysis - Every customer interaction passes through three specialized AI classifiers: privacy detection (identifies sensitive data and security requirements), intent recognition
Handles GDPR Article 15 (access) and Article 17 (erasure) requests end-to-end — from inbound email to legally-compliant response — with zero manual intervention and a full audit trail. 📬 Monitors Gmai
This workflow is designed for Customer Success Managers, Growth Teams, and SaaS Business Owners who want to proactively reduce churn using AI. It automates the analysis of customer health and the deli
This workflow monitors customer health by combining payment behavior, complaint signals, and AI-driven feedback analysis. It runs on daily and weekly schedules to evaluate risk levels, escalate high-r