Rahul Joshi This workflow corresponds to n8n.io template #9407 — we link there as the canonical source.
This workflow follows the Agent → 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 →
{
"id": "sWPZWgk6NelYRau1",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Auto-Personalized First Touch (New Leads)",
"tags": [],
"nodes": [
{
"id": "cf5722fd-a808-4986-af8f-df5678d7b65f",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-496,
368
],
"parameters": {},
"typeVersion": 1
},
{
"id": "edba5fac-43e6-42fd-a214-e1e7b64feb69",
"name": "Fetch Leads from Google Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-272,
368
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "b0eac1b3-ceed-486f-8c8c-6b6c41dc3f92",
"name": "AI Research & Personalization Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
176,
368
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "0be1c1b5-2362-4bbf-8a4c-a79bf4587881",
"name": "GPT-4o Mini Language Model",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
240,
592
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f97ac708-480d-46f7-abd9-f9a26bf167f4",
"name": "Process Leads One by One",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-48,
368
],
"parameters": {},
"typeVersion": 3
},
{
"id": "fb010d21-912e-49c3-882a-88501adb77e3",
"name": "Parse AI Response to Fields",
"type": "n8n-nodes-base.code",
"position": [
528,
368
],
"parameters": {},
"typeVersion": 2
},
{
"id": "de0e3bd5-a3eb-40a7-846e-7194ce8e5520",
"name": "Write Message Back to Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
752,
368
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "d13b3c5c-77e8-48b9-ac7c-efb1d80eafa5",
"name": "Sticky Note 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
112
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "475df974-f515-46a9-9274-2ac0d4d081f8",
"name": "Sticky Note 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
560
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ab12913e-dbb2-4863-b55b-6170246f3c05",
"name": "Sticky Note 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-224,
112
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9bb9cee7-f943-4423-8690-2633ebd721a1",
"name": "Sticky Note 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
176,
48
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "eeef77e7-0316-47cb-acfd-a2af290d8c28",
"name": "Sticky Note 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
576
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f86697d9-a4d5-4625-9989-b49f51da8b3e",
"name": "Sticky Note 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
656,
64
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "18490d76-c288-445d-b81a-140648ab8587",
"name": "Sticky Note Overview",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1264,
304
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "6c263b18-ec93-4c8c-b81f-675444270942",
"connections": {
"Process Leads One by One": {
"main": [
[],
[
{
"node": "AI Research & Personalization Agent",
"type": "main",
"index": 0
}
]
]
},
"GPT-4o Mini Language Model": {
"ai_languageModel": [
[
{
"node": "AI Research & Personalization Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Parse AI Response to Fields": {
"main": [
[
{
"node": "Write Message Back to Sheet",
"type": "main",
"index": 0
}
]
]
},
"Write Message Back to Sheet": {
"main": [
[
{
"node": "Process Leads One by One",
"type": "main",
"index": 0
}
]
]
},
"Fetch Leads from Google Sheet": {
"main": [
[
{
"node": "Process Leads One by One",
"type": "main",
"index": 0
}
]
]
},
"AI Research & Personalization Agent": {
"main": [
[
{
"node": "Parse AI Response to Fields",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Fetch Leads from Google Sheet",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Generate personalized first-touch messages for every new lead — automatically. This workflow researches each company using AI, crafts a natural opener referencing their mission or focus, and writes the result back to your Google Sheet. Perfect for SDRs, founders, and marketers…
Source: https://n8n.io/workflows/9407/ — 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 workflow is designed for marketers, content creators, agencies, and solo founders who want to publish long‑form posts with visuals on autopilot using n8n and AI agents.
Automate your AI-powered outreach and follow-up pipeline end-to-end with GPT-4o, Gmail, and Google Sheets. 🤖📬 This workflow personalizes emails for each lead, manages follow-ups automatically, tracks
Automatically compare candidate resumes to job descriptions (PDFs) from Google Drive, generate a 0–100 fit score with gap analysis, and update Google Sheets—powered by Azure OpenAI (GPT-4o-mini). Fast
This workflow intelligently analyzes incoming Gmail emails, classifies intent using GPT-4, and sends real-time Slack notifications while logging structured data into Google Sheets. It provides a smart
Episode 15: Startup ideas for YC RFS. Uses lmChatOpenAi, googleSheets, agent, informationExtractor. Event-driven trigger; 33 nodes.