The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"active": true,
"connections": {
"Webhook": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
}
},
"createdAt": "2023-12-19T22:21:11.563Z",
"id": "9sMBGzGcSePcgPeS",
"meta": null,
"name": "JORDANA",
"nodes": [
{
"parameters": {
"httpMethod": "POST",
"path": "a9da7230-c3b7-4638-a370-ff6fc9e626d4",
"options": {}
},
"id": "0559e380-d7e6-419b-be8a-70c3b3264c6b",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"typeVersion": 1,
"position": [
540,
200
]
},
{
"parameters": {
"operation": "appendOrUpdate",
"documentId": {
"__rl": true,
"value": "1t360taDguhCz3fe9iLBj_RItcS6QkVP9LvsnSMjBAlk",
"mode": "list",
"cachedResultName": "CONTROLE JORDANA",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1t360taDguhCz3fe9iLBj_RItcS6QkVP9LvsnSMjBAlk/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "P\u00e1gina1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1t360taDguhCz3fe9iLBj_RItcS6QkVP9LvsnSMjBAlk/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"MOMENTO DO CHAMADO": "={{ $json.body['MOMENTO DO CHAMADO'] }}",
"NOME": "={{ $json.body['NOME DO LEAD'] }}",
"TELEFONE": "={{ $json.body['TELEFONE DO LEAD'] }}",
"IDADES": "={{ $json.body.IDADES }}",
"ELEGIBILIDADE": "={{ $json.body.ELEGIBILIDADE }}",
"STATUS": "={{ $json.body.STATUS }}"
},
"matchingColumns": [
"MOMENTO DO CHAMADO"
],
"schema": [
{
"id": "MOMENTO DO CHAMADO",
"displayName": "MOMENTO DO CHAMADO",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "NOME",
"displayName": "NOME",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "TELEFONE",
"displayName": "TELEFONE",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "IDADES",
"displayName": "IDADES",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "ELEGIBILIDADE",
"displayName": "ELEGIBILIDADE",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "STATUS",
"displayName": "STATUS",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "VALOR",
"displayName": "VALOR",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "OBSERVA\u00c7\u00c3O",
"displayName": "OBSERVA\u00c7\u00c3O",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
]
},
"options": {}
},
"id": "ccc70628-a101-46dc-8d28-d9170161d7f3",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.1,
"position": [
740,
200
],
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
}
],
"settings": {
"executionOrder": "v1"
},
"staticData": null,
"tags": [],
"triggerCount": 1,
"updatedAt": "2023-12-21T16:13:51.000Z",
"versionId": "96412c46-fbea-47a8-9fba-255ed9dfb2e5"
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2Api
About this workflow
JORDANA. Uses googleSheets. Webhook trigger; 2 nodes.
Source: https://github.com/KleyvisonVasconcelos/backup-n8n-maya/blob/388ad413f36f1ea2237fc95f9f958847cfca0dcf/workflows/JORDANA.json — original creator credit. Request a take-down →