Mirza Ajmal This workflow corresponds to n8n.io template #8617 — we link there as the canonical source.
This workflow follows the Agent → Documentdefaultdataloader 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": "XgsXH7wbG1iTYTIF",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "AI Lead Enrichment & Outreach Automation for B2B Real Estate (Apify + Relevance + OpenAI + Google Sheets)",
"tags": [],
"nodes": [
{
"id": "48d7e3ec-d671-4dc1-b6b0-7fad93a16a7d",
"name": "Fillout Trigger",
"type": "n8n-nodes-fillout.filloutTrigger",
"position": [
-2656,
192
],
"parameters": {},
"typeVersion": 1
},
{
"id": "43d9ceec-e933-4635-8660-4dca13e432f2",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2736,
352
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e669bef9-d261-4083-9ad2-ecbc89af2126",
"name": "Pinecone Vector Store",
"type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
"position": [
3120,
384
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "f0489736-31fd-422f-81e1-63dbd313cd34",
"name": "Embeddings OpenAI",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
2944,
432
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "23d786f2-6c89-42f0-83d3-f33fed8cb300",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
4416,
480
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "59c6d838-5933-43d2-b58c-ecd2ce425f8a",
"name": "Google Sheets Trigger",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-2224,
2240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c20afd25-2bdb-4128-a027-459a1ddf0981",
"name": "Send a message4",
"type": "n8n-nodes-base.gmail",
"position": [
-1168,
2224
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "01c30b92-6324-4ca7-a869-c73f62714755",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-560,
2160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3e53b8bf-e7b6-4758-ad40-9c9fcfa0959f",
"name": "Embeddings OpenAI1",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
192,
2384
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "8289bff9-6563-4a31-9109-774dafd548ac",
"name": "Default Data Loader",
"type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
"position": [
368,
2432
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "765c0be2-faeb-45cc-b287-9f8ece319742",
"name": "Map Fillout Submission Fields",
"type": "n8n-nodes-base.set",
"position": [
-2416,
192
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "06c08765-06d7-4187-ab7e-1538a9cc45b9",
"name": "Append/Update Raw Leads Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2192,
192
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "037d777a-e2c9-447b-ad5e-b06a22cdacee",
"name": "Verify Email with Apify",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1120,
-576
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "7eddd356-2ff3-47fc-a674-76bcda75b480",
"name": "Map Email Validation Fields",
"type": "n8n-nodes-base.set",
"position": [
-912,
-576
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "a9bd2f23-b773-4664-9102-5a2f2f78306f",
"name": "Email Validation Status Switch",
"type": "n8n-nodes-base.switch",
"position": [
-704,
-576
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "71d98f7f-2988-49b8-a248-2f556445520a",
"name": "Prepare Website Field",
"type": "n8n-nodes-base.set",
"position": [
-1136,
-96
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "a99a4119-cf84-42eb-b068-3fc67f3903e8",
"name": "Crawl Company Website Content",
"type": "n8n-nodes-base.httpRequest",
"position": [
-928,
-96
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "22334014-6a93-4860-bb6f-eabef73d6627",
"name": "Map Website Text Content",
"type": "n8n-nodes-base.set",
"position": [
-704,
-96
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "5b42027a-dacc-479c-bb25-f6da163b1fa2",
"name": "Prepare LinkedIn Profile URL",
"type": "n8n-nodes-base.set",
"position": [
-1232,
480
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "e3fa3f35-35fd-4513-a7d1-a1f39da3adeb",
"name": "Fetch LinkedIn Profile Details",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1056,
480
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "43d46f19-a506-4103-9915-51b2933ccfb5",
"name": "Map LinkedIn Data for Merge",
"type": "n8n-nodes-base.set",
"position": [
-608,
480
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "ff48cdfe-1457-49d5-a635-e88edf705c9e",
"name": "Extract PDF URL from Fillout",
"type": "n8n-nodes-base.set",
"position": [
-1296,
1120
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "ce4d1143-afe1-4268-ba86-eee1f243a4cc",
"name": "Download Project Brief PDF",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1152,
1120
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "a065e9c6-0251-414c-96a2-0f0d1df1a2b1",
"name": "Upload PDF to Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
-992,
1120
],
"parameters": {},
"typeVersion": 3
},
{
"id": "6c94d934-21bc-4534-b45f-774c449975a0",
"name": "Download PDF from Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
-832,
1120
],
"parameters": {},
"typeVersion": 3
},
{
"id": "c6669252-2083-4aa8-85f8-9802b81489b9",
"name": "Extract Text from PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-656,
1120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0499b30b-f46c-4367-8c62-14564c0ea73c",
"name": "Map LinkedIn Data for Merge1",
"type": "n8n-nodes-base.set",
"position": [
-448,
1120
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "785d2b6f-201f-48dc-a040-96ef7007270c",
"name": "Merge Email Validation & Website Content",
"type": "n8n-nodes-base.merge",
"position": [
448,
-96
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "52ab63bd-5959-4894-bf16-ec0e9f8d5c07",
"name": "Merge LinkedIn Profile & PDF Text",
"type": "n8n-nodes-base.merge",
"position": [
448,
592
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "f79b950f-de9f-4fa5-b421-7fc3709460c7",
"name": "Combine All Lead Data",
"type": "n8n-nodes-base.merge",
"position": [
1216,
176
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "2a5c098e-c5d1-4e08-84e2-6cce74bd9bec",
"name": "Format LinkedIn Profile for Insertion",
"type": "n8n-nodes-base.code",
"position": [
-848,
480
],
"parameters": {},
"typeVersion": 2
},
{
"id": "6b18c596-60e4-4de7-ab62-0184e9bb373a",
"name": "Generate LinkedIn Profile Summary",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1888,
208
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "b0095d04-0296-4acc-b126-df22cf22ab74",
"name": "Generate Company Summary",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
2384,
208
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "aad12c6b-1409-4ef5-9656-69ac7559fdb2",
"name": "Generate Project Summary",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
2832,
208
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "27ceff34-e4db-4c2c-858a-3b1da807ae6e",
"name": "Generate Personalized Icebreaker & Lead Score",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
3136,
208
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "54aa2b65-7e64-455c-9d37-d4b7b612b6c2",
"name": "Parse AI Agent Output (Lead Score & Message)",
"type": "n8n-nodes-base.code",
"position": [
3728,
256
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f45cda25-4f9c-4fd2-ac23-462d3e00f090",
"name": "Append/Update Leads with AI Summaries",
"type": "n8n-nodes-base.googleSheets",
"position": [
3936,
256
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "19a5961b-d565-4ea5-9144-889e25e61b4d",
"name": "Hot Lead Alert Switch",
"type": "n8n-nodes-base.switch",
"position": [
3984,
448
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "28f79cce-078c-4c7c-9963-75134607461c",
"name": "Hot Lead Slack Notification",
"type": "n8n-nodes-base.slack",
"position": [
4224,
448
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "733d4820-fb65-4e56-8323-7b818bbf41de",
"name": "Normal Lead Slack Notification",
"type": "n8n-nodes-base.slack",
"position": [
4112,
576
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "8e9b7f75-1645-4c1c-b39f-090e1a3fb0f6",
"name": "Generate Summary for PDF Export",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
4240,
272
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "e53ecf12-c5c4-4346-934f-5f71d5c976c3",
"name": "Generate PDF Summary via Pdforge API",
"type": "n8n-nodes-base.httpRequest",
"position": [
4688,
256
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "078ac5fc-b4c5-455a-9b71-020513192311",
"name": "Download Generated PDF File",
"type": "n8n-nodes-base.httpRequest",
"position": [
4896,
256
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "37d6b1e5-1a0c-448c-af61-2d3d80161be3",
"name": "Upload PDF to Google Drive1",
"type": "n8n-nodes-base.googleDrive",
"position": [
5104,
256
],
"parameters": {},
"typeVersion": 3
},
{
"id": "2ee010a0-9164-450c-8c4e-d5fdeab84c80",
"name": "Append/Update Google Sheet with PDF File url",
"type": "n8n-nodes-base.googleSheets",
"position": [
5312,
256
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "7e86b270-0997-4c28-a314-beb4d7486542",
"name": "Rename Uploaded PDF with Client Name & Project",
"type": "n8n-nodes-base.googleDrive",
"position": [
5568,
256
],
"parameters": {},
"typeVersion": 3
},
{
"id": "1ecc1ec7-2ccc-4004-8766-0df620640591",
"name": "Download Renamed PDF for Sending",
"type": "n8n-nodes-base.googleDrive",
"position": [
5776,
256
],
"parameters": {},
"typeVersion": 3
},
{
"id": "14a4fddb-b85b-4e45-8dd6-4517547ac80a",
"name": "Email PDF Summary to Internal Team",
"type": "n8n-nodes-base.gmail",
"position": [
6176,
208
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "ad97fda3-7884-4be8-bd17-91326202d81f",
"name": "Post Project Alert",
"type": "n8n-nodes-base.slack",
"position": [
6080,
384
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "ad4fd7a7-8403-4c88-8c21-c5acb0251cc8",
"name": "Action Field Switch",
"type": "n8n-nodes-base.switch",
"position": [
-2016,
2240
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "ad7527b5-9b16-412b-b276-6d1693801f01",
"name": "Extract Icebreaker Text Fields",
"type": "n8n-nodes-base.set",
"position": [
-1792,
2224
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "9ba0f477-04d7-4100-a815-c6f98aaa1026",
"name": "Parse Icebreaker Subject and Body",
"type": "n8n-nodes-base.code",
"position": [
-1584,
2224
],
"parameters": {},
"typeVersion": 2
},
{
"id": "2b6ddf56-6d89-43e7-ac64-0d674bf300e3",
"name": "Map Icebreaker Text for Sending",
"type": "n8n-nodes-base.set",
"position": [
-1376,
2224
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "0064019c-975a-4043-b4f9-c54658497714",
"name": "Update Google Sheet with Action Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
-944,
2224
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "e50e8feb-4bcc-4d4a-9895-ed561be2023b",
"name": "Search PDFs in Google Drive Folder",
"type": "n8n-nodes-base.googleDrive",
"position": [
-304,
2160
],
"parameters": {},
"typeVersion": 3
},
{
"id": "eb98584c-009e-4a2e-902a-9f8415dc6234",
"name": "Download Selected PDF for Processing",
"type": "n8n-nodes-base.googleDrive",
"position": [
-96,
2160
],
"parameters": {},
"typeVersion": 3
},
{
"id": "60f10fb5-17c5-46dd-bd16-5bdd2672942e",
"name": "Extract Text from Downloaded PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
112,
2160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e287bcf6-f31d-424b-af3f-b7c3af25399f",
"name": "Insert PDF Text into Pinecone Index",
"type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
"position": [
320,
2160
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "83ea3caa-173e-4ad1-b76f-152e121ca342",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1184,
-800
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "55ba024b-88ef-48ef-8164-c412af0c381e",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2720,
-112
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e4253a05-7f03-4873-99aa-e50ab8cf8620",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
-320
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a265d4d4-64fc-4eca-b1e7-6d7220633b5a",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1296,
160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "256ab967-a40c-418e-9842-92f7da0f8138",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1328,
784
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1fe636c3-74ab-43b6-bcd0-e0e9f34fa19a",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
224,
-288
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4be5c5c0-d15f-42cf-bc47-6e0eadbbb0ef",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
192,
368
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d86cd6b3-f988-4932-9637-ad7fc95981b5",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
-64
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6b20b111-d8e6-449d-8625-5350daf59c9b",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1776,
-16
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "203d5665-484a-4c98-9c48-f0208590efb4",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
3552,
-160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "41bb3548-6e7b-4442-94d4-58dd17d91424",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
4624,
-64
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "727ef5d2-614f-4cb3-8c5c-54df56442a84",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
5488,
-64
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8bc27d1d-cd5f-44ab-aa0c-bf10cb559a8a",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2256,
1872
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7d0a36bc-2caf-4db9-9dc6-3db790dfc99e",
"name": "Sticky Note13",
"type": "n8n-nodes-base.stickyNote",
"position": [
-672,
1872
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "a668db46-a3cb-423f-9526-4fe83bd656a1",
"connections": {
"Fillout Trigger": {
"main": [
[
{
"node": "Map Fillout Submission Fields",
"type": "main",
"index": 0
}
]
]
},
"Send a message4": {
"main": [
[
{
"node": "Update Google Sheet with Action Status",
"type": "main",
"index": 0
}
]
]
},
"Embeddings OpenAI": {
"ai_embedding": [
[
{
"node": "Pinecone Vector Store",
"type": "ai_embedding",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Generate Personalized Icebreaker & Lead Score",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Generate Summary for PDF Export",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Embeddings OpenAI1": {
"ai_embedding": [
[
{
"node": "Insert PDF Text into Pinecone Index",
"type": "ai_embedding",
"index": 0
}
]
]
},
"Action Field Switch": {
"main": [
[
{
"node": "Extract Icebreaker Text Fields",
"type": "main",
"index": 0
}
],
[]
]
},
"Default Data Loader": {
"ai_document": [
[
{
"node": "Insert PDF Text into Pinecone Index",
"type": "ai_document",
"index": 0
}
]
]
},
"Combine All Lead Data": {
"main": [
[
{
"node": "Generate LinkedIn Profile Summary",
"type": "main",
"index": 0
}
]
]
},
"Extract Text from PDF": {
"main": [
[
{
"node": "Map LinkedIn Data for Merge1",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets Trigger": {
"main": [
[
{
"node": "Action Field Switch",
"type": "main",
"index": 0
}
]
]
},
"Hot Lead Alert Switch": {
"main": [
[
{
"node": "Hot Lead Slack Notification",
"type": "main",
"index": 0
}
],
[
{
"node": "Normal Lead Slack Notification",
"type": "main",
"index": 0
}
]
]
},
"Pinecone Vector Store": {
"ai_tool": [
[
{
"node": "Generate Personalized Icebreaker & Lead Score",
"type": "ai_tool",
"index": 0
}
]
]
},
"Prepare Website Field": {
"main": [
[
{
"node": "Crawl Company Website Content",
"type": "main",
"index": 0
}
]
]
},
"Verify Email with Apify": {
"main": [
[
{
"node": "Map Email Validation Fields",
"type": "main",
"index": 0
}
]
]
},
"Generate Company Summary": {
"main": [
[
{
"node": "Generate Project Summary",
"type": "main",
"index": 0
}
]
]
},
"Generate Project Summary": {
"main": [
[
{
"node": "Generate Personalized Icebreaker & Lead Score",
"type": "main",
"index": 0
}
]
]
},
"Map Website Text Content": {
"main": [
[
{
"node": "Merge Email Validation & Website Content",
"type": "main",
"index": 1
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Generate Summary for PDF Export",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Download Project Brief PDF": {
"main": [
[
{
"node": "Upload PDF to Google Drive",
"type": "main",
"index": 0
}
]
]
},
"Upload PDF to Google Drive": {
"main": [
[
{
"node": "Download PDF from Google Drive",
"type": "main",
"index": 0
}
]
]
},
"Download Generated PDF File": {
"main": [
[
{
"node": "Upload PDF to Google Drive1",
"type": "main",
"index": 0
}
]
]
},
"Map Email Validation Fields": {
"main": [
[
{
"node": "Email Validation Status Switch",
"type": "main",
"index": 0
}
]
]
},
"Map LinkedIn Data for Merge": {
"main": [
[
{
"node": "Merge LinkedIn Profile & PDF Text",
"type": "main",
"index": 0
}
]
]
},
"Upload PDF to Google Drive1": {
"main": [
[
{
"node": "Append/Update Google Sheet with PDF File url",
"type": "main",
"index": 0
}
]
]
},
"Extract PDF URL from Fillout": {
"main": [
[
{
"node": "Download Project Brief PDF",
"type": "main",
"index": 0
}
]
]
},
"Map LinkedIn Data for Merge1": {
"main": [
[
{
"node": "Merge LinkedIn Profile & PDF Text",
"type": "main",
"index": 1
}
]
]
},
"Prepare LinkedIn Profile URL": {
"main": [
[
{
"node": "Fetch LinkedIn Profile Details",
"type": "main",
"index": 0
}
]
]
},
"Append/Update Raw Leads Sheet": {
"main": [
[
{
"node": "Verify Email with Apify",
"type": "main",
"index": 0
},
{
"node": "Prepare Website Field",
"type": "main",
"index": 0
},
{
"node": "Prepare LinkedIn Profile URL",
"type": "main",
"index": 0
},
{
"node": "Extract PDF URL from Fillout",
"type": "main",
"index": 0
},
{
"node": "Merge LinkedIn Profile & PDF Text",
"type": "main",
"index": 2
}
]
]
},
"Crawl Company Website Content": {
"main": [
[
{
"node": "Map Website Text Content",
"type": "main",
"index": 0
}
]
]
},
"Map Fillout Submission Fields": {
"main": [
[
{
"node": "Append/Update Raw Leads Sheet",
"type": "main",
"index": 0
}
]
]
},
"Download PDF from Google Drive": {
"main": [
[
{
"node": "Extract Text from PDF",
"type": "main",
"index": 0
}
]
]
},
"Email Validation Status Switch": {
"main": [
[],
[
{
"node": "Merge Email Validation & Website Content",
"type": "main",
"index": 0
}
]
]
},
"Extract Icebreaker Text Fields": {
"main": [
[
{
"node": "Parse Icebreaker Subject and Body",
"type": "main",
"index": 0
}
]
]
},
"Fetch LinkedIn Profile Details": {
"main": [
[
{
"node": "Format LinkedIn Profile for Insertion",
"type": "main",
"index": 0
}
]
]
},
"Generate Summary for PDF Export": {
"main": [
[
{
"node": "Generate PDF Summary via Pdforge API",
"type": "main",
"index": 0
}
]
]
},
"Map Icebreaker Text for Sending": {
"main": [
[
{
"node": "Send a message4",
"type": "main",
"index": 0
}
]
]
},
"Download Renamed PDF for Sending": {
"main": [
[
{
"node": "Email PDF Summary to Internal Team",
"type": "main",
"index": 0
},
{
"node": "Post Project Alert",
"type": "main",
"index": 0
}
]
]
},
"Extract Text from Downloaded PDF": {
"main": [
[
{
"node": "Insert PDF Text into Pinecone Index",
"type": "main",
"index": 0
}
]
]
},
"Generate LinkedIn Profile Summary": {
"main": [
[
{
"node": "Generate Company Summary",
"type": "main",
"index": 0
}
]
]
},
"Merge LinkedIn Profile & PDF Text": {
"main": [
[
{
"node": "Combine All Lead Data",
"type": "main",
"index": 1
}
]
]
},
"Parse Icebreaker Subject and Body": {
"main": [
[
{
"node": "Map Icebreaker Text for Sending",
"type": "main",
"index": 0
}
]
]
},
"Search PDFs in Google Drive Folder": {
"main": [
[
{
"node": "Download Selected PDF for Processing",
"type": "main",
"index": 0
}
]
]
},
"Download Selected PDF for Processing": {
"main": [
[
{
"node": "Extract Text from Downloaded PDF",
"type": "main",
"index": 0
}
]
]
},
"Generate PDF Summary via Pdforge API": {
"main": [
[
{
"node": "Download Generated PDF File",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Search PDFs in Google Drive Folder",
"type": "main",
"index": 0
}
]
]
},
"Append/Update Leads with AI Summaries": {
"main": [
[
{
"node": "Generate Summary for PDF Export",
"type": "main",
"index": 0
},
{
"node": "Hot Lead Alert Switch",
"type": "main",
"index": 0
}
]
]
},
"Format LinkedIn Profile for Insertion": {
"main": [
[
{
"node": "Map LinkedIn Data for Merge",
"type": "main",
"index": 0
}
]
]
},
"Merge Email Validation & Website Content": {
"main": [
[
{
"node": "Combine All Lead Data",
"type": "main",
"index": 0
}
]
]
},
"Append/Update Google Sheet with PDF File url": {
"main": [
[
{
"node": "Rename Uploaded PDF with Client Name & Project",
"type": "main",
"index": 0
}
]
]
},
"Parse AI Agent Output (Lead Score & Message)": {
"main": [
[
{
"node": "Append/Update Leads with AI Summaries",
"type": "main",
"index": 0
}
]
]
},
"Generate Personalized Icebreaker & Lead Score": {
"main": [
[
{
"node": "Parse AI Agent Output (Lead Score & Message)",
"type": "main",
"index": 0
}
]
]
},
"Rename Uploaded PDF with Client Name & Project": {
"main": [
[
{
"node": "Download Renamed PDF for Sending",
"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
This advanced n8n workflow automates the full lead enrichment, qualification, and personalized outreach process tailored specifically for the B2B real estate sector. Integrating top platforms like Apify, Relevance, OpenAI, and Google Sheets, it empowers sales and marketing teams…
Source: https://n8n.io/workflows/8617/ — 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.
Your AI workforce is ready. Are you?
Google Sheets Tool, Mcp Trigger, Google Drive +29
This comprehensive workflow bundle is designed as a powerful starter kit, enabling you to build a multi-functional AI assistant on Telegram. It seamlessly integrates AI-powered voice interactions, an
Telegram Trigger, Telegram, OpenAI +19
This intelligent chatbot leverages cutting-edge financial APIs and AI-driven analysis to deliver comprehensive stock research reports. Get instant access to professional-grade investment analysis that
Tool Think, Supabase Vector Store, OpenAI Embeddings +15
This n8n template automatically classifies incoming emails (Sales, Support, Internal, Finance, Promotions) and routes them to a dedicated OpenAI LLM Agent for processing. Depending on the category, th
OpenAI, Gmail, Text Classifier +16
Who is this for? This workflow is ideal for HR teams, startups, and enterprises that want to handle employee interactions through WhatsApp and automate responses using LLM (OpenAI) and intelligent rou
WhatsApp Trigger, OpenAI, OpenAI Chat +13