{
  "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
          }
        ]
      ]
    }
  }
}