{
"meta": {
"instanceId": "7350ad64699d4a716bb17e2ac4a1abdc5dd751423501ba26d218b248995d24d7"
},
"nodes": [
{
"parameters": {
"values": {
"string": [
{
"name": "ID",
"value": "={{$node[\"Cadastro\"].json[\"body\"][\"ID\"]}}"
},
{
"name": "Nome",
"value": "={{$node[\"Cadastro\"].json[\"body\"][\"Nome\"]}}"
},
{
"name": "Email",
"value": "={{$node[\"Cadastro\"].json[\"body\"][\"Email\"].toLowerCase()}}"
},
{
"name": "Telefone",
"value": "={{$node[\"Cadastro\"].json[\"body\"][\"Telefone\"].slice(1)}}"
}
]
},
"options": {}
},
"id": "6bb5b34c-0893-46cc-b411-4e4af5d1eb1e",
"name": "Colunas planilha",
"type": "n8n-nodes-base.set",
"position": [
900,
500
],
"typeVersion": 1
},
{
"parameters": {
"operation": "lookup",
"sheetId": "1Rb2SAYvPxIuEYwlndR8KXtwHKiE0a079hqBGvb1yay0",
"lookupColumn": "Email",
"lookupValue": "={{$node[\"Consulta\"].json[\"query\"][\"email\"].toLowerCase()}}",
"options": {}
},
"id": "07fab13c-dbcd-4e2a-b57e-95d4cdeac9ed",
"name": "Consultar cadastro",
"type": "n8n-nodes-base.googleSheets",
"position": [
900,
320
],
"typeVersion": 2,
"credentials": {
"googleSheetsOAuth2Api": {
"id": "2",
"name": "Jean - BotConversa"
}
}
},
{
"parameters": {
"operation": "upsert",
"sheetId": "1Rb2SAYvPxIuEYwlndR8KXtwHKiE0a079hqBGvb1yay0",
"key": "Email",
"options": {
"valueInputMode": "USER_ENTERED"
}
},
"id": "69e922ca-5e72-4d19-ba34-0b93691de2b6",
"name": "Cadastrar na planilha",
"type": "n8n-nodes-base.googleSheets",
"position": [
1100,
500
],
"typeVersion": 2,
"credentials": {
"googleSheetsOAuth2Api": {
"id": "2",
"name": "Jean - BotConversa"
}
}
},
{
"parameters": {
"path": "3c28ab1b-a076-4d07-8cb8-147ca9b83a64",
"responseMode": "lastNode",
"responseData": "allEntries",
"options": {}
},
"id": "f12d2c98-1116-405b-a63f-4d8161b5b2dc",
"name": "Consulta",
"type": "n8n-nodes-base.webhook",
"position": [
700,
320
],
"webhookId": "3c28ab1b-a076-4d07-8cb8-147ca9b83a64",
"typeVersion": 1
},
{
"parameters": {
"httpMethod": "POST",
"path": "3c28ab1b-a076-4d07-8cb8-147ca9b83a64",
"options": {}
},
"id": "ad162d48-717a-4f39-9dd6-411b6ea328e0",
"name": "Cadastro",
"type": "n8n-nodes-base.webhook",
"position": [
700,
500
],
"webhookId": "9f516172-7c00-4965-926a-377ef04706c5",
"typeVersion": 1
}
],
"connections": {
"Colunas planilha": {
"main": [
[
{
"node": "Cadastrar na planilha",
"type": "main",
"index": 0
}
]
]
},
"Consulta": {
"main": [
[
{
"node": "Consultar cadastro",
"type": "main",
"index": 0
}
]
]
},
"Cadastro": {
"main": [
[
{
"node": "Colunas planilha",
"type": "main",
"index": 0
}
]
]
}
}
}