I’ve made good progress on my enrichment workflow, all the APIs are working etc… but I have a few small bugs. (Knowing that I use the Open Source version of n8n)
-
I would like you to tell me in the structure what could be simplified or improved because I have the impression that ChatGPT has made everything more complex for me
-
Then I would like that in my Loop my Json elements linked to my Google Sheet are all accessible at all times, that is to say that we can call {{ $json.LinkedIn }}, {{ $json.Mail }} etc… at any time in the Loop (This is my biggest problem) knowing that I have the impression that the Http and Update overwrite this data and therefore that I never have access to it again even though it is essential data to make my APIs work
-
I would like to have a csv rendering that does not bug, if you look at the screen just below the second enrichment from Louis overwrote that of Célian and came to this line there when it should not have.
I am attaching a photo of the scenario and the JSON so that it can help you understand my mistakes, thank you in advance because it is very important for me
Voici le Json : {
“name”: “Enrichment Sales Navigator”,
“nodes”: [
{
“parameters”: {
“operation”: “update”,
“documentId”: {
“__rl”: true,
“value”: “={{ $node[\“Create spreadsheet2\”].json.spreadsheetId }}”,
“mode”: “id”
},
“sheetName”: {
“__rl”: true,
“value”: “={{ $node[\“Create spreadsheet2\”].json.sheets[0].properties.sheetId }}”,
“mode”: “id”
},
“columns”: {
“mappingMode”: “defineBelow”,
“value”: {
“Mail”: “={{ $json.Mail }}”,
“Certainty”: “={{ $json.Certainty }}”,
“MXRecords”: “={{ $json.MXRecords }}”,
“MXProvider”: “={{ $json.MXProvider }}”,
“rowIndex”: “={{ $json.rowIndex }}”
},
“matchingColumns”: [
“rowIndex”
\],
“schema”: [
{
“id”: “Name”,
“displayName”: “Name”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “Second Name”,
“displayName”: “Second Name”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “LinkedIn”,
“displayName”: “LinkedIn”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “Mail”,
“displayName”: “Mail”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true
},
{
“id”: “Number”,
“displayName”: “Number”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “site”,
“displayName”: “site”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “Certainty”,
“displayName”: “Certainty”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true
},
{
“id”: “MXRecords”,
“displayName”: “MXRecords”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true
},
{
“id”: “MXProvider”,
“displayName”: “MXProvider”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true
},
{
“id”: “QualityMail”,
“displayName”: “QualityMail”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “ResultMail”,
“displayName”: “ResultMail”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “rowIndex”,
“displayName”: “rowIndex”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “row_number”,
“displayName”: “row_number”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “number”,
“canBeUsedToMatch”: true,
“readOnly”: true,
“removed”: true
}
\],
“attemptToConvertTypes”: false,
“convertFieldsToString”: false
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.6,
“position”: [
1808,
1600
\],
“id”: “dd3628de-6a0a-49c8-bf2a-20840885ff65”,
“name”: “Update row in sheet”,
“alwaysOutputData”: true,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “5vWzdQgZW1Nku6Ke”,
“name”: “Google Sheets account”
}
}
},
{
“parameters”: {
“operation”: “update”,
“documentId”: {
“__rl”: true,
“value”: “={{ $node[\“Create spreadsheet2\”].json.spreadsheetId }}”,
“mode”: “id”
},
“sheetName”: {
“__rl”: true,
“value”: “={{ $node[\“Create spreadsheet2\”].json.sheets[0].properties.sheetId }}”,
“mode”: “id”
},
“columns”: {
“mappingMode”: “defineBelow”,
“value”: {
“ResultMail”: “={{ $json.ResultMail }}”,
“QualityMail”: “={{ $json.QualityMail }}”,
“rowIndex”: “={{ $json.rowIndex }}”
},
“matchingColumns”: [
“rowIndex”
\],
“schema”: [
{
“id”: “Name”,
“displayName”: “Name”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “Second Name”,
“displayName”: “Second Name”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “LinkedIn”,
“displayName”: “LinkedIn”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “Mail”,
“displayName”: “Mail”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “Number”,
“displayName”: “Number”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “site”,
“displayName”: “site”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “Certainty”,
“displayName”: “Certainty”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “MXRecords”,
“displayName”: “MXRecords”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “MXProvider”,
“displayName”: “MXProvider”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “QualityMail”,
“displayName”: “QualityMail”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “ResultMail”,
“displayName”: “ResultMail”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “rowIndex”,
“displayName”: “rowIndex”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “row_number”,
“displayName”: “row_number”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “number”,
“canBeUsedToMatch”: true,
“readOnly”: true,
“removed”: true
}
\],
“attemptToConvertTypes”: false,
“convertFieldsToString”: false
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.6,
“position”: [
3744,
1280
\],
“id”: “cbba36d3-4c2d-486e-8f5b-2739841e2c2d”,
“name”: “Update row in sheet1”,
“alwaysOutputData”: true,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “5vWzdQgZW1Nku6Ke”,
“name”: “Google Sheets account”
}
}
},
{
“parameters”: {
“operation”: “update”,
“documentId”: {
“__rl”: true,
“value”: “={{ $node[\“Create spreadsheet2\”].json.spreadsheetId }}”,
“mode”: “id”
},
“sheetName”: {
“__rl”: true,
“value”: “={{ $node[\“Create spreadsheet2\”].json.sheets[0].properties.sheetId }}”,
“mode”: “id”
},
“columns”: {
“mappingMode”: “defineBelow”,
“value”: {},
“matchingColumns”: ,
“schema”: ,
“attemptToConvertTypes”: false,
“convertFieldsToString”: false
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.6,
“position”: [
2064,
1840
\],
“id”: “f86fcf9c-d070-4de1-83c2-36e60c24c630”,
“name”: “Update row in sheet2”,
“alwaysOutputData”: true,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “5vWzdQgZW1Nku6Ke”,
“name”: “Google Sheets account”
}
}
},
{
“parameters”: {
“conditions”: {
“options”: {
“caseSensitive”: true,
“leftValue”: “”,
“typeValidation”: “strict”,
“version”: 2
},
“conditions”: [
{
“id”: “d97f4fd6-8642-4983-8b8c-664fdceefbd5”,
“leftValue”: “={{ $json.Number }}”,
“rightValue”: “”,
“operator”: {
“type”: “string”,
“operation”: “notEmpty”,
“singleValue”: true
}
}
\],
“combinator”: “and”
},
“options”: {}
},
“type”: “n8n-nodes-base.if”,
“typeVersion”: 2.2,
“position”: [
4672,
1008
\],
“id”: “c299c197-2c00-486e-a732-c2f9821e0ae9”,
“name”: “If4”
},
{
“parameters”: {
“method”: “POST”,
“url”: “https://api.zeliq.com/api/contact/enrich/phone”,
“sendHeaders”: true,
“headerParameters”: {
“parameters”: [
{
“name”: “accept”,
“value”: “application/json”
},
{
“name”: “x-api-key”,
“value”: “sk-723efa2d8c18422b9a2aa1cea704b400fddb95e821383083”
}
\]
},
“sendBody”: true,
“bodyParameters”: {
“parameters”: [
{
“name”: “linkedin_url”,
“value”: “={{ $json.LinkedIn }}”
},
{
“name”: “email”,
“value”: “={{ $json.Mail }}”
}
\]
},
“options”: {}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.2,
“position”: [
4928,
1008
\],
“id”: “b1abb5fd-f29a-4a83-aa88-29f22f00389f”,
“name”: “HTTP Request4”
},
{
“parameters”: {
“operation”: “update”,
“documentId”: {
“__rl”: true,
“value”: “={{ $node[\“Create spreadsheet2\”].json.spreadsheetId }}”,
“mode”: “id”
},
“sheetName”: {
“__rl”: true,
“value”: “={{ $node[\“Create spreadsheet2\”].json.sheets[0].properties.sheetId }}”,
“mode”: “id”
},
“columns”: {
“mappingMode”: “defineBelow”,
“value”: {
“rowIndex”: “={{ $json.rowIndex }}”,
“Number”: “={{ $json.Number }}”
},
“matchingColumns”: [
“rowIndex”
\],
“schema”: [
{
“id”: “Name”,
“displayName”: “Name”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “Second Name”,
“displayName”: “Second Name”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “LinkedIn”,
“displayName”: “LinkedIn”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “Mail”,
“displayName”: “Mail”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “Number”,
“displayName”: “Number”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true
},
{
“id”: “site”,
“displayName”: “site”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “Certainty”,
“displayName”: “Certainty”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “MXRecords”,
“displayName”: “MXRecords”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “MXProvider”,
“displayName”: “MXProvider”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “QualityMail”,
“displayName”: “QualityMail”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “ResultMail”,
“displayName”: “ResultMail”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: true
},
{
“id”: “rowIndex”,
“displayName”: “rowIndex”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “row_number”,
“displayName”: “row_number”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “number”,
“canBeUsedToMatch”: true,
“readOnly”: true,
“removed”: true
}
\],
“attemptToConvertTypes”: false,
“convertFieldsToString”: false
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.6,
“position”: [
4736,
1312
\],
“id”: “e2966592-b81a-4730-bc83-0ad684826b27”,
“name”: “Update row in sheet3”,
“alwaysOutputData”: true,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “5vWzdQgZW1Nku6Ke”,
“name”: “Google Sheets account”
}
}
},
{
“parameters”: {
“content”: “## Debounce Email”,
“height”: 864,
“width”: 880,
“color”: 4
},
“type”: “n8n-nodes-base.stickyNote”,
“position”: [
3264,
928
\],
“typeVersion”: 1,
“id”: “19459f15-165a-4569-afb6-99e908c969c0”,
“name”: “Sticky Note4”
},
{
“parameters”: {
“content”: “## Enrichment Phone\n”,
“height”: 832,
“width”: 752,
“color”: 5
},
“type”: “n8n-nodes-base.stickyNote”,
“position”: [
4640,
928
\],
“typeVersion”: 1,
“id”: “f5b7fcfc-bc6e-47c3-b381-8018a4c441ea”,
“name”: “Sticky Note5”
},
{
“parameters”: {
“operation”: “download”,
“fileId”: {
“__rl”: true,
“value”: “={{ $items(\“Create spreadsheet2\”,0)[0].json.spreadsheetId }}”,
“mode”: “id”
},
“options”: {
“googleFileConversion”: {
“conversion”: {}
},
“fileName”: “Fichier Enrichie”
}
},
“type”: “n8n-nodes-base.googleDrive”,
“typeVersion”: 3,
“position”: [
2656,
480
\],
“id”: “6e0bddde-452e-4e0f-8047-908e918559c4”,
“name”: “Download file”,
“credentials”: {
“googleDriveOAuth2Api”: {
“id”: “LSpLUCOHntGdaaAU”,
“name”: “Google Drive account”
}
}
},
{
“parameters”: {
“formTitle”: “Drop your LinkedIn Extract”,
“formFields”: {
“values”: [
{
“fieldLabel”: “Excel”,
“fieldType”: “file”,
“acceptFileTypes”: “.xlsx, .csv”,
“requiredField”: true
}
\]
},
“options”: {}
},
“type”: “n8n-nodes-base.formTrigger”,
“typeVersion”: 2.2,
“position”: [
-592,
1312
\],
“id”: “5ec790aa-36e6-4fe7-8098-978bffa6cdc3”,
“name”: “On form submission1”,
“webhookId”: “3f906715-51c1-47df-9ba5-ed5cf3412c1a”
},
{
“parameters”: {
“conditions”: {
“options”: {
“caseSensitive”: true,
“leftValue”: “”,
“typeValidation”: “strict”,
“version”: 2
},
“conditions”: [
{
“id”: “acd3b363-7378-4386-9e14-691001f76070”,
“leftValue”: “={{ $json.Excel[0].filename }}”,
“rightValue”: “.csv”,
“operator”: {
“type”: “string”,
“operation”: “contains”
}
}
\],
“combinator”: “and”
},
“options”: {}
},
“type”: “n8n-nodes-base.if”,
“typeVersion”: 2.2,
“position”: [
-384,
1312
\],
“id”: “02f3eef0-3749-45ed-aebd-aaacd6aef425”,
“name”: “If5”
},
{
“parameters”: {
“binaryPropertyName”: “Excel”,
“options”: {
“headerRow”: true,
“includeEmptyCells”: true
}
},
“type”: “n8n-nodes-base.extractFromFile”,
“typeVersion”: 1,
“position”: [
-192,
1264
\],
“id”: “4c55e4a3-ce88-4479-95c3-b13e7c64e947”,
“name”: “Extract from File2”
},
{
“parameters”: {
“operation”: “xlsx”,
“binaryPropertyName”: “Excel”,
“options”: {
“headerRow”: true,
“includeEmptyCells”: true
}
},
“type”: “n8n-nodes-base.extractFromFile”,
“typeVersion”: 1,
“position”: [
-192,
1392
\],
“id”: “9936f5e4-9590-485b-b3a7-ddb430c5112b”,
“name”: “Extract from File3”
},
{
“parameters”: {
“method”: “POST”,
“url”: “https://app.icypeas.com/api/email-search”,
“sendHeaders”: true,
“headerParameters”: {
“parameters”: [
{
“name”: “Authorization”,
“value”: “73308a8701814947b8e5661cd736a9bc3dafd79888aa4ec4be5a74788608385b”
}
\]
},
“sendBody”: true,
“bodyParameters”: {
“parameters”: [
{
“name”: “firstname”,
“value”: “={{ $json.Name }}”
},
{
“name”: “lastname”,
“value”: “={{ $json[\“Second Name\”] }}”
},
{
“name”: “domainOrCompany”,
“value”: “={{ $json.site }}”
}
\]
},
“options”: {}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.2,
“position”: [
1840,
1312
\],
“id”: “7a6dc34b-87c8-410b-b8cc-04735df6fe05”,
“name”: “HTTP Request5”
},
{
“parameters”: {
“amount”: 10
},
“type”: “n8n-nodes-base.wait”,
“typeVersion”: 1.1,
“position”: [
2016,
1312
\],
“id”: “7358a671-eb78-40ba-8edf-0b0282ac6e99”,
“name”: “Wait”,
“webhookId”: “5ae14bfd-9c97-4b76-a22e-e4df6426a672”
},
{
“parameters”: {
“method”: “POST”,
“url”: “https://app.icypeas.com/api/bulk-single-searchs/read”,
“sendHeaders”: true,
“headerParameters”: {
“parameters”: [
{
“name”: “Authorization”,
“value”: “73308a8701814947b8e5661cd736a9bc3dafd79888aa4ec4be5a74788608385b”
}
\]
},
“sendBody”: true,
“bodyParameters”: {
“parameters”: [
{
“name”: “id”,
“value”: “={{ $json.item._id }}”
}
\]
},
“options”: {}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.2,
“position”: [
2208,
1312
\],
“id”: “1986da17-ee60-458f-b35d-f53fd1064841”,
“name”: “HTTP Request6”
},
{
“parameters”: {
“method”: “POST”,
“url”: “https://app.findymail.com/api/search/linkedin”,
“sendHeaders”: true,
“headerParameters”: {
“parameters”: [
{
“name”: “Authorization”,
“value”: “Bearer eLXSGZceRlhe9wT7xTjT9KNapRjHTvAJlQEk4P2r000a2653”
}
\]
},
“sendBody”: true,
“specifyBody”: “json”,
“jsonBody”: “={\n \“linkedin_url\”: \”{{ $json.LinkedIn }}\“,\n \“webhook_url\”: null\n}”,
“options”: {}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.2,
“position”: [
1808,
1840
\],
“id”: “52d5724e-edbd-418a-acc3-749427fd934f”,
“name”: “HTTP Request7”
},
{
“parameters”: {
“url”: “https://api.millionverifier.com/api/v3”,
“sendQuery”: true,
“queryParameters”: {
“parameters”: [
{
“name”: “api”,
“value”: “XOsXdRHXZ4JEAAVmJXWZyi5r4”
},
{
“name”: “email”,
“value”: “={{ $json.Mail }}”
},
{
“name”: “timeout”,
“value”: “10”
}
\]
},
“options”: {
“redirect”: {
“redirect”: {}
}
}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.2,
“position”: [
3760,
1024
\],
“id”: “9f2c0230-c4da-4793-85f1-2d81a5d4fd98”,
“name”: “HTTP Request8”
},
{
“parameters”: {
“options”: {}
},
“type”: “n8n-nodes-base.splitInBatches”,
“typeVersion”: 3,
“position”: [
1808,
1024
\],
“id”: “683d6c85-35e5-4a29-b298-03530ab2cd6a”,
“name”: “Loop Over Items3”,
“alwaysOutputData”: false
},
{
“parameters”: {
“conditions”: {
“options”: {
“caseSensitive”: true,
“leftValue”: “”,
“typeValidation”: “strict”,
“version”: 2
},
“conditions”: [
{
“id”: “07c642cd-7ad1-40d1-9f1c-0d86ae5f7fa6”,
“leftValue”: “={{ $json.Mail }}”,
“rightValue”: “”,
“operator”: {
“type”: “string”,
“operation”: “notEmpty”,
“singleValue”: true
}
}
\],
“combinator”: “and”
},
“options”: {}
},
“type”: “n8n-nodes-base.if”,
“typeVersion”: 2.2,
“position”: [
2272,
1040
\],
“id”: “67ed3916-7c7c-4c80-8814-fd57e556b0d1”,
“name”: “If6”
},
{
“parameters”: {
“conditions”: {
“options”: {
“caseSensitive”: true,
“leftValue”: “”,
“typeValidation”: “strict”,
“version”: 2
},
“conditions”: [
{
“id”: “07c642cd-7ad1-40d1-9f1c-0d86ae5f7fa6”,
“leftValue”: “={{ $json.Mail }}”,
“rightValue”: “”,
“operator”: {
“type”: “string”,
“operation”: “empty”,
“singleValue”: true
}
}
\],
“combinator”: “and”
},
“options”: {}
},
“type”: “n8n-nodes-base.if”,
“typeVersion”: 2.2,
“position”: [
2816,
1312
\],
“id”: “b84c04ef-59ea-4e72-ac24-2f0c7488e130”,
“name”: “If7”
},
{
“parameters”: {
“resource”: “spreadsheet”,
“title”: "Fichier Enrich ",
“sheetsUi”: {
“sheetValues”: [
{
“title”: “=Fichier Enrichie {{ $json.Excel[0].filename }}”
}
\]
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.6,
“position”: [
384,
1312
\],
“id”: “cc4e1618-e26f-4df4-b91a-edc0795fa011”,
“name”: “Create spreadsheet2”,
“alwaysOutputData”: true,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “5vWzdQgZW1Nku6Ke”,
“name”: “Google Sheets account”
}
}
},
{
“parameters”: {
“operation”: “append”,
“documentId”: {
“__rl”: true,
“value”: “={{ $(‘Create spreadsheet2’).item.json.spreadsheetUrl }}”,
“mode”: “url”
},
“sheetName”: {
“__rl”: true,
“value”: “={{ $(‘Create spreadsheet2’).item.json.sheets[0].properties.sheetId }}”,
“mode”: “id”
},
“columns”: {
“mappingMode”: “autoMapInputData”,
“value”: {},
“matchingColumns”: ,
“schema”: [
{
“id”: “client_name”,
“displayName”: “client_name”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “period_start”,
“displayName”: “period_start”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “period_end”,
“displayName”: “period_end”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “pipelines”,
“displayName”: “pipelines”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “event_limit”,
“displayName”: “event_limit”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “actual_event_volume”,
“displayName”: “actual_event_volume”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “events_over_limit”,
“displayName”: “events_over_limit”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “overage_multiplier”,
“displayName”: “overage_multiplier”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “event_price_per_month”,
“displayName”: “event_price_per_month”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “overage_cost”,
“displayName”: “overage_cost”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “currency”,
“displayName”: “currency”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “status”,
“displayName”: “status”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
},
{
“id”: “note”,
“displayName”: “note”,
“required”: false,
“defaultMatch”: false,
“display”: true,
“type”: “string”,
“canBeUsedToMatch”: true,
“removed”: false
}
\],
“attemptToConvertTypes”: false,
“convertFieldsToString”: false
},
“options”: {
“useAppend”: true
}
},
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 4.6,
“position”: [
768,
1312
\],
“id”: “4b59b9d7-25c2-4223-b8fb-5ef68c35c639”,
“name”: “Append row in sheet4”,
“alwaysOutputData”: true,
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “5vWzdQgZW1Nku6Ke”,
“name”: “Google Sheets account”
}
}
},
{