8
n8n Françaisamn8n.com

Outil de capture de numéros de téléphone d'entreprises Google Maps avec l'API Bright Data et l'intégration Google Sheets

Avancé

Ceci est unSalesworkflow d'automatisation du domainecontenant 16 nœuds.Utilise principalement des nœuds comme If, Wait, FormTrigger, HttpRequest, GoogleSheets. Extracteur de numéros de téléphone Google Maps, synchronisé avec Google Sheets via l'API Bright Data

Prérequis
  • •Peut nécessiter les informations d'identification d'authentification de l'API cible
  • •Informations d'identification Google Sheets API

Nœuds utilisés (16)

If
Wait
StickyNote
FormTrigger
HttpRequest
GoogleSheets

Catégorie

Ventes
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
React Flow
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "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": "Note adhésive",
      "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": "Déclencheur de Formulaire - Soumettre Localisation et Mots-clés",
      "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": "Note adhésive1",
      "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 - Demander des Données d'Entreprise",
      "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": "Vérifier l'État du Scraping",
      "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": "Note adhésive2",
      "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": "Note adhésive3",
      "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": "Vérifier si l'État est Prêt",
      "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": "Note adhésive4",
      "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": "Attente avant Nouvelle Tentative",
      "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": "Vérifier l'Existence des Enregistrements",
      "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": "Note adhésive5",
      "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": "Note adhésive6",
      "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": "Récupérer les Données d'Entreprise",
      "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": "Note adhésive7",
      "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": "Enregistrer dans 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
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Avancé - Ventes

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Workflows recommandés

Workflow de prospects : scraping Yelp et Trustpilot avec BrightData + analyse avec OpenAI
Générer des prospects via le scraping Yelp/Trustpilot + email outreach piloté par l'IA
If
Code
Wait
+
If
Code
Wait
32 NœudsIncrementors
Ventes
Automatisation des insights financiers : envoi de la capitalisation boursière vers Telegram avec Bright Data
Extraire les données de capitalisation boursaire de Yahoo Finance avec Bright Data et visualiser sur Telegram
If
Code
Wait
+
If
Code
Wait
14 NœudsIncrementors
Trading crypto
Système intelligent de gestion des avis Google Play avec intégration Bright Data et alertes Telegram
Système d'analyse intelligente des avis Google Play avec Bright Data et notifications Telegram
If
Wait
Telegram
+
If
Wait
Telegram
18 NœudsIncrementors
Intelligence Artificielle
LinkedIn and Indeed job scraper (via Bright Data) with Google Sheets export
Recherche de postes avec LinkedIn, Indeed, Bright Data et Google Sheets
If
Code
Wait
+
If
Code
Wait
33 NœudsIncrementors
Ressources Humaines
Extraction de prospects Google My Business
Extraire des prospects à partir de Google My Business par service ou emplacement avec Bright Data
If
Code
Wait
+
If
Code
Wait
23 NœudsDvir Sharon
Ventes
Extraction de Glassdoor pour découvrir des prospects à fort intérêt d'achat avec Bright Data et GPT
via Bright Data et GPT 抓取 Glassdoor 发现高意向ventes线索
If
Wait
Split Out
+
If
Wait
Split Out
16 NœudsYaron Been
Ventes
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds16
Catégorie1
Types de nœuds6
Description de la difficulté

Adapté aux utilisateurs avancés, avec des workflows complexes contenant 16+ nœuds

Auteur
Incrementors

Incrementors

@incrementors
Liens externes
Voir sur n8n.io →

Partager ce workflow

Catégories

IA Multimodale
1540
Intelligence Artificielle
1108
Création de contenu
695
Résumé IA
516
Marketing
419
Chatbot IA
251
Ingénierie
241
Étude de marché
203
Divers
193
Autres
176
Ventes
162
Opérations IT
156
Extraction de documents
147
RAG IA
146
Blocs de construction
144
Réseaux sociaux
137
Génération de leads
125
Productivité personnelle
117
DevOps
111
Ressources Humaines
101
Support
97
Nurturing de leads
87
CRM
82
Finance
81
Produit
77
Chatbot de support
76
Design
70
Gestion des tickets
67
Opérations de sécurité
57
Traitement des factures
53
Trading crypto
49
Gestion de fichiers
39
Gestion de projet
35
Wiki interne
32

Catégories: 34