Streamline lead data collection from Leadfeeder and Apollo.io into Google Sheets with automated workflows. This integration utilizes the Google Sheets API to effortlessly gather and organize lead information while sending real-time updates via the Telegram Bot API. Features include batch processing for efficient data handling, scheduled triggers for timely updates, and seamless API integration for instant access to your data. Perfect for sales teams managing large volumes of leads or data analysts seeking accurate insights. Requires 2 accounts: Google Sheets OAuth and Telegram Bot Token. Save up to 10 hours weekly and ensure no lead slips through the cracks with automated data collection.
Categories
APIs
Credentials
Copy or download to import into your n8n instance
{
"id": "cFNi1b3jO3XvSvAn",
"meta": {
"instanceId": "c2650793f644091dc80fb900fe63448ad1f4b774008de9608064d67294f8307c",
"templateCredsSetupCompleted": true
},
"name": "Automate leadfeeder and Apollo.io data collection",
"tags": [],
"nodes": [
{
"id": "a2faf2da-24c3-4972-994d-9dabe6feb7a6",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e4218112-f685-4ade-8265-365cf01382f7",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
512
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7ffd56d9-f27d-41e3-95d4-6b3a55bcc1da",
"name": "Daily Trigger (9 AM)",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
112,
288
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "7515cbdd-ef25-45dd-9118-5d8b9eef2569",
"name": "Fetch Leadfeeder Account ID",
"type": "n8n-nodes-base.httpRequest",
"position": [
352,
288
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "3a901947-6a9d-4240-b8e3-80a0e603618b",
"name": "Generate Pagination Sequence",
"type": "n8n-nodes-base.code",
"position": [
576,
288
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4657e075-050e-4e99-a214-dbb30b5f2221",
"name": "Pagination Controller",
"type": "n8n-nodes-base.splitInBatches",
"position": [
800,
288
],
"parameters": {},
"typeVersion": 3
},
{
"id": "15f367cc-6031-4440-a13d-952cbc09e245",
"name": "Assign Current Page Number",
"type": "n8n-nodes-base.set",
"position": [
1024,
208
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "86fc67c9-12e5-4dfa-9b63-d49f9059d4e8",
"name": "Retrieve Lead Data (Leadfeeder)",
"type": "n8n-nodes-base.httpRequest",
"position": [
1248,
208
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "7db9202f-9978-4716-9016-7cf2056b3f07",
"name": "Check Last Page Condition",
"type": "n8n-nodes-base.if",
"position": [
1472,
208
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "aebd0481-ac90-4494-bff9-e8d11fc17a30",
"name": "Extract Leads (Last Page)",
"type": "n8n-nodes-base.splitOut",
"position": [
1696,
96
],
"parameters": {},
"typeVersion": 1
},
{
"id": "230f4943-0fbd-4cde-a22c-f60123b65f74",
"name": "Enrich with Apollo (Last Page)",
"type": "n8n-nodes-base.httpRequest",
"position": [
1920,
96
],
"parameters": {},
"executeOnce": false,
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "791cd99d-59d4-4746-bec5-e59cffe11b28",
"name": "Save Leads to Google Sheets (Last Page)",
"type": "n8n-nodes-base.googleSheets",
"position": [
2144,
96
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "26c5e81a-027a-4466-ba34-ce3580d958ba",
"name": "Extract Leads (Full Page)",
"type": "n8n-nodes-base.splitOut",
"position": [
1696,
304
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e7f593b8-edb3-4aa4-86d3-3f553457a3ff",
"name": "Enrich with Apollo (Full Page)",
"type": "n8n-nodes-base.httpRequest",
"position": [
1920,
304
],
"parameters": {},
"executeOnce": false,
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "78ccfdc1-8bd7-4425-b270-4322c248d9c5",
"name": "Save Leads to Google Sheets (Full Page)",
"type": "n8n-nodes-base.googleSheets",
"position": [
2144,
304
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "aba38dd5-79eb-41c5-8dda-111fa923ef82",
"name": "Rate Limit Delay (40s)",
"type": "n8n-nodes-base.wait",
"position": [
2368,
384
],
"webhookId": "f63348ce-885c-4ba0-bfa2-c14872449c1f",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "9bbd30ee-e365-4e11-a462-8efc1eba2ccb",
"name": "Workflow Error Listener",
"type": "n8n-nodes-base.errorTrigger",
"position": [
64,
608
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2fabef88-4742-4f4d-9cb6-85fabd53fc16",
"name": "Format Error Report",
"type": "n8n-nodes-base.code",
"position": [
288,
608
],
"parameters": {},
"typeVersion": 2
},
{
"id": "6237a74a-7f4b-4277-9e8c-a2b6c964dc31",
"name": "Send Alert to Telegram",
"type": "n8n-nodes-base.telegram",
"position": [
496,
608
],
"webhookId": "13c616bf-a3ad-4035-998a-1dfe6021b89f",
"parameters": {},
"typeVersion": 1
},
{
"id": "149e66d0-8679-41d9-958e-b9c6ecf210ec",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
736,
656
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d34dba88-59a0-4efd-83b3-7148579daa86",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1264,
656
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c9bdf4b3-e4fc-4e56-8e98-eedd2e0951dd",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1728,
656
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0db97b64-7a09-4bfe-a473-80e6429a7e5e",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2192,
656
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "58cc5a2a-d253-43ad-b657-058ed893f2f4",
"connections": {
"Format Error Report": {
"main": [
[
{
"node": "Send Alert to Telegram",
"type": "main",
"index": 0
}
]
]
},
"Daily Trigger (9 AM)": {
"main": [
[
{
"node": "Fetch Leadfeeder Account ID",
"type": "main",
"index": 0
}
]
]
},
"Pagination Controller": {
"main": [
[],
[
{
"node": "Assign Current Page Number",
"type": "main",
"index": 0
}
]
]
},
"Rate Limit Delay (40s)": {
"main": [
[
{
"node": "Pagination Controller",
"type": "main",
"index": 0
}
]
]
},
"Workflow Error Listener": {
"main": [
[
{
"node": "Format Error Report",
"type": "main",
"index": 0
}
]
]
},
"Check Last Page Condition": {
"main": [
[
{
"node": "Extract Leads (Last Page)",
"type": "main",
"index": 0
}
],
[
{
"node": "Extract Leads (Full Page)",
"type": "main",
"index": 0
}
]
]
},
"Extract Leads (Full Page)": {
"main": [
[
{
"node": "Enrich with Apollo (Full Page)",
"type": "main",
"index": 0
}
]
]
},
"Extract Leads (Last Page)": {
"main": [
[
{
"node": "Enrich with Apollo (Last Page)",
"type": "main",
"index": 0
}
]
]
},
"Assign Current Page Number": {
"main": [
[
{
"node": "Retrieve Lead Data (Leadfeeder)",
"type": "main",
"index": 0
}
]
]
},
"Fetch Leadfeeder Account ID": {
"main": [
[
{
"node": "Generate Pagination Sequence",
"type": "main",
"index": 0
}
]
]
},
"Generate Pagination Sequence": {
"main": [
[
{
"node": "Pagination Controller",
"type": "main",
"index": 0
}
]
]
},
"Enrich with Apollo (Full Page)": {
"main": [
[
{
"node": "Save Leads to Google Sheets (Full Page)",
"type": "main",
"index": 0
}
]
]
},
"Enrich with Apollo (Last Page)": {
"main": [
[
{
"node": "Save Leads to Google Sheets (Last Page)",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Lead Data (Leadfeeder)": {
"main": [
[
{
"node": "Check Last Page Condition",
"type": "main",
"index": 0
}
]
]
},
"Save Leads to Google Sheets (Full Page)": {
"main": [
[
{
"node": "Rate Limit Delay (40s)",
"type": "main",
"index": 0
}
]
]
}
}
}Streamline your social media content strategy with an automated workflow using Google Gemini and OpenAI GPT. This solution allows social media managers to generate, schedule, and publish posts across Facebook, Instagram, and LinkedIn seamlessly, saving hours of manual work each week. Features real-time content generation, intelligent scheduling, and integration with Facebook Graph API and Twitter API for effective outreach. Perfect for social media managers handling multiple accounts and needing consistent, engaging content for their audience. Requires 9 accounts: Google Palm API, OpenAI API, Facebook Graph API, and more. Experience up to 70% faster content creation and manage over 30 posts daily with AI-driven insights.
Automate the generation of AI videos for TikTok, YouTube, and Instagram using the Google Sheets API and OpenAI GPT. Leverage structured data from Google Sheets to create engaging video content effortlessly. Features seamless integration with multiple platforms, automatic content generation, and real-time video uploads. Perfect for digital marketers, content creators, and social media managers looking to enhance their video production workflow. Requires 3 accounts: Google Sheets OAuth, OpenAI API, and Blotato API. Save up to 10 hours weekly by automating video creation and uploads, allowing you to focus on strategy and engagement.
Automate your video creation process using Google Sheets and OpenAI GPT to generate content, then seamlessly upload videos to YouTube via the Google Drive API. This workflow simplifies the video production cycle from concept to publication. Features include real-time content generation with GPT, automated scheduling for uploads, and integration with Google Sheets for data management. Perfect for content creators managing multiple video projects or marketing teams needing consistent video output. Requires 3 accounts: Google Sheets OAuth, Google Drive OAuth, OpenAI API Key. Save up to 10 hours weekly by automating video creation and uploads, enabling you to focus on strategy and engagement.
Streamline your data collection by automating email scraping from Google Maps using the Google Sheets API. This workflow efficiently extracts business emails, removes duplicates, and organizes them in real-time for easy access. Key features include batch processing to handle large datasets, HTTP requests for seamless API integration, and built-in filters to refine your data. Ideal for data managers or marketers needing accurate contact lists from local businesses. Requires 1 account: Google Sheets OAuth. Save up to 10 hours weekly by automating email collection and maintaining up-to-date contact information effortlessly.
Configure credentials and update service-specific settings before executing the workflow. Review required credentials in the Technical Details section above.