LinkedInからのリーダーミネラブル潰の取り込みとデータ豊富化コピー
上級
これはSales, AI, Marketing分野の自動化ワークフローで、53個のノードを含みます。主にIf, Set, Code, SplitOut, FormTriggerなどのノードを使用、AI技術を活用したスマート自動化を実現。 Apollo.io、LinkedIn API、Mail.so、GPT-3.5を使ってLinkedInの潜在顧客を生成し、豊富にする
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
- •OpenAI API Key
使用ノード (53)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "7wwY8wfZdNpL83QQ",
"meta": {
"instanceId": "b3c467df4053d13fe31cc98f3c66fa1d16300ba750506bfd019a0913cec71ea3",
"templateCredsSetupCompleted": true
},
"name": "LinkedIn Leads Scraping & Enrichment copy",
"tags": [],
"nodes": [
{
"id": "5d07dfa4-6e6a-41a6-a2ea-8a8787331735",
"name": "フォーム送信時",
"type": "n8n-nodes-base.formTrigger",
"position": [
-80,
-80
],
"webhookId": "28ff6927-5d05-4182-910b-be2381e3b2c4",
"parameters": {
"options": {},
"formTitle": "Leads Search",
"formFields": {
"values": [
{
"fieldLabel": "Job Title",
"requiredField": true
},
{
"fieldLabel": "Location",
"requiredField": true
},
{
"fieldType": "number",
"fieldLabel": "Number of Leads",
"requiredField": true
}
]
}
},
"typeVersion": 2.2
},
{
"id": "76ade63a-7b44-4fd1-85d8-6dbacd83aca7",
"name": "分割",
"type": "n8n-nodes-base.splitOut",
"position": [
360,
-80
],
"parameters": {
"options": {},
"fieldToSplitOut": "people"
},
"typeVersion": 1,
"alwaysOutputData": false
},
{
"id": "3c7b7179-a8b9-41d6-9617-8eb7af38f571",
"name": "Google シートトリガー",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-100,
280
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads & enrichment"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "DKYpQQpUt3ceJiG4",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "9a55977c-638f-49ae-a51f-420f71c15454",
"name": "OpenAI1",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
360,
280
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-3.5-turbo",
"cachedResultName": "GPT-3.5-TURBO"
},
"options": {},
"messages": {
"values": [
{
"content": "=remove the http or https://www.linkedin.com/in/ from this {{ $json.linkedin_url }}"
}
]
}
},
"credentials": {
"openAiApi": {
"id": "DO9F6MAeTGLeqgoF",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "ca4d6b69-d4cb-4aa1-89bc-f0b5555f31cd",
"name": "Google シートトリガー2",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-100,
680
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "DKYpQQpUt3ceJiG4",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "15422703-fa1f-42e4-8387-7d2d4f154938",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
200
],
"parameters": {
"color": 3,
"width": 1260,
"height": 300,
"content": "## Extract Linkedin Username \n"
},
"typeVersion": 1
},
{
"id": "f8ffe414-9ca9-463a-9b98-22a65a86d4c4",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
-160
],
"parameters": {
"width": 1260,
"height": 300,
"content": "## Scrape Leads from Apollo\n"
},
"typeVersion": 1
},
{
"id": "a09d3993-99d6-488e-8bc0-76542de7b53c",
"name": "データクレンジング",
"type": "n8n-nodes-base.set",
"position": [
600,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "e3bfe30e-9136-4ac9-b3da-c26eb678153b",
"name": "id",
"type": "string",
"value": "={{ $json.id }}"
},
{
"id": "d45c81fb-1461-45fd-be95-d5d9901d72d7",
"name": "name",
"type": "string",
"value": "={{ $json.name }}"
},
{
"id": "b4b8f660-7758-4a5f-a8f6-dc8ab6355132",
"name": "linkedin_url",
"type": "string",
"value": "={{ $json.linkedin_url }}"
},
{
"id": "399f533a-6e6b-4f40-8ed8-aa5dd39017cd",
"name": "title",
"type": "string",
"value": "={{ $json.title }}"
},
{
"id": "227d34c5-17db-4436-b0c2-f74e5ae453f2",
"name": "organization",
"type": "string",
"value": "={{ $json.employment_history[0].organization_name }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "92d03853-644e-4c73-8ecf-1e216238b37f",
"name": "リードをGoogleシートに追加",
"type": "n8n-nodes-base.googleSheets",
"position": [
840,
-80
],
"parameters": {
"columns": {
"value": {
"name": "={{ $json.name }}",
"title": "={{ $json.title }}",
"apollo_id": "={{ $json.id }}",
"linkedin_url": "={{ $json.linkedin_url }}",
"organization": "={{ $json.organization }}",
"posts_scrape_status": "unscraped",
"contacts_scrape_status": "pending",
"profile_summary_scrape": "pending",
"extract_username_status": "pending"
},
"schema": [
{
"id": "apollo_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "apollo_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "organization",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "organization",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_username",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "extract_username_status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "extract_username_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contacts_scrape_status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "contacts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about_linkedin_profile",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "about_linkedin_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "profile_summary_scrape",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "profile_summary_scrape",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recent_posts_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "recent_posts_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "posts_scrape_status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "posts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads & enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"typeVersion": 4.5
},
{
"id": "0275f8ba-78d7-4464-bc80-ee939e9575e7",
"name": "Linkedin ユーザー名追加",
"type": "n8n-nodes-base.googleSheets",
"position": [
720,
280
],
"parameters": {
"columns": {
"value": {
"apollo_id": "={{ $('Get Pending Username Row').item.json.apollo_id }}",
"linkedin_username": "={{ $json.message.content }}",
"extract_username_status": "finished"
},
"schema": [
{
"id": "apollo_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "apollo_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_username",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkedin_username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "extract_username_status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "extract_username_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone_number",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "phone_number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contacts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "contacts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about_linkedin_profile",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "about_linkedin_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "profile_summary_scrape",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "profile_summary_scrape",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recent_posts_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "recent_posts_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "posts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "posts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"apollo_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"typeVersion": 4.5
},
{
"id": "42827be7-8727-46e6-8f12-5d517c3ce6f3",
"name": "保留中のユーザー名行を取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
280
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupValue": "pending",
"lookupColumn": "extract_username_status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads & enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "ffbb16a6-020e-4825-9690-3e89a8bbbbf7",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
560
],
"parameters": {
"color": 5,
"width": 1700,
"height": 360,
"content": "## Get Email Address, Validate Deliverability & Update Column Status"
},
"typeVersion": 1
},
{
"id": "d2a1b54a-bc1b-4f63-a1a4-b9bd2017f82d",
"name": "メールアドレス追加",
"type": "n8n-nodes-base.googleSheets",
"position": [
1240,
600
],
"parameters": {
"columns": {
"value": {
"apollo_id": "={{ $('Get Pending Email Statuses').item.json.apollo_id }}",
"email_address": "={{ $json.data.email }}",
"contacts_scrape_status": "finished"
},
"schema": [
{
"id": "apollo_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "apollo_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_username",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "extract_username_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "extract_username_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contacts_scrape_status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "contacts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about_linkedin_profile",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "about_linkedin_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "profile_summary_scrape",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "profile_summary_scrape",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recent_posts_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "recent_posts_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "posts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "posts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"apollo_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "a3d99675-db2e-4af7-8410-e1cda8e571a5",
"name": "条件分岐",
"type": "n8n-nodes-base.if",
"position": [
880,
680
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "dd16c397-c6f6-4a91-b92c-24a1f24b707f",
"operator": {
"type": "string",
"operation": "notContains"
},
"leftValue": "={{ $json.data.mx_record }}",
"rightValue": "null"
},
{
"id": "bc3200af-7ae4-4944-b410-ebb459e2d927",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.data.result }}",
"rightValue": "deliverable"
}
]
},
"looseTypeValidation": true
},
"typeVersion": 2.2
},
{
"id": "7abbce6e-90fa-4ac5-9a0b-0ba2669aa77a",
"name": "無効メールをマーク",
"type": "n8n-nodes-base.googleSheets",
"position": [
1240,
760
],
"parameters": {
"columns": {
"value": {
"apollo_id": "={{ $('Get Pending Email Statuses').item.json.apollo_id }}",
"contacts_scrape_status": "invalid_email"
},
"schema": [
{
"id": "apollo_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "apollo_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_username",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "extract_username_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "extract_username_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contacts_scrape_status",
"type": "string",
"display": true,
"required": false,
"displayName": "contacts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about_linkedin_profile",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "about_linkedin_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "profile_summary_scrape",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "profile_summary_scrape",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recent_posts_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "recent_posts_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "posts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "posts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"apollo_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads & enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"typeVersion": 4.5
},
{
"id": "2e1b9e78-8953-4059-9bbd-117c78742e4b",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1560,
560
],
"parameters": {
"color": 5,
"width": 800,
"height": 360,
"content": "## Update Contact Scrape Status from Invalid back to Pending"
},
"typeVersion": 1
},
{
"id": "dc603dc3-148c-4609-a698-eaae32832423",
"name": "スケジュールトリガー",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
1640,
680
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks",
"triggerAtDay": [
2
],
"triggerAtHour": 8,
"weeksInterval": 4
}
]
}
},
"typeVersion": 1.2
},
{
"id": "a23feccf-f6b5-4440-b12a-ea10b41f4037",
"name": "Apolloからメールを取得",
"type": "n8n-nodes-base.httpRequest",
"position": [
380,
680
],
"parameters": {
"url": "https://api.apollo.io/api/v1/people/match",
"method": "POST",
"options": {},
"sendBody": true,
"sendQuery": true,
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "id",
"value": "={{ $json.apollo_id }}"
}
]
},
"queryParameters": {
"parameters": [
{
"name": "reveal_personal_emails",
"value": "true"
},
{
"name": "reveal_phone_number",
"value": "false"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Cache-Control",
"value": "no-cache"
},
{
"name": "accept",
"value": "application/json"
},
{
"name": "x-api-key",
"value": "\"your_api_key\""
}
]
}
},
"typeVersion": 4.2
},
{
"id": "dfd5224d-fdb6-41f2-a219-a4a8f94930cd",
"name": "メール有効性確認",
"type": "n8n-nodes-base.httpRequest",
"position": [
620,
680
],
"parameters": {
"url": "=https://api.mails.so/v1/validate?email={{ $json.person.email }}",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "x-mails-api-key",
"value": "\"your_api_key\""
},
{
"name": "x-rapidapi-key",
"value": "f46d60a773msh289f42a6505aaf6p15aafdjsne9d81b12086d"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "14fab17d-b38b-43de-a38e-c8d49afcf1d0",
"name": "保留中のメールステータスを取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
680
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupValue": "pending",
"lookupColumn": "contacts_scrape_status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "09a0c5eb-d098-47f1-a85c-13c93d8b5296",
"name": "Google シートトリガー3",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-100,
1160
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "DKYpQQpUt3ceJiG4",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "3f592a9c-f692-44c0-b5be-9c5ff1506f24",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
1040
],
"parameters": {
"color": 6,
"width": 1920,
"height": 360,
"content": "## Get Profile Summary & Update Status"
},
"typeVersion": 1
},
{
"id": "6bc025b4-b150-493b-ae38-33772cb51a76",
"name": "プロフィール投稿を取得",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"maxTries": 2,
"position": [
340,
1640
],
"parameters": {
"url": "https://linkedin-data-api.p.rapidapi.com/get-profile-posts",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "username",
"value": "={{ $json.linkedin_username }}"
},
{
"name": "start",
"value": "0"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "linkedin-data-api.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "\"your_api_key\""
}
]
}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "758da5bf-91e9-434d-9de5-eb3e907524e1",
"name": "プロフィール概要を取得",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"maxTries": 2,
"position": [
380,
1160
],
"parameters": {
"url": "https://linkedin-data-api.p.rapidapi.com",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "username",
"value": "={{ $json.linkedin_username }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "linkedin-data-api.p.rapidapi.com"
},
{
"name": "x-rapidapi-key",
"value": "\"your_api_key\""
}
]
}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "9f88649f-3c41-4624-b94f-242d94118b0b",
"name": "保留中の概要と投稿行を取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
1160
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupValue": "pending",
"lookupColumn": "profile_summary_scrape"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "2e8bb4a1-5fa9-446a-8b55-bffd6ceb5648",
"name": "プロフィールデータクレンジング",
"type": "n8n-nodes-base.code",
"onError": "continueErrorOutput",
"maxTries": 2,
"position": [
620,
1160
],
"parameters": {
"jsCode": "return [{\n summary: $input.first().json.summary,\n headline: $input.first().json.headline,\n nationality: $input.first().json.geo.country,\n languaage: $input.first().json.languages[0].name,\n education: $input.first().json.educations[0].schoolName,\n fieldOfStudy: $input.first().json.educations[0].fieldOfStudy,\n employment_company: $input.first().json.position[0].companyName,\n company_industry: $input.first().json.position[0].companyIndustry,\n position: $input.first().json.position[0].title,\n company_location: $input.first().json.position[0].location,\n employment_description_1: $input.first().json.position[0].description,\n}];\n"
},
"retryOnFail": true,
"typeVersion": 2
},
{
"id": "87aa2108-44df-4b7f-8090-f2e86cbf5bf9",
"name": "Google シートトリガー4",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-120,
1640
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "DKYpQQpUt3ceJiG4",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "e3318dd3-4b6a-4994-92bc-2e715f398397",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
1520
],
"parameters": {
"color": 7,
"width": 1920,
"height": 360,
"content": "## Get Summary of Latest Linkedin Profile Posts"
},
"typeVersion": 1
},
{
"id": "b1c117e8-493a-443f-912b-dbf4718c3348",
"name": "保留中の概要と投稿行を取得1",
"type": "n8n-nodes-base.googleSheets",
"position": [
100,
1640
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupValue": "unscraped",
"lookupColumn": "posts_scrape_status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "c480f3ed-f316-4dd8-877b-49191d5aa694",
"name": "投稿データクレンジング",
"type": "n8n-nodes-base.code",
"onError": "continueErrorOutput",
"maxTries": 2,
"position": [
580,
1640
],
"parameters": {
"jsCode": "const data = $input.first().json.data || [];\n\nfunction getText(post, reshared = false) {\n if (!post) return \"\";\n return reshared ? (post.resharedPost?.text || \"\") : (post.text || \"\");\n}\n\nfunction getDate(post) {\n if (!post) return \"\";\n return post.postedDate || post.postedDateTimestamp || \"\";\n}\n\nreturn [{\n json: {\n post_1: getText(data[0]),\n post_1_date: getDate(data[0]),\n\n post_2: getText(data[1]),\n post_2_date: getDate(data[1]),\n\n post_3: getText(data[2]),\n post_3_date: getDate(data[2]),\n\n post_4: getText(data[3], true),\n post_4_date: getDate(data[3]),\n\n post_5: getText(data[4], true),\n post_5_date: getDate(data[4]),\n }\n}];\n"
},
"retryOnFail": true,
"typeVersion": 2,
"waitBetweenTries": 3000
},
{
"id": "88d093e7-0180-4585-b338-11f4974fa0a7",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
1980
],
"parameters": {
"color": 4,
"width": 800,
"height": 360,
"content": "## Update Completely Enriched Profile to Final Database"
},
"typeVersion": 1
},
{
"id": "a9a96a05-f135-4a19-827f-85a750bc1551",
"name": "Google シートトリガー5",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-120,
2100
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "DKYpQQpUt3ceJiG4",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "ef709a3f-7e75-4904-9d3e-299db8db5d60",
"name": "付箋8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1780,
1040
],
"parameters": {
"color": 6,
"width": 800,
"height": 360,
"content": "## Update profile summary status from failed back to pending"
},
"typeVersion": 1
},
{
"id": "91a1eaed-8645-4eeb-8558-c28a6d55f689",
"name": "スケジュールトリガー2",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
1860,
1160
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks",
"triggerAtDay": [
2
],
"triggerAtHour": 8,
"weeksInterval": 4
}
]
}
},
"typeVersion": 1.2
},
{
"id": "f7658227-39b3-4efb-971c-f17860d20fb8",
"name": "無効メール行を取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
1880,
680
],
"parameters": {
"options": {
"returnFirstMatch": false
},
"filtersUI": {
"values": [
{
"lookupValue": "invalid_email",
"lookupColumn": "contacts_scrape_status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "fce87e8a-9eb3-4c86-a4e3-f93534333206",
"name": "保留中に更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
2100,
680
],
"parameters": {
"columns": {
"value": {
"apollo_id": "={{ $json.apollo_id }}",
"contacts_scrape_status": "pending"
},
"schema": [
{
"id": "apollo_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "apollo_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_username",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "extract_username_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "extract_username_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contacts_scrape_status",
"type": "string",
"display": true,
"required": false,
"displayName": "contacts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about_linkedin_profile",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "about_linkedin_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "profile_summary_scrape",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "profile_summary_scrape",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recent_posts_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "recent_posts_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "posts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "posts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"apollo_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads & enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"typeVersion": 4.5
},
{
"id": "9583cab2-6373-4e44-b9f2-ba0e8c8871e7",
"name": "失敗したプロフィール概要行を取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
2100,
1160
],
"parameters": {
"options": {
"returnFirstMatch": false
},
"filtersUI": {
"values": [
{
"lookupValue": "failed",
"lookupColumn": "profile_summary_scrape"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "a09d1560-2213-46ff-9668-5e98d5051e1f",
"name": "保留中に更新1",
"type": "n8n-nodes-base.googleSheets",
"position": [
2320,
1160
],
"parameters": {
"columns": {
"value": {
"apollo_id": "={{ $json.apollo_id }}",
"profile_summary_scrape": "pending"
},
"schema": [
{
"id": "apollo_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "apollo_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_username",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "extract_username_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "extract_username_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contacts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "contacts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about_linkedin_profile",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "about_linkedin_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "profile_summary_scrape",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "profile_summary_scrape",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recent_posts_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "recent_posts_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "posts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "posts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"apollo_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads & enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"typeVersion": 4.5
},
{
"id": "809d74c0-bb21-4651-bf52-ccb7e8fac5a6",
"name": "付箋9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1760,
1520
],
"parameters": {
"color": 7,
"width": 800,
"height": 360,
"content": "## Update posts summary status from failed back to pending"
},
"typeVersion": 1
},
{
"id": "ee1a5073-87a9-4395-9c79-b56165a5325d",
"name": "スケジュールトリガー3",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
1840,
1640
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks",
"triggerAtDay": [
2
],
"triggerAtHour": 8,
"weeksInterval": 4
}
]
}
},
"typeVersion": 1.2
},
{
"id": "4a89e593-adb3-4999-bb0a-cf8cc751a76a",
"name": "失敗した投稿概要行を取得1",
"type": "n8n-nodes-base.googleSheets",
"position": [
2080,
1640
],
"parameters": {
"options": {
"returnFirstMatch": false
},
"filtersUI": {
"values": [
{
"lookupValue": "failed",
"lookupColumn": "posts_scrape_status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "369715fe-67c5-41f1-9070-af5063f80fe0",
"name": "投稿AI要約",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1060,
1560
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-3.5-turbo",
"cachedResultName": "GPT-3.5-TURBO"
},
"options": {},
"messages": {
"values": [
{
"content": "=Below are the most recent posts and reposts from a LinkedIn user. Summarize them collectively in no more than two short paragraphs. Focus on capturing the main themes, tone, and any recurring interests or professional concerns.\n\nAvoid listing each post separately — instead, synthesize the information into a narrative that gives a clear idea of what this person is currently focused on or passionate about.\n\nPosts: {{ $json.postsString }}\n\nKeep it insightful but brief — no more than 2 concise paragraphs."
}
]
},
"simplify": false
},
"credentials": {
"openAiApi": {
"id": "DO9F6MAeTGLeqgoF",
"name": "OpenAi account"
}
},
"executeOnce": true,
"typeVersion": 1.8
},
{
"id": "a571b341-1a4b-42d7-a4fc-5dd8333e3dab",
"name": "AIプロフィール要約",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
1100,
1080
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-3.5-turbo",
"cachedResultName": "GPT-3.5-TURBO"
},
"options": {},
"messages": {
"values": [
{
"content": "=Please summarize the following linkedin profile data {{ $json.profileString }} for a lead I want to cold email. I want to combine this summary with another information about them to send personalied emails, so please make sure you include relevant bits in the summary"
}
]
},
"simplify": false
},
"credentials": {
"openAiApi": {
"id": "DO9F6MAeTGLeqgoF",
"name": "OpenAi account"
}
},
"executeOnce": true,
"typeVersion": 1.8
},
{
"id": "8a81b29d-0ffa-4418-9aec-21eb94df7d26",
"name": "プロフィール概要を更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
1500,
1080
],
"parameters": {
"columns": {
"value": {
"apollo_id": "={{ $('Get Pending About and Posts Rows').item.json.apollo_id }}",
"about_linkedin_profile": "={{ $json.choices[0].message.content }}",
"profile_summary_scrape": "completed"
},
"schema": [
{
"id": "apollo_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "apollo_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_username",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "extract_username_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "extract_username_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contacts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "contacts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about_linkedin_profile",
"type": "string",
"display": true,
"required": false,
"displayName": "about_linkedin_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "profile_summary_scrape",
"type": "string",
"display": true,
"required": false,
"displayName": "profile_summary_scrape",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recent_posts_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "recent_posts_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "posts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "posts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"apollo_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads & enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"typeVersion": 4.5
},
{
"id": "4803c443-be3c-4578-90fc-ab78403a0913",
"name": "投稿概要を更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
1440,
1560
],
"parameters": {
"columns": {
"value": {
"apollo_id": "={{ $('Get Pending About and Posts Rows1').item.json.apollo_id }}",
"posts_scrape_status": "scraped",
"recent_posts_summary": "={{ $json.choices[0].message.content }}"
},
"schema": [
{
"id": "apollo_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "apollo_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "organization",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "organization",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_username",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "extract_username_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "extract_username_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contacts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "contacts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about_linkedin_profile",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "about_linkedin_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "profile_summary_scrape",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "profile_summary_scrape",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recent_posts_summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "recent_posts_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "posts_scrape_status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "posts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"apollo_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads & enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"typeVersion": 4.5
},
{
"id": "ccf8b76d-1aba-4c5a-b19e-30aac3ab682a",
"name": "完全にエンリッチされたプロフィールを取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
120,
2100
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupValue": "finished",
"lookupColumn": "contacts_scrape_status"
},
{
"lookupValue": "completed",
"lookupColumn": "profile_summary_scrape"
},
{
"lookupValue": "scraped",
"lookupColumn": "posts_scrape_status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"executeOnce": true,
"typeVersion": 4.5
},
{
"id": "bfe41bd1-3edc-456a-9bf4-8e88009060e4",
"name": "未スクレイピングに更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
2300,
1640
],
"parameters": {
"columns": {
"value": {
"apollo_id": "={{ $json.apollo_id }}",
"posts_scrape_status": "unscraped"
},
"schema": [
{
"id": "apollo_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "apollo_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_username",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "extract_username_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "extract_username_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contacts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "contacts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about_linkedin_profile",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "about_linkedin_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "profile_summary_scrape",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "profile_summary_scrape",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recent_posts_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "recent_posts_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "posts_scrape_status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "posts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"apollo_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads & enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"typeVersion": 4.5
},
{
"id": "0d6e42a6-8b7e-493e-b920-7cb4d3994151",
"name": "エンリッチ済みリードDBに追加",
"type": "n8n-nodes-base.googleSheets",
"position": [
340,
2100
],
"parameters": {
"columns": {
"value": {
"Position": "={{ $json.title }}",
"Lead Name": "={{ $json.name }}",
"Email Address": "={{ $json.email_address }}",
"Company/Organization": "={{ $json.organization }}",
"Recent Posts Summary": "={{ $json.recent_posts_summary }}",
"Linkedin Profile Summary": "={{ $json.about_linkedin_profile }}"
},
"schema": [
{
"id": "Lead Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Lead Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company/Organization",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company/Organization",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Position",
"type": "string",
"display": true,
"required": false,
"displayName": "Position",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Linkedin Profile Summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Linkedin Profile Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Recent Posts Summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Recent Posts Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email Address"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1c5USULUPS-2_RdNf29cyDguuHH7A7JNwzFCjQQUJTvE/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1c5USULUPS-2_RdNf29cyDguuHH7A7JNwzFCjQQUJTvE",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1c5USULUPS-2_RdNf29cyDguuHH7A7JNwzFCjQQUJTvE/edit?usp=drivesdk",
"cachedResultName": "Enriched Leads Database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"typeVersion": 4.5
},
{
"id": "dfc1a7e4-6348-4a84-b6b9-d9f53184948e",
"name": "ステータスを失敗に更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
880,
1240
],
"parameters": {
"columns": {
"value": {
"apollo_id": "={{ $('Get Pending About and Posts Rows').item.json.apollo_id }}",
"profile_summary_scrape": "failed"
},
"schema": [
{
"id": "apollo_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "apollo_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "organization",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "organization",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_username",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "extract_username_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "extract_username_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contacts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "contacts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about_linkedin_profile",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "about_linkedin_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "profile_summary_scrape",
"type": "string",
"display": true,
"required": false,
"displayName": "profile_summary_scrape",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recent_posts_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "recent_posts_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "posts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "posts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"apollo_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads & enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"typeVersion": 4.5
},
{
"id": "a14fce10-9a03-4005-b440-f2bb5e4c4eed",
"name": "Google シート",
"type": "n8n-nodes-base.googleSheets",
"position": [
840,
1720
],
"parameters": {
"columns": {
"value": {
"apollo_id": "={{ $('Get Pending About and Posts Rows1').item.json.apollo_id }}",
"posts_scrape_status": "failed"
},
"schema": [
{
"id": "apollo_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "apollo_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "organization",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "organization",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_username",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "linkedin_username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "extract_username_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "extract_username_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contacts_scrape_status",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "contacts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about_linkedin_profile",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "about_linkedin_profile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "profile_summary_scrape",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "profile_summary_scrape",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recent_posts_summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "recent_posts_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "posts_scrape_status",
"type": "string",
"display": true,
"required": false,
"displayName": "posts_scrape_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"apollo_id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d99PlHkp9RPeSAtmATgQ4OC4Selcp8JSFLNuKx-n1EQ/edit?usp=drivesdk",
"cachedResultName": "apollo ai leads & enrichment"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "d0qeLhShx9sGXalR",
"name": "Google Sheets"
}
},
"typeVersion": 4.5
},
{
"id": "77a48254-5972-4a41-90e9-3903219e78cc",
"name": "プロフィールデータ文字列化1",
"type": "n8n-nodes-base.code",
"position": [
880,
1080
],
"parameters": {
"jsCode": "const profile = items[0].json;\n\nreturn [{\n json: {\n profileString: JSON.stringify(profile, null, 2) // Pretty print with 2-space indentation\n }\n}];"
},
"typeVersion": 2
},
{
"id": "fb8cf143-7a62-4fdc-8888-b60841354352",
"name": "投稿データ文字列化",
"type": "n8n-nodes-base.code",
"position": [
840,
1560
],
"parameters": {
"jsCode": "const profile = items[0].json;\n\nreturn [{\n json: {\n postsString: JSON.stringify(profile, null, 2) // Pretty print with 2-space indentation\n }\n}];"
},
"typeVersion": 2
},
{
"id": "c440d713-3371-41a5-9093-8084ecb0eabd",
"name": "Apollo.ioでリード生成",
"type": "n8n-nodes-base.httpRequest",
"position": [
140,
-80
],
"parameters": {
"url": "https://api.apollo.io/api/v1/mixed_people/search",
"method": "POST",
"options": {
"response": {
"response": {}
}
},
"jsonBody": "={\n \"person_locations\": [\"{{ $json.Location }}\"],\n \"person_titles\": [\"{{ $json['Job Title'] }}\"],\n \"page\": 1,\n \"per_page\": {{$json['Number of Leads']}},\n \"projection\": [\"id\", \"name\", \"linkedin_url\", \"title\"]\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "Cache-Control",
"value": "no-cache"
},
{
"name": "accept",
"value": "application/json"
},
{
"name": "x-api-key",
"value": "\"your_api_key\""
}
]
}
},
"typeVersion": 4.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "bc5a9e4b-3b0a-4b5e-8ba1-fd1909933059",
"connections": {
"a3d99675-db2e-4af7-8410-e1cda8e571a5": {
"main": [
[
{
"node": "d2a1b54a-bc1b-4f63-a1a4-b9bd2017f82d",
"type": "main",
"index": 0
}
],
[
{
"node": "7abbce6e-90fa-4ac5-9a0b-0ba2669aa77a",
"type": "main",
"index": 0
}
]
]
},
"9a55977c-638f-49ae-a51f-420f71c15454": {
"main": [
[
{
"node": "0275f8ba-78d7-4464-bc80-ee939e9575e7",
"type": "main",
"index": 0
}
]
]
},
"76ade63a-7b44-4fd1-85d8-6dbacd83aca7": {
"main": [
[
{
"node": "a09d3993-99d6-488e-8bc0-76542de7b53c",
"type": "main",
"index": 0
}
]
]
},
"a09d3993-99d6-488e-8bc0-76542de7b53c": {
"main": [
[
{
"node": "92d03853-644e-4c73-8ecf-1e216238b37f",
"type": "main",
"index": 0
}
]
]
},
"c480f3ed-f316-4dd8-877b-49191d5aa694": {
"main": [
[
{
"node": "fb8cf143-7a62-4fdc-8888-b60841354352",
"type": "main",
"index": 0
}
],
[
{
"node": "a14fce10-9a03-4005-b440-f2bb5e4c4eed",
"type": "main",
"index": 0
}
]
]
},
"dc603dc3-148c-4609-a698-eaae32832423": {
"main": [
[
{
"node": "f7658227-39b3-4efb-971c-f17860d20fb8",
"type": "main",
"index": 0
}
]
]
},
"758da5bf-91e9-434d-9de5-eb3e907524e1": {
"main": [
[
{
"node": "2e8bb4a1-5fa9-446a-8b55-bffd6ceb5648",
"type": "main",
"index": 0
}
]
]
},
"6bc025b4-b150-493b-ae38-33772cb51a76": {
"main": [
[
{
"node": "c480f3ed-f316-4dd8-877b-49191d5aa694",
"type": "main",
"index": 0
}
]
]
},
"91a1eaed-8645-4eeb-8558-c28a6d55f689": {
"main": [
[
{
"node": "9583cab2-6373-4e44-b9f2-ba0e8c8871e7",
"type": "main",
"index": 0
}
]
]
},
"ee1a5073-87a9-4395-9c79-b56165a5325d": {
"main": [
[
{
"node": "4a89e593-adb3-4999-bb0a-cf8cc751a76a",
"type": "main",
"index": 0
}
]
]
},
"fce87e8a-9eb3-4c86-a4e3-f93534333206": {
"main": [
[]
]
},
"2e8bb4a1-5fa9-446a-8b55-bffd6ceb5648": {
"main": [
[
{
"node": "77a48254-5972-4a41-90e9-3903219e78cc",
"type": "main",
"index": 0
}
],
[
{
"node": "dfc1a7e4-6348-4a84-b6b9-d9f53184948e",
"type": "main",
"index": 0
}
]
]
},
"5d07dfa4-6e6a-41a6-a2ea-8a8787331735": {
"main": [
[
{
"node": "c440d713-3371-41a5-9093-8084ecb0eabd",
"type": "main",
"index": 0
}
]
]
},
"369715fe-67c5-41f1-9070-af5063f80fe0": {
"main": [
[
{
"node": "4803c443-be3c-4578-90fc-ab78403a0913",
"type": "main",
"index": 0
}
]
]
},
"fb8cf143-7a62-4fdc-8888-b60841354352": {
"main": [
[
{
"node": "369715fe-67c5-41f1-9070-af5063f80fe0",
"type": "main",
"index": 0
}
]
]
},
"a571b341-1a4b-42d7-a4fc-5dd8333e3dab": {
"main": [
[
{
"node": "8a81b29d-0ffa-4418-9aec-21eb94df7d26",
"type": "main",
"index": 0
}
]
]
},
"a23feccf-f6b5-4440-b12a-ea10b41f4037": {
"main": [
[
{
"node": "dfd5224d-fdb6-41f2-a219-a4a8f94930cd",
"type": "main",
"index": 0
}
]
]
},
"3c7b7179-a8b9-41d6-9617-8eb7af38f571": {
"main": [
[
{
"node": "42827be7-8727-46e6-8f12-5d517c3ce6f3",
"type": "main",
"index": 0
}
]
]
},
"dfd5224d-fdb6-41f2-a219-a4a8f94930cd": {
"main": [
[
{
"node": "a3d99675-db2e-4af7-8410-e1cda8e571a5",
"type": "main",
"index": 0
}
]
]
},
"ca4d6b69-d4cb-4aa1-89bc-f0b5555f31cd": {
"main": [
[
{
"node": "14fab17d-b38b-43de-a38e-c8d49afcf1d0",
"type": "main",
"index": 0
}
]
]
},
"09a0c5eb-d098-47f1-a85c-13c93d8b5296": {
"main": [
[
{
"node": "9f88649f-3c41-4624-b94f-242d94118b0b",
"type": "main",
"index": 0
}
]
]
},
"87aa2108-44df-4b7f-8090-f2e86cbf5bf9": {
"main": [
[
{
"node": "b1c117e8-493a-443f-912b-dbf4718c3348",
"type": "main",
"index": 0
}
]
]
},
"a9a96a05-f135-4a19-827f-85a750bc1551": {
"main": [
[
{
"node": "ccf8b76d-1aba-4c5a-b19e-30aac3ab682a",
"type": "main",
"index": 0
}
]
]
},
"f7658227-39b3-4efb-971c-f17860d20fb8": {
"main": [
[
{
"node": "fce87e8a-9eb3-4c86-a4e3-f93534333206",
"type": "main",
"index": 0
}
]
]
},
"77a48254-5972-4a41-90e9-3903219e78cc": {
"main": [
[
{
"node": "a571b341-1a4b-42d7-a4fc-5dd8333e3dab",
"type": "main",
"index": 0
}
]
]
},
"42827be7-8727-46e6-8f12-5d517c3ce6f3": {
"main": [
[
{
"node": "9a55977c-638f-49ae-a51f-420f71c15454",
"type": "main",
"index": 0
}
]
]
},
"14fab17d-b38b-43de-a38e-c8d49afcf1d0": {
"main": [
[
{
"node": "a23feccf-f6b5-4440-b12a-ea10b41f4037",
"type": "main",
"index": 0
}
]
]
},
"c440d713-3371-41a5-9093-8084ecb0eabd": {
"main": [
[
{
"node": "76ade63a-7b44-4fd1-85d8-6dbacd83aca7",
"type": "main",
"index": 0
}
]
]
},
"4a89e593-adb3-4999-bb0a-cf8cc751a76a": {
"main": [
[
{
"node": "bfe41bd1-3edc-456a-9bf4-8e88009060e4",
"type": "main",
"index": 0
}
]
]
},
"9583cab2-6373-4e44-b9f2-ba0e8c8871e7": {
"main": [
[
{
"node": "a09d1560-2213-46ff-9668-5e98d5051e1f",
"type": "main",
"index": 0
}
]
]
},
"ccf8b76d-1aba-4c5a-b19e-30aac3ab682a": {
"main": [
[
{
"node": "0d6e42a6-8b7e-493e-b920-7cb4d3994151",
"type": "main",
"index": 0
}
]
]
},
"9f88649f-3c41-4624-b94f-242d94118b0b": {
"main": [
[
{
"node": "758da5bf-91e9-434d-9de5-eb3e907524e1",
"type": "main",
"index": 0
}
]
]
},
"b1c117e8-493a-443f-912b-dbf4718c3348": {
"main": [
[
{
"node": "6bc025b4-b150-493b-ae38-33772cb51a76",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 営業, 人工知能, マーケティング
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
ニュースレター管理 (n8n + Bolt.new)
求人情報ニュースレター自動化システム (N8N, Bolt.new, RapidAPI, Mails.so & ChatGPT)
If
Code
Gmail
+
If
Code
Gmail
43 ノードJoseph
人工知能
私のワークフロー5
AIメールパーソナライゼーションを使用した自動LinkedInリード生成（未完了）
If
Set
Code
+
If
Set
Code
37 ノードMatthieu
営業
再生リスト詳細設定ボットコピー
Suno、GPT-4、Runway、Creatomate を使って AI 生成の YouTube ミュージックプレイリストを作成
If
Set
Code
+
If
Set
Code
203 ノードJoseph
コンテンツ作成
LinkedIn自動接続とセールス向けパーソナライズドメッセージ
LinkedIn：自動接続と販売パーソナライズドメッセージ
If
Set
Wait
+
If
Set
Wait
32 ノードVansh Arora
営業
[テンプレート] AIペットショップ v8
AIペットショップアシスタント - GPT-4o、Googleカレンダー、WhatsApp/Instagram/Facebookを統合
If
N8n
Set
+
If
N8n
Set
244 ノードAmanda Benks
営業
AI不動産エージェント：エンドツーエンド運用自動化（Web、データ、音声）
AI不動産エージェント：エンドツーエンド運用自動化（Web、データ、音声）
If
Set
Code
+
If
Set
Code
45 ノードSam Yassine
営業
ワークフロー情報
難易度
上級
ノード数53
カテゴリー3
ノードタイプ11
作成者
Joseph
@mjombaAutomation expert specializing in building smart, scalable workflows using tools like n8n, Make, and Airtable. I help businesses save time, reduce manual work, and grow faster with tailored automation solutions. Feel free to reach out at joseph@uppfy.com to discuss your project.
外部リンク
n8n.ioで表示 →
このワークフローを共有