Téléverseur CSV vers HubSpot (cartographie dynamique de champs et intégration Google Sheets)
Avancé
Ceci est unAI, Marketing, IT Opsworkflow d'automatisation du domainecontenant 36 nœuds.Utilise principalement des nœuds comme If, Set, Code, Form, Merge, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Chargeur de fichiers CSV vers HubSpot avec mappage de champs dynamique et intégration Google Sheets
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 (36)
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"nodes": [
{
"id": "18813eed-27a8-4338-8e71-abb270d43082",
"name": "Diviser par objet",
"type": "n8n-nodes-base.splitOut",
"position": [
-260,
540
],
"parameters": {
"options": {},
"fieldToSplitOut": "object"
},
"typeVersion": 1
},
{
"id": "ee610ddd-5bd7-4d97-82a9-b688c71616d8",
"name": "Récupérer les propriétés de Hubspot",
"type": "n8n-nodes-base.httpRequest",
"position": [
-40,
540
],
"parameters": {
"url": "=https://api.hubapi.com/crm/v3/properties/{{ $json.object }}",
"options": {},
"authentication": "predefinedCredentialType",
"nodeCredentialType": "hubspotOAuth2Api"
},
"credentials": {
"hubspotOAuth2Api": {
"id": "JxzF93M0SJ00jDD9",
"name": "HubSpot account"
},
"hubspotDeveloperApi": {
"id": "EN6KsMdrxSVNfhyz",
"name": "HubSpot Developer account"
}
},
"typeVersion": 4.2
},
{
"id": "22662720-97ae-4e59-a70e-3b858e8e632d",
"name": "Définir crm_type",
"type": "n8n-nodes-base.code",
"position": [
180,
540
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// Loop over input items and add a new field called 'myNewField' to the JSON of each one\n\nfor (let result of $json.results) {\n result.crm_type = $('Split by object').item.json.object;\n delete result.options\n}\nreturn {results: $json.results};\n\n"
},
"typeVersion": 2
},
{
"id": "abfdd971-1112-4dd4-9513-13f12f3e92f2",
"name": "Diviser les résultats",
"type": "n8n-nodes-base.splitOut",
"position": [
400,
540
],
"parameters": {
"include": "allOtherFields",
"options": {},
"fieldToSplitOut": "results"
},
"typeVersion": 1
},
{
"id": "94c2b864-e88d-4da8-9ca3-a34d1ca8b15b",
"name": "Transformer les résultats",
"type": "n8n-nodes-base.code",
"position": [
840,
540
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// Loop over input items and add a new field called 'myNewField' to the JSON of each one\nlet test = []\nlet entry = $input.item.json.results\nreturn {json: entry}\n"
},
"typeVersion": 2
},
{
"id": "ddebf521-ed07-446b-ac2a-e21be46ee2c5",
"name": "Ajouter à la feuille Google",
"type": "n8n-nodes-base.googleSheets",
"position": [
1060,
540
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "updatedAt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "updatedAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "createdAt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "createdAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "label",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "label",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "fieldType",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "fieldType",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "groupName",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "groupName",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "displayOrder",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "displayOrder",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "calculated",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "calculated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "externalOptions",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "externalOptions",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "hasUniqueValue",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "hasUniqueValue",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "hidden",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "hidden",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "hubspotDefined",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "hubspotDefined",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formField",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "formField",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "dataSensitivity",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "dataSensitivity",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "crm_type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "crm_type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "showCurrencySymbol",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "showCurrencySymbol",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "calculationFormula",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "calculationFormula",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "referencedObjectType",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "referencedObjectType",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "createdUserId",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "createdUserId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "updatedUserId",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "updatedUserId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "archived",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "archived",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "dateDisplayHint",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "dateDisplayHint",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "options",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "options",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "modificationMetadata",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "modificationMetadata",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"useAppend": false
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NdvtXADHaSBleSkvVxf6Y6yo3VmHmilLEBuWbrik32w/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1NdvtXADHaSBleSkvVxf6Y6yo3VmHmilLEBuWbrik32w",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NdvtXADHaSBleSkvVxf6Y6yo3VmHmilLEBuWbrik32w/edit?usp=drivesdk",
"cachedResultName": "Properties for Hubspot"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "dfd3d16b-b7d6-49ba-a38b-076960a8a184",
"name": "Effacer la feuille Google",
"type": "n8n-nodes-base.googleSheets",
"position": [
-700,
540
],
"parameters": {
"operation": "clear",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NdvtXADHaSBleSkvVxf6Y6yo3VmHmilLEBuWbrik32w/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1NdvtXADHaSBleSkvVxf6Y6yo3VmHmilLEBuWbrik32w",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NdvtXADHaSBleSkvVxf6Y6yo3VmHmilLEBuWbrik32w/edit?usp=drivesdk",
"cachedResultName": "Properties for Hubspot"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "d39acf68-f809-4a4b-bb5e-5f80a7fddfbc",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1000,
460
],
"parameters": {
"color": 7,
"width": 2280,
"height": 460,
"content": "## Update the properties by object Workflow\n"
},
"typeVersion": 1
},
{
"id": "99ce38cb-937c-44f4-8e21-cceb8c5fa000",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1000,
-300
],
"parameters": {
"color": 7,
"width": 3200,
"height": 700,
"content": "## Import workflow\n"
},
"typeVersion": 1
},
{
"id": "3b231f69-ca9b-40a4-b894-24cece123855",
"name": "Définir un tableau d'objets",
"type": "n8n-nodes-base.set",
"position": [
-480,
540
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d6c05100-fc13-4969-90e5-bcc398a79006",
"name": "object",
"type": "array",
"value": "[\"companies\",\"contacts\", \"deals\", \"leads\", \"tickets\"]"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "d3eff9e3-1fae-4228-bcd9-525854f3f440",
"name": "Démarrez ici pour mettre à jour votre liste de champs",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-920,
540
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b1a4d238-9d55-4bff-a1b4-3942dbe37fdb",
"name": "Formulaire de téléchargement de fichier",
"type": "n8n-nodes-base.formTrigger",
"position": [
-920,
20
],
"webhookId": "fc3523af-1d0f-4dfb-8869-b29cfdde1a06",
"parameters": {
"options": {},
"formTitle": "title",
"formFields": {
"values": [
{
"fieldType": "file",
"fieldLabel": "data",
"multipleFiles": false,
"requiredField": true,
"acceptFileTypes": ".csv"
},
{
"fieldType": "dropdown",
"fieldLabel": "Type of import",
"fieldOptions": {
"values": [
{
"option": "Companies"
},
{
"option": "Contacts"
},
{
"option": "Leads"
},
{
"option": "Deals"
},
{
"option": "Tickets"
}
]
}
}
]
},
"formDescription": "provide me a file"
},
"typeVersion": 2.2
},
{
"id": "44f4ffe7-ff9f-4716-82ef-fc3c44dc48ca",
"name": "Pour obtenir les premiers line du fichier",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-700,
120
],
"parameters": {
"options": {},
"operation": "text"
},
"typeVersion": 1
},
{
"id": "351604db-d9e9-4994-8c1c-f543c13aead9",
"name": "Définir les champs réels",
"type": "n8n-nodes-base.set",
"position": [
-480,
120
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "69a042d8-9543-4a81-bbf8-07e9d7ae2c0d",
"name": "real_fields",
"type": "array",
"value": "={{ $json.data.split(\"\\n\")[0].split(\";\") }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "a61d6de1-005e-41ad-a71e-3eafde83afc7",
"name": "Obtenir les champs de la feuille",
"type": "n8n-nodes-base.googleSheets",
"position": [
-40,
20
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $('File upload form').first().json['Type of import'].toLowerCase() }}",
"lookupColumn": "crm_type"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NdvtXADHaSBleSkvVxf6Y6yo3VmHmilLEBuWbrik32w/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1NdvtXADHaSBleSkvVxf6Y6yo3VmHmilLEBuWbrik32w",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NdvtXADHaSBleSkvVxf6Y6yo3VmHmilLEBuWbrik32w/edit?usp=drivesdk",
"cachedResultName": "Properties for Hubspot"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "617d572a-53a9-4fe8-9f73-06689c706006",
"name": "Fusionner champs et données",
"type": "n8n-nodes-base.merge",
"position": [
-260,
20
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "f2be6bfb-ac32-43d0-924c-d8f20a401b2f",
"name": "Vérifier si tous les champs d'entrée sont définis",
"type": "n8n-nodes-base.code",
"position": [
180,
20
],
"parameters": {
"jsCode": "// \nlet type = $('File upload form').first().json['Type of import']\n// Get first line of json\nlet first_line = $('Set the real fields').first().json.real_fields\nlet keys = Object.values(first_line)\nlet props = []\n\nfor (let realField of $input.all()) {\n props.push(realField.json.name)\n}\nlet response = true\nfor (let key of keys) {\n if(!props.includes(key.trim())) {\n console.log(props, key)\n response = false\n }\n}\n\nreturn {response, keys, props}"
},
"typeVersion": 2
},
{
"id": "8a2e23a3-c044-48ac-b66c-7205e34ad3bd",
"name": "Si tous les champs sont définis",
"type": "n8n-nodes-base.if",
"position": [
400,
20
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3bb457eb-aef5-43f6-b268-1baaad0698e3",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.response }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "123f6190-600a-410a-b943-a6e67d4f0a86",
"name": "Créer la table de correspondance",
"type": "n8n-nodes-base.code",
"position": [
620,
120
],
"parameters": {
"jsCode": "\nlet ret = []\nlet fields = {}\nfor (let key of $input.first().json.keys) {\n if (!$input.first().json.props.includes(key)) {\n let fieldName = `Set the correct field for '${key}'`\n fields[fieldName] = key\n // console.log(key)\n ret.push(\n {\n \"fieldLabel\":key,\n \"fieldType\": \"dropdown\",\n \"fieldOptions\": {\n \"values\": $input.first().json.props.map(x => {return {\"option\": x}})\n\t\t},\n \"requiredField\":false\n }\n )\n }\n}\n\nreturn {ret, fields}"
},
"typeVersion": 2
},
{
"id": "c7348c9a-e4c3-4af2-9224-5338799ed7aa",
"name": "Formulaire pour définir le champ correspondant pour chaque champ d'entrée",
"type": "n8n-nodes-base.form",
"position": [
840,
120
],
"webhookId": "8bdb6e07-1112-4923-a1a3-a0fbb83c806e",
"parameters": {
"options": {
"formTitle": "=Correspondance for fields",
"formDescription": "=Set the correct equivalent for each field.\nYou don't have to do it for all fields."
},
"defineForm": "json",
"jsonOutput": "={{$json.ret}}"
},
"executeOnce": true,
"typeVersion": 1
},
{
"id": "2ba6be51-2508-4d34-b447-2f326fb692b5",
"name": "Obtenir le contenu du fichier",
"type": "n8n-nodes-base.extractFromFile",
"onError": "continueRegularOutput",
"position": [
-480,
-80
],
"parameters": {
"options": {
"encoding": "utf-8",
"delimiter": ";",
"headerRow": true
}
},
"typeVersion": 1
},
{
"id": "3bae9532-81d5-4694-b2cd-40c2b8207b22",
"name": "Note adhésive2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-960,
-220
],
"parameters": {
"color": 4,
"width": 840,
"height": 500,
"content": "## Form uploader\n- Choose file to import. The CSV file has \",\" as delimiters, is encoded in UTF8 and has the name of the fields as header. You can change all that in \"Get content of the file\"\n- Set the type of object you want to import"
},
"typeVersion": 1
},
{
"id": "2836df7d-4307-485c-857e-30b0bb4cf59b",
"name": "Diviser tous les enregistrements à importer",
"type": "n8n-nodes-base.splitOut",
"position": [
1280,
20
],
"parameters": {
"include": "allOtherFields",
"options": {},
"fieldToSplitOut": "out"
},
"typeVersion": 1
},
{
"id": "5d4481f4-0157-42d4-8223-1259f45a1846",
"name": "Définir les propriétés",
"type": "n8n-nodes-base.set",
"position": [
1500,
20
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bc1ad698-c75a-49e5-843c-03c1c64a21b1",
"name": "def.properties",
"type": "object",
"value": "={{ $json.out }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "b765d44e-6b13-4031-b188-e827578b9bee",
"name": "Téléverser vers Hubspot",
"type": "n8n-nodes-base.httpRequest",
"position": [
1720,
20
],
"parameters": {
"url": "https://api.hubapi.com/crm/v3/objects/companies",
"method": "POST",
"options": {},
"jsonBody": "={{ $json.def }}",
"sendBody": true,
"specifyBody": "json",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "hubspotOAuth2Api"
},
"credentials": {
"hubspotOAuth2Api": {
"id": "JxzF93M0SJ00jDD9",
"name": "HubSpot account"
},
"hubspotDeveloperApi": {
"id": "EN6KsMdrxSVNfhyz",
"name": "HubSpot Developer account"
}
},
"typeVersion": 4.2
},
{
"id": "f95862b2-555b-44a7-b318-cb3316d33594",
"name": "Réponse du formulaire",
"type": "n8n-nodes-base.form",
"position": [
1940,
20
],
"webhookId": "980c195f-9ea2-4f38-a869-6ac946b9552d",
"parameters": {
"options": {
"formTitle": ""
},
"operation": "completion",
"completionTitle": "Your Data has been imported successfully"
},
"typeVersion": 1
},
{
"id": "75275b15-24e3-4fee-9d71-b4e7a2479c11",
"name": "Supprimer les champs masqués et commençant par hs_",
"type": "n8n-nodes-base.filter",
"position": [
620,
540
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "14ed0cde-e546-4b13-9405-16834831a7b4",
"operator": {
"type": "string",
"operation": "notStartsWith"
},
"leftValue": "={{ $json.results.name }}",
"rightValue": "hs_"
},
{
"id": "60337002-8aba-404c-b6e0-99fcd60e1d84",
"operator": {
"type": "boolean",
"operation": "false",
"singleValue": true
},
"leftValue": "={{ $json.results.hidden }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "3b131ff9-ff8c-4b4c-8f48-7603e2f4e29c",
"name": "Note adhésive3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-220
],
"parameters": {
"color": 4,
"width": 660,
"height": 500,
"content": "## Properties procesor\n- Get the list of properties defined by \"Update the properties by object\" for the choosen object in \"Form uploader\"\n- Check if all fields fro the file have their name in this list\n- If not, go to the correspondance form\n- if yes goes on to processing"
},
"typeVersion": 1
},
{
"id": "75d465db-f0df-489b-a596-ed9e5a6b97ea",
"name": "Note adhésive4",
"type": "n8n-nodes-base.stickyNote",
"position": [
580,
-220
],
"parameters": {
"color": 4,
"width": 640,
"height": 500,
"content": "## Set the values for each property\n"
},
"typeVersion": 1
},
{
"id": "16869a28-c6c1-4f88-ae7a-6ca74ad97a31",
"name": "Définir les valeurs pour chaque champ",
"type": "n8n-nodes-base.code",
"position": [
1060,
-80
],
"parameters": {
"jsCode": "\nfunction findKeyByValue(obj, value) {\n return Object.keys(obj).find(key => obj[key] === value);\n}\n\nlet out = []\nconst data = $('Get the content of file').all().map(x => x.json)\nconsole.log(data)\n\nfor (const item of data) {\n console.log(item)\n let elt = {}\n \n for (const prop of $('Check if all fields from input are defined').first().json.props) {\n elt[prop] = item[prop]\n }\n\n out.push(elt)\n}\n\nreturn {out}"
},
"typeVersion": 2
},
{
"id": "c7f51291-91df-497e-8466-031ac031384a",
"name": "Définir les valeurs pour chaque champ1",
"type": "n8n-nodes-base.code",
"position": [
1060,
120
],
"parameters": {
"jsCode": "\nfunction findKeyByValue(obj, value) {\n return Object.keys(obj).find(key => obj[key] === value);\n}\n\nlet out = []\nconst data = $('Get the content of file').all().map(x => x.json)\n// console.log(form_fields)\n\nfor (const item of data) {\n let elt = {}\n for (const prop of $('Check if all fields from input are defined').first().json.props) {\n let equival = findKeyByValue($input.all()[0].json, prop)\n if(equival) {\n elt[prop] = item[equival]\n } else {\n elt[prop] = item[prop]\n }\n }\n \n out.push(elt)\n}\n\nreturn {out}"
},
"typeVersion": 2
},
{
"id": "6aafe2ff-e4c7-4e07-8a39-d5bed120fdf7",
"name": "Note adhésive5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1240,
-220
],
"parameters": {
"color": 4,
"width": 640,
"height": 500,
"content": "## Import the values in Hubspot\n"
},
"typeVersion": 1
},
{
"id": "0b2e7364-4da7-4c4b-b1a2-3fda8e0a20be",
"name": "Note adhésive7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1000,
-520
],
"parameters": {
"width": 460,
"height": 200,
"content": "## Contact me\n- If you need any modification to this workflow\n- if you need some help with this workflow\n- Or if you need any workflow in n8n, Make, or Langchain / Langgraph\n\nWrite to me: [thomas@pollup.net](mailto:thomas@pollup.net)\nCheck out my other templates [here](https://n8n.io/creators/zeerobug/)"
},
"typeVersion": 1
},
{
"id": "5cf4f276-54e4-4e31-af1c-c2808802afda",
"name": "Note adhésive6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-540,
520
],
"parameters": {
"color": 4,
"height": 380,
"content": "\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n## List of objects\nDefine Here the list of the objects you would like to import in Hubspot"
},
"typeVersion": 1
},
{
"id": "bd0953b5-769f-40b2-9e71-b4e38f5aea7c",
"name": "Note adhésive8",
"type": "n8n-nodes-base.stickyNote",
"position": [
560,
520
],
"parameters": {
"color": 4,
"height": 380,
"content": "\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n## Filter the list of properties here"
},
"typeVersion": 1
},
{
"id": "ae9d2dee-1c07-40eb-b8aa-020cde8534df",
"name": "Note adhésive9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-760,
520
],
"parameters": {
"color": 4,
"width": 200,
"height": 380,
"content": "\n\n\n\n\n\n\n\n\n\n\n\n\n\n## Create an empty Google Sheet\nIf you run this part, and set it here and in the last node"
},
"typeVersion": 1
}
],
"connections": {
"abfdd971-1112-4dd4-9513-13f12f3e92f2": {
"main": [
[
{
"node": "75275b15-24e3-4fee-9d71-b4e7a2479c11",
"type": "main",
"index": 0
}
]
]
},
"22662720-97ae-4e59-a70e-3b858e8e632d": {
"main": [
[
{
"node": "abfdd971-1112-4dd4-9513-13f12f3e92f2",
"type": "main",
"index": 0
}
]
]
},
"18813eed-27a8-4338-8e71-abb270d43082": {
"main": [
[
{
"node": "ee610ddd-5bd7-4d97-82a9-b688c71616d8",
"type": "main",
"index": 0
}
]
]
},
"b1a4d238-9d55-4bff-a1b4-3942dbe37fdb": {
"main": [
[
{
"node": "44f4ffe7-ff9f-4716-82ef-fc3c44dc48ca",
"type": "main",
"index": 0
},
{
"node": "2ba6be51-2508-4d34-b447-2f326fb692b5",
"type": "main",
"index": 0
}
]
]
},
"5d4481f4-0157-42d4-8223-1259f45a1846": {
"main": [
[
{
"node": "b765d44e-6b13-4031-b188-e827578b9bee",
"type": "main",
"index": 0
}
]
]
},
"dfd3d16b-b7d6-49ba-a38b-076960a8a184": {
"main": [
[
{
"node": "3b231f69-ca9b-40a4-b894-24cece123855",
"type": "main",
"index": 0
}
]
]
},
"b765d44e-6b13-4031-b188-e827578b9bee": {
"main": [
[
{
"node": "f95862b2-555b-44a7-b318-cb3316d33594",
"type": "main",
"index": 0
}
]
]
},
"351604db-d9e9-4994-8c1c-f543c13aead9": {
"main": [
[
{
"node": "617d572a-53a9-4fe8-9f73-06689c706006",
"type": "main",
"index": 1
}
]
]
},
"617d572a-53a9-4fe8-9f73-06689c706006": {
"main": [
[
{
"node": "a61d6de1-005e-41ad-a71e-3eafde83afc7",
"type": "main",
"index": 0
}
]
]
},
"ddebf521-ed07-446b-ac2a-e21be46ee2c5": {
"main": [
[]
]
},
"94c2b864-e88d-4da8-9ca3-a34d1ca8b15b": {
"main": [
[
{
"node": "ddebf521-ed07-446b-ac2a-e21be46ee2c5",
"type": "main",
"index": 0
}
]
]
},
"3b231f69-ca9b-40a4-b894-24cece123855": {
"main": [
[
{
"node": "18813eed-27a8-4338-8e71-abb270d43082",
"type": "main",
"index": 0
}
]
]
},
"2ba6be51-2508-4d34-b447-2f326fb692b5": {
"main": [
[
{
"node": "617d572a-53a9-4fe8-9f73-06689c706006",
"type": "main",
"index": 0
}
]
]
},
"8a2e23a3-c044-48ac-b66c-7205e34ad3bd": {
"main": [
[
{
"node": "16869a28-c6c1-4f88-ae7a-6ca74ad97a31",
"type": "main",
"index": 0
}
],
[
{
"node": "123f6190-600a-410a-b943-a6e67d4f0a86",
"type": "main",
"index": 0
}
]
]
},
"2836df7d-4307-485c-857e-30b0bb4cf59b": {
"main": [
[
{
"node": "5d4481f4-0157-42d4-8223-1259f45a1846",
"type": "main",
"index": 0
}
]
]
},
"ee610ddd-5bd7-4d97-82a9-b688c71616d8": {
"main": [
[
{
"node": "22662720-97ae-4e59-a70e-3b858e8e632d",
"type": "main",
"index": 0
}
]
]
},
"a61d6de1-005e-41ad-a71e-3eafde83afc7": {
"main": [
[
{
"node": "f2be6bfb-ac32-43d0-924c-d8f20a401b2f",
"type": "main",
"index": 0
}
]
]
},
"16869a28-c6c1-4f88-ae7a-6ca74ad97a31": {
"main": [
[
{
"node": "2836df7d-4307-485c-857e-30b0bb4cf59b",
"type": "main",
"index": 0
}
]
]
},
"44f4ffe7-ff9f-4716-82ef-fc3c44dc48ca": {
"main": [
[
{
"node": "351604db-d9e9-4994-8c1c-f543c13aead9",
"type": "main",
"index": 0
}
]
]
},
"c7f51291-91df-497e-8466-031ac031384a": {
"main": [
[
{
"node": "2836df7d-4307-485c-857e-30b0bb4cf59b",
"type": "main",
"index": 0
}
]
]
},
"123f6190-600a-410a-b943-a6e67d4f0a86": {
"main": [
[
{
"node": "c7348c9a-e4c3-4af2-9224-5338799ed7aa",
"type": "main",
"index": 0
}
]
]
},
"d3eff9e3-1fae-4228-bcd9-525854f3f440": {
"main": [
[
{
"node": "dfd3d16b-b7d6-49ba-a38b-076960a8a184",
"type": "main",
"index": 0
}
]
]
},
"f2be6bfb-ac32-43d0-924c-d8f20a401b2f": {
"main": [
[
{
"node": "8a2e23a3-c044-48ac-b66c-7205e34ad3bd",
"type": "main",
"index": 0
}
]
]
},
"75275b15-24e3-4fee-9d71-b4e7a2479c11": {
"main": [
[
{
"node": "94c2b864-e88d-4da8-9ca3-a34d1ca8b15b",
"type": "main",
"index": 0
}
]
]
},
"c7348c9a-e4c3-4af2-9224-5338799ed7aa": {
"main": [
[
{
"node": "c7f51291-91df-497e-8466-031ac031384a",
"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é - Intelligence Artificielle, Marketing, Opérations IT
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
Automatisation de l'envoi de demandes de contact LinkedIn et de messages d'ouverture avec Unipile et Google Sheets
Utiliser Unipile et Google Sheets pour envoyer automatiquement des demandes de contact LinkedIn et des messages d'ouverture
If
Set
Code
+
If
Set
Code
44 NœudsPollupAI
Autres
Automatisation des demandes LinkedIn et des messages d'ouverture avec Browserflow et Google Sheets
Utiliser Browserflow et Google Sheets pour automatiser les demandes LinkedIn et les messages d'ouverture
If
Set
Sort
+
If
Set
Sort
44 NœudsPollupAI
Ventes
Analyse automatisée des réunions Microsoft Teams avec GPT-4.1, Outlook et Mem.ai
Utiliser GPT-4.1, Outlook et Mem.ai pour automatiser l'analyse des réunions Microsoft Teams
If
Set
Code
+
If
Set
Code
61 NœudsWayne Simpson
Ressources Humaines
Génération de titres/vignettes virales
Automatiser la création de titres et de miniatures virales pour YouTube (FLUX.1 + Apify)
If
Set
Code
+
If
Set
Code
41 NœudsNasser
Intelligence Artificielle
Mon workflow 5
Génération automatisée de prospects LinkedIn avec personnalisation d'e-mails par IA (inachevé)
If
Set
Code
+
If
Set
Code
37 NœudsMatthieu
Ventes
Créer automatiquement de courtes vidéos YouTube avec Elevenlabs et Hailuo AI
Créer automatiquement de courtes vidéos YouTube avec Elevenlabs et Hailuo AI
If
Set
Code
+
If
Set
Code
38 NœudsNguyen Quoc Hai
Intelligence Artificielle
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds36
Catégorie3
Types de nœuds13
Description de la difficulté
Auteur
PollupAI
@zeerobugWe create bespoke AI solutions, automations and agents that help your business as it scales.
Liens externes
Voir sur n8n.io →
Partager ce workflow