ZoomInfo、Serper、Oxylabs を使って Google Sheets への企業データ enrichment 自動化

上級

これはLead Generation分野の自動化ワークフローで、19個のノードを含みます。主にIf, Code, Html, Wait, HttpRequestなどのノードを使用。 ZoomInfo、Serper、OxylabsからGoogle Sheetsへ公司データ豊富化の自動化

前提条件
  • ターゲットAPIの認証情報が必要な場合あり
  • Google Sheets API認証情報

カテゴリー

ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
  "meta": {
    "instanceId": "aff7017841e089b12fdff439d182db1ce6e6151977703d9243f6be0543724481",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "6e9e0196-34b7-42ef-9cea-0ee2f29126d9",
      "name": "手動トリガー",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -864,
        464
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f89efbed-6317-4875-9e70-829a9a4634ba",
      "name": "未処理ドメインの読み込み",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -640,
        464
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupColumn": "processed"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 2062802377,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY/edit#gid=2062802377",
          "cachedResultName": "ZoomInfoData"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY/edit?usp=drivesdk",
          "cachedResultName": "Get Addresses"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Y43YNvASDhLxJg65",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "b38d94e0-1fc5-4f44-8a4d-e2c363f94c44",
      "name": "各ドメインの処理",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -416,
        464
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "240a748e-f3d7-47cd-b97e-6d1a31c366c1",
      "name": "Serper経由でのZoomInfo検索",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -192,
        176
      ],
      "parameters": {
        "url": "https://google.serper.dev/search",
        "method": "POST",
        "options": {
          "redirect": {
            "redirect": {}
          }
        },
        "sendBody": true,
        "authentication": "genericCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "q",
              "value": "=where is \"{{ $json.domain }}\" Czech Republic headquarter? site:zoominfo.com"
            }
          ]
        },
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "3ff4n7dWTTnGg27S",
          "name": "[Serper/Sophia] Header Auth account"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "538ae1c4-e301-4ad1-9be8-0ab40b371068",
      "name": "検索結果の確認",
      "type": "n8n-nodes-base.if",
      "position": [
        32,
        176
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "f5f8619e-e07d-4cb7-9369-48a2882e4d35",
              "operator": {
                "type": "array",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.organic }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "2d392b3b-0886-49a9-a69e-d0b2f455c613",
      "name": "ドメインとZoomInfo URLの抽出",
      "type": "n8n-nodes-base.code",
      "position": [
        256,
        80
      ],
      "parameters": {
        "jsCode": "const text = $input.first().json.organic[0].snippet;\nconst regex = /(https?:\\/\\/(?:www\\.|(?!www))[a-zA-Z0-9][a-zA-Z0-9-]+[a-zA-Z0-9]\\.[^\\s]{2,}|www\\.[a-zA-Z0-9][a-zA-Z0-9-]+[a-zA-Z0-9]\\.[^\\s]{2,}|https?:\\/\\/[a-zA-Z0-9]\\.[^\\s]{2,})(?<![\\\\.\\\\,])/g;\nconst matches = text.match(regex) || [];\n\nreturn matches.map(url => ({\n  json: {\n    url,\n    link: $input.first().json.organic[0].link\n  }\n})); "
      },
      "typeVersion": 2,
      "alwaysOutputData": true
    },
    {
      "id": "dd4bb8af-1d6f-414f-badd-93d6a4dc7202",
      "name": "ドメインマッチングの検証",
      "type": "n8n-nodes-base.if",
      "position": [
        480,
        80
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "58571e85-2aa7-4383-953f-0135c985e27d",
              "operator": {
                "type": "string",
                "operation": "contains"
              },
              "leftValue": "={{ $json.url }}",
              "rightValue": "={{ $('Process Each Domain').item.json.domain }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "41618147-b735-4a30-83d8-2a8a5f813fc4",
      "name": "ZoomInfoページのスクレイピング",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        704,
        80
      ],
      "parameters": {
        "url": "https://realtime.oxylabs.io/v1/queries",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "authentication": "genericCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "source",
              "value": "universal"
            },
            {
              "name": "url",
              "value": "={{ $json.link }}"
            }
          ]
        },
        "genericAuthType": "httpBasicAuth"
      },
      "credentials": {
        "httpBasicAuth": {
          "id": "UJNOFcA65c1OotBi",
          "name": "[Naveen] Oxylabs"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "bd7c4539-0f42-4b66-adb8-efd64638866e",
      "name": "企業データの抽出",
      "type": "n8n-nodes-base.html",
      "position": [
        928,
        80
      ],
      "parameters": {
        "options": {
          "trimValues": true,
          "cleanUpText": true
        },
        "operation": "extractHtmlContent",
        "dataPropertyName": "results[0].content",
        "extractionValues": {
          "values": [
            {
              "key": "company_info",
              "cssSelector": "#ng-state"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "94931e87-9169-48f8-805d-118167195043",
      "name": "JSON 企業情報の解析",
      "type": "n8n-nodes-base.code",
      "onError": "continueRegularOutput",
      "position": [
        1152,
        80
      ],
      "parameters": {
        "jsCode": "\nreturn JSON.parse($input.first().json.company_info).pageData;"
      },
      "typeVersion": 2
    },
    {
      "id": "c5c398e4-7476-4636-913c-8489f0612af3",
      "name": "企業詳細の保存",
      "type": "n8n-nodes-base.googleSheets",
      "onError": "continueRegularOutput",
      "position": [
        1600,
        248
      ],
      "parameters": {
        "columns": {
          "value": {
            "city": "={{ $json.address.city }}",
            "phone": "={{ $json.about.phone.replace(\"+\", \"'+\") }}",
            "state": "={{ $json.address.state }}",
            "domain": "={{ $('Process Each Domain').item.json.domain }}",
            "address": "={{ $json.address.street }}",
            "company": "={{ $json.fullName }}",
            "country": "={{ $json.address.country }}",
            "revenue": "={{ $json.about.revenue }}",
            "industry": "={{ $json.about.industries.map(item => item.name) }}",
            "postCode": "={{ $json.address.zip }}",
            "employees": "={{ $json.numberOfEmployees }}",
            "processed": "true",
            "companyLinkedinUrl": "={{ $json.overview.socialNetworkUrls[0].socialNetworkUrl }}"
          },
          "schema": [
            {
              "id": "domain",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "domain",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "company",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "address",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "address",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "city",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "city",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "state",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "state",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "postCode",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "postCode",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "country",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "country",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "employees",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "employees",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "revenue",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "revenue",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "industry",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "industry",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "companyLinkedinUrl",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "companyLinkedinUrl",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "source_url",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "source_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "processed",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "processed",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "domain"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 2062802377,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY/edit#gid=2062802377",
          "cachedResultName": "ZoomInfoData"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY/edit?usp=drivesdk",
          "cachedResultName": "Get Addresses"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Y43YNvASDhLxJg65",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6,
      "alwaysOutputData": true
    },
    {
      "id": "4b6515e0-4b48-475a-a4e8-2bacbb4ea754",
      "name": "ドメインを処理済みとしてマーク",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        480,
        272
      ],
      "parameters": {
        "columns": {
          "value": {
            "domain": "={{ $('Process Each Domain').item.json.domain }}",
            "processed": "true"
          },
          "schema": [
            {
              "id": "domain",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "domain",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "company",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "address",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "address",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "city",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "city",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "state",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "state",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "postCode",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "postCode",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "country",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "country",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "phone",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "employees",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "employees",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "revenue",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "revenue",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "industry",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "industry",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "companyLinkedinUrl",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "companyLinkedinUrl",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "source_url",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "source_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "processed",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "processed",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "domain"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 2062802377,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY/edit#gid=2062802377",
          "cachedResultName": "ZoomInfoData"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bdK8xskt-qfLlDwdzolM0zFyo9KxZ-HHpTVxcEw3ZMY/edit?usp=drivesdk",
          "cachedResultName": "Get Addresses"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Y43YNvASDhLxJg65",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "2d0e61ec-65ee-4cee-b8c7-bc2b173f6987",
      "name": "レート制限ディレイ",
      "type": "n8n-nodes-base.wait",
      "position": [
        1376,
        80
      ],
      "webhookId": "05ac39a5-6d75-4156-8133-2bdbf1f047d6",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "16d10906-533b-4c3a-981b-7cfec0c11814",
      "name": "処理ディレイ",
      "type": "n8n-nodes-base.wait",
      "position": [
        256,
        272
      ],
      "webhookId": "57b27518-bce8-40c2-94af-42635ac335fa",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "d78a08b4-ca6b-46cd-9e42-fc6ee38c7e7d",
      "name": "付箋",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        -640
      ],
      "parameters": {
        "width": 960,
        "height": 320,
        "content": "🏢 ZOOMINFO COMPANY DATA SCRAPER\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n\n🎯 Purpose: Automatically enriches company domains with detailed business information from ZoomInfo\n\n📊 Process Flow:\n1. Loads unprocessed domains from Google Sheet\n2. Searches ZoomInfo via Serper API  \n3. Scrapes company data using Oxylabs\n4. Updates sheet with enriched information\n\n⚠️ Respects rate limits and processes domains sequentially"
      },
      "typeVersion": 1
    },
    {
      "id": "90ca76bc-4281-46a1-a978-62fd84433df3",
      "name": "付箋1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1152,
        -240
      ],
      "parameters": {
        "color": 5,
        "width": 912,
        "height": 880,
        "content": "🔧 SETUP REQUIREMENTS\n━━━━━━━━━━━━━━━━━━━━\n\n📋 Google Sheet: Update spreadsheet ID\n🔍 Serper API: Search engine credentials\n🕷️ Oxylabs: Web scraping proxy service\n\n📝 Sheet Structure Required:\n- domain column (input)\n- processed column (tracking)\n- Multiple output columns for company data\n\n🔐 All API credentials must be configured"
      },
      "typeVersion": 1
    },
    {
      "id": "8dd2282f-ec88-42ca-9f12-d86202b9adc9",
      "name": "付箋2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -224,
        -240
      ],
      "parameters": {
        "color": 4,
        "width": 864,
        "height": 880,
        "content": "🔍 SEARCH STRATEGY\n━━━━━━━━━━━━━━━━━\n\n🎯 Query Format:\n\"where is {domain} Czech Republic headquarter? site:zoominfo.com\"\n[You can update the query as per your need]\n\n✅ Success Path: Found ZoomInfo results\n❌ No Results: Mark as processed, skip to next\n\n🔄 Rate limiting prevents API abuse"
      },
      "typeVersion": 1
    },
    {
      "id": "6e11fb54-7e54-433f-9cdb-9e94616eede1",
      "name": "付箋3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        656,
        -240
      ],
      "parameters": {
        "color": 6,
        "width": 624,
        "height": 880,
        "content": "📊 DATA EXTRACTION\n━━━━━━━━━━━━━━━━━━\n\n🕷️ Oxylabs: Bypasses anti-scraping protection  \n📄 Target: #ng-state JSON data element\n🔧 Parsing: Extracts pageData from JSON\n\n📋 Extracted Fields:\n- Company name, address, phone\n- Revenue, employees, industry\n- LinkedIn URL and location details"
      },
      "typeVersion": 1
    },
    {
      "id": "4a275527-b722-47ea-99df-dde7206d080a",
      "name": "付箋4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1296,
        -240
      ],
      "parameters": {
        "color": 3,
        "width": 736,
        "height": 880,
        "content": "⚠️ ERROR HANDLING\n━━━━━━━━━━━━━━━━━━\n\n🔄 Continue on Error: Workflow won't stop\n✅ Always Mark Processed: Prevents infinite loops\n⏱️ Rate Limiting: Prevents API blocking\n\n🚨 If scraping fails:\n- Domain still marked as processed\n- Move to next domain automatically"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "6e9e0196-34b7-42ef-9cea-0ee2f29126d9": {
      "main": [
        [
          {
            "node": "f89efbed-6317-4875-9e70-829a9a4634ba",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "16d10906-533b-4c3a-981b-7cfec0c11814": {
      "main": [
        [
          {
            "node": "4b6515e0-4b48-475a-a4e8-2bacbb4ea754",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2d0e61ec-65ee-4cee-b8c7-bc2b173f6987": {
      "main": [
        [
          {
            "node": "c5c398e4-7476-4636-913c-8489f0612af3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b38d94e0-1fc5-4f44-8a4d-e2c363f94c44": {
      "main": [
        [],
        [
          {
            "node": "240a748e-f3d7-47cd-b97e-6d1a31c366c1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bd7c4539-0f42-4b66-adb8-efd64638866e": {
      "main": [
        [
          {
            "node": "94931e87-9169-48f8-805d-118167195043",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c5c398e4-7476-4636-913c-8489f0612af3": {
      "main": [
        [
          {
            "node": "b38d94e0-1fc5-4f44-8a4d-e2c363f94c44",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "41618147-b735-4a30-83d8-2a8a5f813fc4": {
      "main": [
        [
          {
            "node": "bd7c4539-0f42-4b66-adb8-efd64638866e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "94931e87-9169-48f8-805d-118167195043": {
      "main": [
        [
          {
            "node": "2d0e61ec-65ee-4cee-b8c7-bc2b173f6987",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f89efbed-6317-4875-9e70-829a9a4634ba": {
      "main": [
        [
          {
            "node": "b38d94e0-1fc5-4f44-8a4d-e2c363f94c44",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4b6515e0-4b48-475a-a4e8-2bacbb4ea754": {
      "main": [
        [
          {
            "node": "b38d94e0-1fc5-4f44-8a4d-e2c363f94c44",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "538ae1c4-e301-4ad1-9be8-0ab40b371068": {
      "main": [
        [
          {
            "node": "2d392b3b-0886-49a9-a69e-d0b2f455c613",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "16d10906-533b-4c3a-981b-7cfec0c11814",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "240a748e-f3d7-47cd-b97e-6d1a31c366c1": {
      "main": [
        [
          {
            "node": "538ae1c4-e301-4ad1-9be8-0ab40b371068",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "dd4bb8af-1d6f-414f-badd-93d6a4dc7202": {
      "main": [
        [
          {
            "node": "41618147-b735-4a30-83d8-2a8a5f813fc4",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "b38d94e0-1fc5-4f44-8a4d-e2c363f94c44",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2d392b3b-0886-49a9-a69e-d0b2f455c613": {
      "main": [
        [
          {
            "node": "dd4bb8af-1d6f-414f-badd-93d6a4dc7202",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
よくある質問

このワークフローの使い方は?

上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。

このワークフローはどんな場面に適していますか?

上級 - リード獲得

有料ですか?

このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス(OpenAI APIなど)は別途料金が発生する場合があります。

関連ワークフロー

Perplexity AIとGoogle Sheetsを使ってビジネスデータで会社ドメインを豊富にする
Perplexity AIとGoogle Sheetsを使ってビジネスデータで企業ドメインを豊富にする
Code
Http Request
Google Sheets
+
Code
Http Request
Google Sheets
9 ノードNaveen Choudhary
リード獲得
潜在顧客開掘とメールワーキングフロー
Google Maps、SendGrid、AIを使用してB2Bリード獲得とメールマーケティングを自動化
If
Set
Code
+
If
Set
Code
141 ノードEzema Kingsley Chibuzo
リード獲得
LinkedIn Sales Navigator連絡先を自動ページングでGoogle Sheetsへ抽出
自動ページングを使用してLinkedIn Sales Navigatorの連絡先をGoogle Sheetsへ抽出
If
Set
Code
+
If
Set
Code
15 ノードNaveen Choudhary
コンテンツ作成
ApifyとFirecrawlを使用してGoogle Mapsビジネスをスクレイピングし、連絡先情報を抽出
ApifyとFirecrawlを利用したGoogle Mapsビジネス情報のスクレイピングと連絡先情報の抽出
If
Code
Wait
+
If
Code
Wait
18 ノードNaveen Choudhary
営業
n8nノードの探索(可視化リファレンスライブラリ内)
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
AI駆動のGoogle Mapsビジネスデータスクレイピングとスプレッドシート出力
AIを基盤としたGoogle Mapsビジネスデータの収集、データの充実化、スプレッドシートへのエクスポートをサポート
If
Code
Wait
+
If
Code
Wait
25 ノードMsaid Mohamed el hadi
リード獲得
ワークフロー情報
難易度
上級
ノード数19
カテゴリー1
ノードタイプ9
難易度説明

上級者向け、16ノード以上の複雑なワークフロー

作成者
Naveen Choudhary

Naveen Choudhary

@n8nstein

I create AI-driven n8n workflows that turn repetitive tasks into smooth, hands-off automations. Want to explore an idea? Book a quick consult: https://cal.com/nickchoudhary/30min

外部リンク
n8n.ioで表示

このワークフローを共有

カテゴリー

カテゴリー: 34