Bright Data APIとGoogle Sheets連携のGoogle Mapsビジネス電話番号スクレイパー
上級
これはSales分野の自動化ワークフローで、16個のノードを含みます。主にIf, Wait, FormTrigger, HttpRequest, GoogleSheetsなどのノードを使用。 Bright Data APIを利用したGoogle Maps電話番号スクレイピングとGoogle Sheetsとの同期
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "Hm7iTSgpu2of6gz4",
"meta": {
"instanceId": "bc8ca75c203589705ae2e446cad7181d6f2a7cc1766f958ef9f34810e53b8cb2",
"templateCredsSetupCompleted": true
},
"name": "Google Maps Business Phone Number Scraper Using Bright Data API & Google Sheets Integration",
"tags": [],
"nodes": [
{
"id": "e5b879b7-5f3c-4679-95e4-6c32eae86080",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1340,
20
],
"parameters": {
"width": 220,
"height": 220,
"content": "📝 Trigger - Start when form is submitted\n"
},
"typeVersion": 1
},
{
"id": "703d65f1-bbc7-437a-8a82-a35b6ac04504",
"name": "フォームトリガー - 場所とキーワードを送信",
"type": "n8n-nodes-base.formTrigger",
"position": [
-1280,
80
],
"webhookId": "8b72dcdf-25a1-4b63-bb44-f918f7095d5d",
"parameters": {
"options": {},
"formTitle": "GMB",
"formFields": {
"values": [
{
"fieldLabel": "Location",
"requiredField": true
},
{
"fieldLabel": "keywords",
"requiredField": true
}
]
}
},
"typeVersion": 2.2
},
{
"id": "1b5f22d3-c271-4d80-bc40-9b701a668c40",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1080,
20
],
"parameters": {
"color": 3,
"width": 220,
"height": 220,
"content": "Sends scraping request to Bright Data API"
},
"typeVersion": 1
},
{
"id": "61dc6463-12db-453c-a732-dc0d924dc469",
"name": "Bright Data API - ビジネスデータをリクエスト",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1020,
80
],
"parameters": {
"url": "https://api.brightdata.com/datasets/v3/trigger",
"method": "POST",
"options": {},
"jsonBody": "={\n \"input\": [\n {\n \"country\": \"{{ $json.Location }}\",\n \"keyword\": \"{{ $json.keywords }}\",\n \"lat\": \"\"\n }\n ],\n \"custom_output_fields\": [\n \n \"url\",\n \"country\",\n \"name\",\n \n \"address\",\n \"description\",\n \n \"open_hours\",\n \"reviews_count\",\n \"rating\",\n \n \"reviews\",\n \"services_provided\",\n \n \"open_website\",\n \"phone_number\",\n \"permanently_closed\",\n \"photos_and_videos\",\n \"people_also_search\"\n \n ]\n} ",
"sendBody": true,
"sendQuery": true,
"sendHeaders": true,
"specifyBody": "json",
"queryParameters": {
"parameters": [
{
"name": "dataset_id",
"value": "gd_m8ebnr0q2qlklc02fz"
},
{
"name": "include_errors",
"value": "true"
},
{
"name": "type",
"value": "discover_new"
},
{
"name": "discover_by",
"value": "location"
},
{
"name": "limit_per_input",
"value": "2"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer BRIGHT_DATA_API_KEY"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "aae71edd-22bc-4bb9-a950-1c82aef6a30b",
"name": "スクレイピングステータスを確認",
"type": "n8n-nodes-base.httpRequest",
"position": [
-780,
80
],
"parameters": {
"url": "=https://api.brightdata.com/datasets/v3/progress/{{ $json.snapshot_id }}",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "format",
"value": "json"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer BRIGHT_DATA_API_KEY"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "6370948d-f408-4cf8-8d3c-0c2db3665cae",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-840,
0
],
"parameters": {
"color": 4,
"width": 220,
"height": 260,
"content": "⏳ Check Status - Is data scraping completed?\n"
},
"typeVersion": 1
},
{
"id": "1c016ecd-97db-4638-919f-2cc7136b2384",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-600,
0
],
"parameters": {
"color": 5,
"width": 200,
"height": 260,
"content": "✅ Is Ready? - If ready, continue; if not, wait"
},
"typeVersion": 1
},
{
"id": "67931cf3-a2c5-42e0-86b7-2b1611175037",
"name": "ステータスが準備完了か確認",
"type": "n8n-nodes-base.if",
"position": [
-560,
80
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "35ed620d-b5d5-4e97-bcc5-52b283d85616",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "ready"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "9e089ddb-2cd2-4988-b070-a400d9a464e3",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-380,
240
],
"parameters": {
"color": 7,
"height": 240,
"content": "⏱️ Wait - Pause 1 min before checking again\n"
},
"typeVersion": 1
},
{
"id": "594732d2-7a44-4b20-9cf6-81314933a857",
"name": "再試行前に待機",
"type": "n8n-nodes-base.wait",
"position": [
-320,
300
],
"webhookId": "7047efad-de41-4608-b95c-d3e0203ef620",
"parameters": {
"unit": "minutes",
"amount": 1
},
"typeVersion": 1.1
},
{
"id": "34770c87-d63b-4bf8-a7e7-34fb579bd716",
"name": "レコードが存在するか確認",
"type": "n8n-nodes-base.if",
"position": [
-280,
60
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f01bd215-c406-493c-a6e4-2b8ec5686b44",
"operator": {
"type": "number",
"operation": "notEquals"
},
"leftValue": "={{ $json.records }}",
"rightValue": "={{ 0 }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "0119bde3-66e8-44f2-8991-dc4b9e02962e",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-360,
-20
],
"parameters": {
"color": 4,
"width": 260,
"height": 240,
"content": "📊 Has Data? - Proceed only if business records found\n"
},
"typeVersion": 1
},
{
"id": "1cd6681e-47e5-4e82-8e12-408e299b9503",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-40
],
"parameters": {
"color": 5,
"width": 220,
"height": 260,
"content": "📥 Fetch Data - Get business info including phone numbers\n"
},
"typeVersion": 1
},
{
"id": "135b9224-bcd2-4790-9066-278985874a3a",
"name": "ビジネスデータを取得",
"type": "n8n-nodes-base.httpRequest",
"position": [
-20,
40
],
"parameters": {
"url": "=https://api.brightdata.com/datasets/v3/snapshot/{{ $json.snapshot_id }}",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "format",
"value": "json"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer BRIGHT_DATA_API_KEY"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "141e0fdc-56d7-42f4-92d4-93cda1ffe7e2",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
-40
],
"parameters": {
"color": 6,
"width": 280,
"height": 260,
"content": "Saves business data to the GMB sheet in your Google Sheet📄 Save to Sheet - Store business name, number, URL, etc.\n\n\t"
},
"typeVersion": 1
},
{
"id": "3a0e1f5b-d923-47a0-b036-c18ac260980a",
"name": "Google Sheetsに保存",
"type": "n8n-nodes-base.googleSheets",
"position": [
260,
40
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $json.url }}",
"Name": "={{ $json.name }}",
"Rating": "={{ $json.rating }}",
"Address": "={{ $json.address }}",
"Phone Number": "={{ $json.phone_number }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Rating",
"type": "string",
"display": true,
"required": false,
"displayName": "Rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone Number",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Address",
"type": "string",
"display": true,
"required": false,
"displayName": "Address",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 619305781,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit#gid=619305781",
"cachedResultName": "GMB"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEET_ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_ID/edit?usp=drivesdk",
"cachedResultName": "Business Data Sheet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "YOUR_GOOGLE_SHEETS_CREDENTIAL_ID",
"name": "Google Sheets OAuth2"
}
},
"typeVersion": 4.6
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "0bed9bf1-00a3-4eb6-bf7c-cf07bee006a2",
"connections": {
"594732d2-7a44-4b20-9cf6-81314933a857": {
"main": [
[
{
"node": "aae71edd-22bc-4bb9-a950-1c82aef6a30b",
"type": "main",
"index": 0
}
]
]
},
"34770c87-d63b-4bf8-a7e7-34fb579bd716": {
"main": [
[
{
"node": "135b9224-bcd2-4790-9066-278985874a3a",
"type": "main",
"index": 0
}
]
]
},
"135b9224-bcd2-4790-9066-278985874a3a": {
"main": [
[
{
"node": "3a0e1f5b-d923-47a0-b036-c18ac260980a",
"type": "main",
"index": 0
}
]
]
},
"67931cf3-a2c5-42e0-86b7-2b1611175037": {
"main": [
[
{
"node": "34770c87-d63b-4bf8-a7e7-34fb579bd716",
"type": "main",
"index": 0
}
],
[
{
"node": "594732d2-7a44-4b20-9cf6-81314933a857",
"type": "main",
"index": 0
}
]
]
},
"aae71edd-22bc-4bb9-a950-1c82aef6a30b": {
"main": [
[
{
"node": "67931cf3-a2c5-42e0-86b7-2b1611175037",
"type": "main",
"index": 0
}
]
]
},
"61dc6463-12db-453c-a732-dc0d924dc469": {
"main": [
[
{
"node": "aae71edd-22bc-4bb9-a950-1c82aef6a30b",
"type": "main",
"index": 0
}
]
]
},
"703d65f1-bbc7-437a-8a82-a35b6ac04504": {
"main": [
[
{
"node": "61dc6463-12db-453c-a732-dc0d924dc469",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 営業
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
リード generationワークフロー：YelpおよびTrustpilotのクローリングにBrightDataを使用し、OpenAIで分析を実施
Yelp と Trustpilot からスクレイビング + AI 駆動のメールアウトレーチでリードを生成します
If
Code
Wait
+
If
Code
Wait
32 ノードIncrementors
営業
財務インサイトの自動化：市值を Bright Data 経由で Telegram に送信
Bright Dataを使ってYahoo Financeから時価総額データを取得し、Telegramで可視化する
If
Code
Wait
+
If
Code
Wait
14 ノードIncrementors
仮想通貨取引
Bright DataとTelegram通知を統合したGoogle Playレビューインテリジェントシステム
Bright DataとTelegram通知を利用したGoogle Playレビューのスマート分析システム
If
Wait
Telegram
+
If
Wait
Telegram
18 ノードIncrementors
人工知能
LinkedInとIndeed求人スクレイパー（Bright Data経由）とGoogleエクスポート
LinkedIn、Indeed、Bright Data、Googleスプレッドシートを使用した求人情報スクレイピング
If
Code
Wait
+
If
Code
Wait
33 ノードIncrementors
人事
Google My Business リード抽出
Bright Dataを使用してGoogle My Businessからサービス別または場所別のリードを抽出
If
Code
Wait
+
If
Code
Wait
23 ノードDvir Sharon
営業
Bright Data と GPT を使用して Glassdoor をスクレイピングし、高意向の Sales Leads を発見
Bright DataとGPTを使用してGlassdoorから高意向のセールスリードをスクレイピング
If
Wait
Split Out
+
If
Wait
Split Out
16 ノードYaron Been
営業
