Automate LinkedIn lead generation and CRM updates using a Google Sheets API integration. This workflow captures leads from LinkedIn and organizes them in Google Sheets, ensuring your data management is seamless and efficient. Features real-time data syncing, automated lead tracking, and customizable webhook triggers for instant updates. Perfect for sales teams managing over 50 leads daily, this setup simplifies your outreach process. Requires 1 account: Google Sheets OAuth. Save up to 10 hours weekly in manual data entry and ensure no lead goes unnoticed.
Categories
APIs
Credentials
Copy or download to import into your n8n instance
{
"id": "jHlW6EeIz7q0yHDz",
"meta": {
"instanceId": "2000c64071c20843606b95c63795bb0797c41036047055a6586498e855b96efc",
"templateCredsSetupCompleted": true
},
"name": "LinkedIn Lead Generation & CRM Automation Suite\"",
"tags": [],
"nodes": [
{
"id": "26a238e9-b805-4674-820f-64132ff33f79",
"name": "Business Value",
"type": "n8n-nodes-base.stickyNote",
"position": [
-360,
1440
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7e8c240e-4a6a-47e6-961a-c45f923c3cc9",
"name": "Manual Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1140,
860
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9b026a34-106a-4b72-9dd6-402cc2b3b05a",
"name": "Check New Entries",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1360,
1220
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "8d7d7453-2621-4105-b357-e4b4b3530765",
"name": "Webhook Input",
"type": "n8n-nodes-base.webhook",
"position": [
-1100,
1540
],
"webhookId": "linkedin-webhook-001",
"parameters": {},
"typeVersion": 2
},
{
"id": "b4a3c8b1-3617-41ea-a94e-0e48067db770",
"name": "Read LinkedIn URLs",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1100,
1240
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "201e6e1a-00cd-4c6b-9d09-fa2da5797290",
"name": "Process All Input Sources",
"type": "n8n-nodes-base.code",
"position": [
-880,
1240
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3d9df020-b876-430e-bb9b-1f4982a2dbb0",
"name": "Format Input Data",
"type": "n8n-nodes-base.set",
"position": [
-660,
1240
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "60c84381-ab57-4e6c-80ad-093c77eef974",
"name": "Check Batch Processing",
"type": "n8n-nodes-base.if",
"position": [
-440,
1240
],
"parameters": {},
"typeVersion": 2
},
{
"id": "bac9f1a2-7775-467c-8ad1-83776d1b0b93",
"name": "Split Batch URLs",
"type": "n8n-nodes-base.code",
"position": [
-220,
1140
],
"parameters": {},
"typeVersion": 2
},
{
"id": "1403d5b0-838d-4264-824e-42a1ddef459a",
"name": "Scrape LinkedIn Profile",
"type": "n8n-nodes-base.httpRequest",
"position": [
880,
1240
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "fa658e28-880d-496c-bc06-ba9516e0367b",
"name": "Process Profile Data",
"type": "n8n-nodes-base.code",
"position": [
0,
1240
],
"parameters": {},
"typeVersion": 2
},
{
"id": "98ef8e4e-b5cb-4950-8a0e-ec5eaf24d327",
"name": "Route to Google Sheets",
"type": "n8n-nodes-base.if",
"position": [
220,
1240
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7bf1211a-0b8a-493d-a5ef-f055ff07efb3",
"name": "Add to Google Sheets CRM",
"type": "n8n-nodes-base.googleSheets",
"position": [
440,
1240
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "e11a188a-c937-4f13-85fe-a740bb68f319",
"name": "Respond Success",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
660,
1240
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "faea4a79-1f1e-4a95-b8d3-e11405bd1a5d",
"name": "Workflow Info",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1800,
1040
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e5e5355f-0436-4817-a38a-9840001b7523",
"name": "Features & Config",
"type": "n8n-nodes-base.stickyNote",
"position": [
-260,
900
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "cbc9b209-8272-49f6-a50e-3220fc64bfd1",
"name": "Scoring Logic",
"type": "n8n-nodes-base.stickyNote",
"position": [
-780,
920
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "cac41cb8-f27e-4ad8-afa0-3c3958af9c5d",
"name": "Usage Examples",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
500
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "fc97854c-5b5e-4ad3-9ab0-eb2db2354fc6",
"connections": {
"Webhook Input": {
"main": [
[
{
"node": "Process All Input Sources",
"type": "main",
"index": 0
}
]
]
},
"Manual Trigger": {
"main": [
[
{
"node": "Process All Input Sources",
"type": "main",
"index": 0
}
]
]
},
"Split Batch URLs": {
"main": [
[
{
"node": "Scrape LinkedIn Profile",
"type": "main",
"index": 0
}
]
]
},
"Check New Entries": {
"main": [
[
{
"node": "Read LinkedIn URLs",
"type": "main",
"index": 0
}
]
]
},
"Format Input Data": {
"main": [
[
{
"node": "Check Batch Processing",
"type": "main",
"index": 0
}
]
]
},
"Read LinkedIn URLs": {
"main": [
[
{
"node": "Process All Input Sources",
"type": "main",
"index": 0
}
]
]
},
"Process Profile Data": {
"main": [
[
{
"node": "Route to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Check Batch Processing": {
"main": [
[
{
"node": "Split Batch URLs",
"type": "main",
"index": 0
}
],
[
{
"node": "Scrape LinkedIn Profile",
"type": "main",
"index": 0
}
]
]
},
"Route to Google Sheets": {
"main": [
[
{
"node": "Add to Google Sheets CRM",
"type": "main",
"index": 0
}
]
]
},
"Scrape LinkedIn Profile": {
"main": [
[
{
"node": "Process Profile Data",
"type": "main",
"index": 0
}
]
]
},
"Add to Google Sheets CRM": {
"main": [
[
{
"node": "Respond Success",
"type": "main",
"index": 0
}
]
]
},
"Process All Input Sources": {
"main": [
[
{
"node": "Format Input Data",
"type": "main",
"index": 0
}
]
]
}
}
}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.
Automate lead generation by extracting business data from Google Maps directly into Google Sheets using the Google Sheets API. This workflow eliminates manual data entry, allowing you to focus on engaging potential customers. Features include real-time data integration, automated updates from Google Maps, and seamless execution of data processing steps. Perfect for data management teams needing to compile lists of local businesses or sales teams targeting specific geographic areas. Requires 1 account: Google Sheets OAuth. Save up to 10 hours weekly by automating the collection of thousands of leads effortlessly.
Automate data management tasks using OpenAI GPT and Google Sheets API for efficient data extraction and processing. This workflow enables you to automatically extract relevant information from HTML sources and consolidate it into Google Sheets, simplifying your data organization. Key features include real-time data extraction, seamless HTML parsing, and automated entry into spreadsheets. Perfect for data analysts or teams managing large datasets that require constant updates. Requires 2 accounts: OpenAI API Key and Google Sheets OAuth. Save up to 10 hours weekly by automating data entry and retrieval, ensuring your team has accurate information at their fingertips.
Streamline data management tasks by automating data entry and processing with Google Sheets API and OpenAI's GPT. This workflow allows you to intelligently manage your data through automated inputs and real-time updates, ensuring accuracy and efficiency. Key features include seamless integration with Google Sheets for instant data syncing, AI-powered data parsing for structured outputs, and automated response generation for queries. Ideal for data analysts and project managers handling large datasets or repetitive tasks. Requires 3 accounts: OpenAI API, Serp API, Google Sheets OAuth. Experience a 70% reduction in manual data handling time and improve accuracy by 90% with automated processes.
Configure credentials and update service-specific settings before executing the workflow. Review required credentials in the Technical Details section above.