8
n8n Françaisamn8n.com

Enrichir les pistes marketing à partir de Google Sheets

Intermédiaire

Ceci est unLead Generationworkflow d'automatisation du domainecontenant 12 nœuds.Utilise principalement des nœuds comme If, Code, Wait, Gmail, Filter. 🚀 utilisationSurfe、Google SheetsetHubSpotautomatisationLinkedIn联系人信息丰富

Prérequis
  • •Compte Google et informations d'identification Gmail API
  • •Clé API HubSpot
  • •Peut nécessiter les informations d'identification d'authentification de l'API cible
  • •Informations d'identification Google Sheets API
  • •Informations d'identification Google Drive API

Nœuds utilisés (12)

If
Code
Wait
Gmail
Filter
Hubspot
HttpRequest
GoogleSheets
SplitInBatches
GoogleDriveTrigger

Catégorie

Génération de leads
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": "GepE6tB2olhDRCxP",
  "meta": {
    "instanceId": "1c6299b01fe56ad80280bbb1a8394f761ca72a9606abe611a4617f9adc407187",
    "templateCredsSetupCompleted": true
  },
  "name": "Enrich Marketing Leads From A Google Sheet",
  "tags": [],
  "nodes": [
    {
      "id": "0796ab84-bf14-4f51-906e-db01486b2c76",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -460,
        580
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-4gGB9cugFdrutFYdlaPwMT737ODxPnizWqLODoDfmo/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.id }}"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "0cf2212f-e1f3-4616-ad6b-6c8c00bfe237",
      "name": "Google Drive Trigger",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        -760,
        580
      ],
      "parameters": {
        "event": "fileCreated",
        "options": {
          "fileType": "application/vnd.google-apps.spreadsheet"
        },
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "triggerOn": "specificFolder",
        "folderToWatch": {
          "__rl": true,
          "mode": "list",
          "value": "1C4ccbMW84VWzgGMsNTVEUUm3i_MH3Rlm",
          "cachedResultUrl": "https://drive.google.com/drive/folders/1C4ccbMW84VWzgGMsNTVEUUm3i_MH3Rlm",
          "cachedResultName": "folder-n8n-listener"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "c3e28407-7bb4-4d2a-8009-0621f236efa3",
      "name": "Filtrer: phone AND email",
      "type": "n8n-nodes-base.filter",
      "position": [
        1240,
        440
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "4f8f9bec-6eee-4e62-8d5f-e8f5b85620d6",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.phone }}",
              "rightValue": ""
            },
            {
              "id": "007f5a66-4e2a-42bc-bbed-0fb2b2f39ae7",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.email }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "23fdf067-cd74-4b04-96df-9241a86570cf",
      "name": "Extract list of peoples from Surfe API response",
      "type": "n8n-nodes-base.code",
      "position": [
        1020,
        440
      ],
      "parameters": {
        "jsCode": "const people = $json.people || [];\n\nreturn people.map(person => {\n  return {\n    json: {\n      id: person.id || '',\n      firstName: person.firstName || '',\n      lastName: person.lastName || '',\n      email: person.emails?.[0]?.email || '',\n      phone: person.mobilePhones?.[0]?.mobilePhone || '',\n      jobTitle: person.jobTitle || '',\n      companyName: person.companyName || '',\n      companyWebsite: person.companyWebsite || '',\n      linkedinUrl: person.linkedinUrl || '',\n      country: person.country || '',\n      status: person.status || ''\n    }\n  };\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "1b84d64f-85ea-4914-96e2-3321c3ed389d",
      "name": "Is enrichment complete ?",
      "type": "n8n-nodes-base.if",
      "position": [
        800,
        480
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "65a670df-84e8-4c87-956c-96758b8d8d26",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.status }}",
              "rightValue": "COMPLETED"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "735abd1e-66df-4e0c-92e4-803c08edd307",
      "name": "Surfe Bulk Enrichments API",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        340,
        580
      ],
      "parameters": {
        "url": "https://api.surfe.com/v2/people/enrich",
        "method": "POST",
        "options": {
          "redirect": {
            "redirect": {}
          }
        },
        "jsonBody": "={{ $json }}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer XXXXXXXXXXXXXXXXXXXXXXXX"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "976ebf8c-8838-41c1-bb8f-f817a9b60ae9",
      "name": "Surfe check enrichement status",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        560,
        580
      ],
      "parameters": {
        "url": "=https://api.surfe.com/v2/people/enrich/{{ $json.enrichmentID }}",
        "options": {
          "redirect": {
            "redirect": {}
          }
        },
        "jsonBody": "{\n  \"enrichmentType\": \"emailAndMobile\",\n  \"listName\": \"listName\",\n  \"people\": [\n    {\n      \"firstName\": \"\",\n      \"lastName\": \"\",\n      \"companyName\": \"\",\n      \"companyWebsite\": \"\",\n      \"externalID\": \"\",\n      \"linkedinUrl\": \"[YOUR LINKEDIN URL]/\"\n    }\n  ]\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer XXXXXXXXXXXXXXXXXXXXXXXX"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "94417a70-a873-491e-88e6-262dcadde94f",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "notes": "Notify end of all batches",
      "position": [
        120,
        340
      ],
      "webhookId": "b46c028e-8212-40fe-b4d5-0f7c1890585e",
      "parameters": {
        "sendTo": "{YOUR EMAIL ADDRESS}",
        "message": "Your batch csv enrichment is done.",
        "options": {},
        "subject": "Your batch csv enrichment is done."
      },
      "executeOnce": true,
      "notesInFlow": true,
      "typeVersion": 2.1
    },
    {
      "id": "ad49f2c1-a9a0-49fa-8853-aef4dc63a453",
      "name": "Split Batch - 500",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -160,
        580
      ],
      "parameters": {
        "options": {},
        "batchSize": 500
      },
      "notesInFlow": false,
      "typeVersion": 3,
      "alwaysOutputData": false
    },
    {
      "id": "b1c2c48c-5ba6-4a42-ab17-bf69400aa0ac",
      "name": "HubSpot: Create or Update",
      "type": "n8n-nodes-base.hubspot",
      "position": [
        1380,
        1100
      ],
      "parameters": {
        "email": "={{ $json.email }}",
        "options": {
          "resolveData": false
        },
        "authentication": "appToken",
        "additionalFields": {
          "country": "={{ $json.country }}",
          "jobTitle": "={{ $json.jobTitle }}",
          "lastName": "={{ $json.lastName }}",
          "firstName": "={{ $json.firstName }}",
          "websiteUrl": "={{ $json.linkedinUrl }}",
          "companyName": "={{ $json.companyName }}",
          "phoneNumber": "={{ $json.phone }}",
          "mobilePhoneNumber": "={{ $json.phone }}"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "5e689b8d-5539-4593-9e18-903b172f4c73",
      "name": "Attendre 30 secondes",
      "type": "n8n-nodes-base.wait",
      "position": [
        780,
        940
      ],
      "webhookId": "faddf14b-4e33-4108-a141-c1a172e0a5d1",
      "parameters": {
        "amount": 30
      },
      "typeVersion": 1.1
    },
    {
      "id": "b6b81b03-77b5-4868-91f6-12d4d9c248d9",
      "name": "Prepare JSON Payload Enrichment Request",
      "type": "n8n-nodes-base.code",
      "position": [
        120,
        580
      ],
      "parameters": {
        "jsCode": "const items = $input.all();\n\nreturn [\n  {\n    json: {\n    \"include\": {\n      \"email\": true,\n      \"linkedInUrl\": false,\n      \"mobile\": true\n    },\n    \"notificationOptions\": {\n      \"webhookUrl\": \"\"\n    },\n      people: items.map((item) => ({\n        firstName: \"\",\n        lastName: \"\",\n        companyName: \"\",\n        companyWebsite: \"\",\n        externalID: \"\",\n        linkedinUrl: item.json.linkedin_url,\n      })),\n    },\n  },\n];\n"
      },
      "typeVersion": 2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "eb0be05b-a13d-453a-ae04-6800bce9699a",
  "connections": {
    "0796ab84-bf14-4f51-906e-db01486b2c76": {
      "main": [
        [
          {
            "node": "ad49f2c1-a9a0-49fa-8853-aef4dc63a453",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait 30 secondes": {
      "main": [
        [
          {
            "node": "976ebf8c-8838-41c1-bb8f-f817a9b60ae9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ad49f2c1-a9a0-49fa-8853-aef4dc63a453": {
      "main": [
        [
          {
            "node": "94417a70-a873-491e-88e6-262dcadde94f",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "b6b81b03-77b5-4868-91f6-12d4d9c248d9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0cf2212f-e1f3-4616-ad6b-6c8c00bfe237": {
      "main": [
        [
          {
            "node": "0796ab84-bf14-4f51-906e-db01486b2c76",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter: phone AND email": {
      "main": [
        [
          {
            "node": "b1c2c48c-5ba6-4a42-ab17-bf69400aa0ac",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1b84d64f-85ea-4914-96e2-3321c3ed389d": {
      "main": [
        [
          {
            "node": "23fdf067-cd74-4b04-96df-9241a86570cf",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Wait 30 secondes",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b1c2c48c-5ba6-4a42-ab17-bf69400aa0ac": {
      "main": [
        [
          {
            "node": "ad49f2c1-a9a0-49fa-8853-aef4dc63a453",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "735abd1e-66df-4e0c-92e4-803c08edd307": {
      "main": [
        [
          {
            "node": "976ebf8c-8838-41c1-bb8f-f817a9b60ae9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "976ebf8c-8838-41c1-bb8f-f817a9b60ae9": {
      "main": [
        [
          {
            "node": "1b84d64f-85ea-4914-96e2-3321c3ed389d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b6b81b03-77b5-4868-91f6-12d4d9c248d9": {
      "main": [
        [
          {
            "node": "735abd1e-66df-4e0c-92e4-803c08edd307",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "23fdf067-cd74-4b04-96df-9241a86570cf": {
      "main": [
        [
          {
            "node": "Filter: phone AND email",
            "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é ?

Intermédiaire - Génération de leads

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 N8N : Enrichir les groupes d'achat
Découvrir et enrichir automatiquement les groupes d'acheteurs HubSpot en utilisant Surfe et Google Sheets
If
Code
Wait
+
If
Code
Wait
22 Nœudsgo-surfe
Génération de leads
Construire une liste de prospects
Construire une liste de prospects ciblés : utiliser Surfe vers HubSpot pour trouver et enrichir les prospects
If
Code
Wait
+
If
Code
Wait
13 Nœudsgo-surfe
Génération de leads
Prospection et workflow d'e-mails
Utiliser Google Maps, SendGrid et l'IA pour automatiser le développement de prospects B2B et le marketing par e-mail
If
Set
Code
+
If
Set
Code
141 NœudsEzema Kingsley Chibuzo
Génération de leads
Explorer les nœuds n8n dans la bibliothèque de références visuelles
Explorer les nœuds n8n dans la base de références visuelles
If
Ftp
Set
+
If
Ftp
Set
113 NœudsI versus AI
Autres
AI驱动de谷歌地图商家données抓取与表格exportation
基于AIde谷歌地图商家données抓取，支持données丰富化并exportation至表格
If
Code
Wait
+
If
Code
Wait
25 NœudsMsaid Mohamed el hadi
Génération de leads
Agent intelligent de prospection IA
Génération automatisée de prospects et envoi de froid e-mails avec Apify, l'IA et Gmail
If
Set
Wait
+
If
Set
Wait
20 NœudsRakin Jakaria
Génération de leads
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds12
Catégorie1
Types de nœuds10
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Auteur
go-surfe

go-surfe

@go-surfe

Save time and sell more with Surfe's API via n8n workflows. - Accurate data you can trust - Results in milliseconds - Scalable and versatile - Full automation For more check out: 💻 https://www.surfe.com?utm_source=n8n 🔗 https://www.linkedin.com/company/surfe/ 👾 https://github.com/surfe/api-examples

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