This workflow follows the Agent → Chat Trigger 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 →
{
"name": "LEAD ACQUISITION APOLLO APIFY",
"nodes": [
{
"parameters": {
"content": "## Lead Acquisition from Apollo(Apify API)\n#### This workflow fetches qualified leads from Apolloio based on specific criteria (e.g., industry, location, job title) and stores the data, including names, LinkedIn profiles, and email addresses, in Google Sheets for further processing.",
"height": 800,
"width": 2480
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-80,
-16
],
"id": "78ffc575-d5d1-45bd-946a-28703b70e5f7",
"name": "Sticky Note"
},
{
"parameters": {
"content": "### Automatically creates a Google Spreadsheet, dynamically naming it based on the chat query.",
"height": 100,
"width": 320,
"color": 4
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
720,
480
],
"id": "53e8dc3a-b24a-4bdb-bb3b-281f1e3b0c53",
"name": "Sticky Note4"
},
{
"parameters": {
"url": "=https://api.apify.com/v2/actor-runs/{{ $json.data.id }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "waitForFinish",
"value": "60"
}
]
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
1200,
320
],
"id": "81e3ec91-524d-4c0b-b9e4-23de4110acc6",
"name": "HTTP Request7"
},
{
"parameters": {
"url": "=https://api.apify.com/v2/datasets/{{ $json.defaultDatasetID }}/items",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"sendQuery": true,
"queryParameters": {
"parameters": [
{}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
1632,
320
],
"id": "22218fcf-634b-4b04-988a-015aa4bd3048",
"name": "HTTP Request8"
},
{
"parameters": {
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"typeVersion": 1.1,
"position": [
0,
320
],
"id": "42819fce-2cc6-489a-a771-92ad8334584b",
"name": "When chat message received"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "22e8f927-4d24-4664-a988-65effc034057",
"leftValue": "={{ $json.id }}",
"rightValue": "=",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1824,
320
],
"id": "b828411b-9c6f-4d85-ab54-b4fe938f855d",
"name": "If3"
},
{
"parameters": {},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
1856,
528
],
"id": "ce4775e4-97c7-4361-9556-d9ab8faba0da",
"name": "Wait"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "af77e1f5-f2bf-4f04-b84a-03a673422e26",
"name": "defaultDatasetID",
"value": "={{ $json.data.defaultDatasetId }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
1424,
320
],
"id": "0467f78a-4c35-43a9-b2f6-2b8042d9713a",
"name": "Edit Fields2"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "b754b255-7f0c-4ef8-9eb7-03773c32e8f4",
"leftValue": "={{ $json.linkedin_url }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
}
},
{
"id": "251e8b8c-bb21-4933-b0f8-5e47a9ef1507",
"leftValue": "={{ $json.email }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
2064,
224
],
"id": "df802c3b-e2b9-40e5-909f-dea64e98a507",
"name": "If4"
},
{
"parameters": {},
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
2176,
448
],
"id": "0692244d-fc91-4fe4-a185-6d1bcc2e3256",
"name": "No Operation, do nothing"
},
{
"parameters": {
"promptType": "define",
"text": "={{ $json.user_query }}",
"options": {
"systemMessage": "=## Role\n\nYou are an AI assistant that helps users generate URLs for searching people on Apollo.io. Your task is to extract the following four parameters from the user's input:\n\n1. **Industry Id**: \n2.**Employee Range**: The range of employees in the organization. \n - If a minimum employee count is not provided, default to **10**.\n - If a maximum employee count is not provided, default to **1,000,000**.\n - Don't include the number of employees in the url if the user didn't specify it.\n3. **Location**: The location of the company (e.g., \"California, US\" or \"Mumbai, India\" )or Countries (example: USA, UAE ,India)\n4. **Job Title**: The job title of the person (e.g., \"Owner\", \"Realtor\", \"Manager\", \"Project Manager\", \"Consultant\").\n5.**Industry ID**: The industry code corresponding to the industry.\n\n### **Industry Codes**\nHere are some common industry codes you can use:\n- **Real Estate**: `5567cd477369645401010000`\n- **Marketing & Advertising**: `5567cd467369644d39040000`\n- **Construction**: `5567cd4773696439dd350000`\n- **Hospitality**: `5567ce9d7369643bc19c0000`\n- **Computer Software**: `5567cd4e7369643b70010000`\n- **Professional Training & Coaching**: `5567cd49736964541d010000`\n- **Staffing & Recruiting**: `5567e09973696410db020800`\n- *Information Technology and Services**: `5567cd4773696439b10b0000`\n- **consumer services**: `5567d1127261697f2b1d0000`\n- **Health,wellness & fitness** : `5567cddb7369644d250c0000`\n- **Hospital & healthcare**: `5567cdde73696439812c0000`\n- **food & beverages** : `5567ce1e7369643b806a0000`\n- **retail** : `5567ced173696450cb580000`\n- **financial services**: `5567cdd67369643e64020000`\n- **education management** : `5567ce9e736964540d540000`\n\n\nOnce you extract these parameters, construct a URL using the following format:\n\n\nOnce you extract these parameters, construct a URL using the following format:\n\nhttps://app.apollo.io/#/people?page=1&sortAscending=false&sortByField=recommendations_score&organizationIndustryTagIds[]=<INDUSTRY_ID>&personLocations[]=<LOCATION>&organizationNumEmployeesRanges[]=<MIN_EMPLOYEE>%2C<MAX_EMPLOYEE>&personTitles[]=<JOB_TITLE>&contactEmailStatusV2[]=verified\n\n#### **Example : Owners of Real Estate Companies in the UAE with Employee Range from 10**\n\nhttps://app.apollo.io/#/people?page=1&sortAscending=false&sortByField=recommendations_score&organizationIndustryTagIds[]=5567cd477369645401010000&personLocations[]=UAE&organizationNumEmployeesRanges[]=10%2C1000000&personTitles[]=owner&contactEmailStatusV2[]=verified\n\n## Notes\n- Don't include the number of employees in the url if the user didn't specify it.\n- Dont provide any other preamble .Only the output url\n"
}
},
"type": "@n8n/n8n-nodes-langchain.agent",
"typeVersion": 1.7,
"position": [
416,
320
],
"id": "ea1eacf3-0753-40d9-a4e3-3bcb67fa748a",
"name": "Apollo Url Agent"
},
{
"parameters": {
"method": "POST",
"url": "=https://api.apify.com/v2/acts/code_crafter~apollo-scraper/runs?token=your_apify_api_token",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"getPersonalEmails\": true,\n \"getWorkEmails\": true,\n \"totalRecords\": 100,\n \"url\": \"{{ $('Apollo Url Agent').item.json.output }}\"\n}",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
976,
320
],
"id": "ad4c9e3e-a0fd-4871-887b-154039a13ee4",
"name": "Apollo Apify"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "2080caac-d3df-4d0f-b6a2-e61b0c07decf",
"name": "user_query",
"value": "={{ $json.chatInput }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
224,
320
],
"id": "b25df70e-7155-4d98-a533-bb8ab282ef62",
"name": "Set User Query"
},
{
"parameters": {
"resource": "spreadsheet",
"title": "={{ $('When chat message received').item.json.chatInput }}",
"sheetsUi": {
"sheetValues": [
{
"title": "Sheet1"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
784,
320
],
"id": "ec84eb5c-14b1-4a44-8a32-4fb1d736a873",
"name": "Create Spreadsheet",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"model": "=gpt-4o-mini",
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"typeVersion": 1.1,
"position": [
416,
544
],
"id": "1ef13c92-956b-4d65-aa7c-7812dc666140",
"name": "OpenAI Chat Model1",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
}
}
],
"connections": {
"HTTP Request7": {
"main": [
[
{
"node": "Edit Fields2",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request8": {
"main": [
[
{
"node": "If3",
"type": "main",
"index": 0
}
]
]
},
"When chat message received": {
"main": [
[
{
"node": "Set User Query",
"type": "main",
"index": 0
}
]
]
},
"If3": {
"main": [
[
{
"node": "If4",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Edit Fields2",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields2": {
"main": [
[
{
"node": "HTTP Request8",
"type": "main",
"index": 0
}
]
]
},
"If4": {
"main": [
[],
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"Apollo Url Agent": {
"main": [
[
{
"node": "Create Spreadsheet",
"type": "main",
"index": 0
}
]
]
},
"Apollo Apify": {
"main": [
[
{
"node": "HTTP Request7",
"type": "main",
"index": 0
}
]
]
},
"Set User Query": {
"main": [
[
{
"node": "Apollo Url Agent",
"type": "main",
"index": 0
}
]
]
},
"Create Spreadsheet": {
"main": [
[
{
"node": "Apollo Apify",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Apollo Url Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1",
"availableInMCP": false
},
"versionId": "e1fb61be-883a-42c5-8d72-74dad3951959",
"id": "5SC8rhpOYmgLiXPG",
"tags": []
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApiopenAiApi
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
This workflow streamlines lead acquisition by automating the search and extraction of potential contacts from Apollo's database, delivering enriched data directly to your Google Sheets for seamless follow-up. It's ideal for sales teams or marketers seeking to scale outreach without manual data entry, saving hours on prospecting. The key step involves using Apify to scrape and process Apollo search results via HTTP requests, followed by AI-driven validation with OpenAI to ensure lead quality before appending to your sheet.
Use this workflow when you need quick, targeted lead lists from Apollo for campaigns, such as identifying decision-makers in specific industries. Avoid it for high-volume enterprise needs requiring custom compliance, or if you lack API access to Apollo. Common variations include swapping Google Sheets for CRM tools like HubSpot, or adding email verification nodes for warmer leads.
About this workflow
LEAD ACQUISITION APOLLO APIFY. Uses stickyNote, httpRequest, chatTrigger, noOp. Chat trigger; 15 nodes.
Source: https://github.com/lucky14426/ai-outreach-automation-platform/blob/main/workflows/01-lead-acquisition/lead-acquisition-apollo-apify.json — 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.
Who’s it for Creators who want to create faceless videos automatically, while keeping human oversight and quality control.
The Best Linkedin Posting System. Uses httpRequest, lmChatOpenAi, agent, chatTrigger. Chat trigger; 49 nodes.
Who is this workflow for? This workflow is designed for SEO analysts, content creators, marketing agencies, and developers who need to index a website and then interact with its content as if it were
This project is an automation workflow that generates a personalized resume and cover letter for each job listing. Generates an HTML resume from your data. Hosts it live on GitHub Pages. Converts it t
Are you tired of manually sifting through hundreds of LinkedIn profiles to find the right talent? Say goodbye to inefficient recruiting processes and embrace the power of AI-driven candidate selection