ControlC
· Pastebin
Login
Register
ControlC
/
Create paste
Paste content
Up to 100 KB of text. BBCode formatting is supported.
Title
- optional
Content
B
I
U
S
</>
Colors ↓
Sizes ↓
Size 1
Size 2
Size 3
Size 4
Size 5
Size 6
Size 7
{\r\n \"meta\": {\r\n \"instanceId\": \"7350ad64699d4a716bb17e2ac4a1abdc5dd751423501ba26d218b248995d24d7\"\r\n },\r\n \"nodes\": [\r\n {\r\n \"parameters\": {\r\n \"values\": {\r\n \"string\": [\r\n {\r\n \"name\": \"ID\",\r\n \"value\": \"={{$node[\\"Cadastro\\"].json[\\"body\\"][\\"ID\\"]}}\"\r\n },\r\n {\r\n \"name\": \"Nome\",\r\n \"value\": \"={{$node[\\"Cadastro\\"].json[\\"body\\"][\\"Nome\\"]}}\"\r\n },\r\n {\r\n \"name\": \"Email\",\r\n \"value\": \"={{$node[\\"Cadastro\\"].json[\\"body\\"][\\"Email\\"].toLowerCase()}}\"\r\n },\r\n {\r\n \"name\": \"Telefone\",\r\n \"value\": \"={{$node[\\"Cadastro\\"].json[\\"body\\"][\\"Telefone\\"].slice(1)}}\"\r\n }\r\n ]\r\n },\r\n \"options\": {}\r\n },\r\n \"id\": \"6bb5b34c-0893-46cc-b411-4e4af5d1eb1e\",\r\n \"name\": \"Colunas planilha\",\r\n \"type\": \"n8n-nodes-base.set\",\r\n \"position\": [\r\n 900,\r\n 500\r\n ],\r\n \"typeVersion\": 1\r\n },\r\n {\r\n \"parameters\": {\r\n \"operation\": \"lookup\",\r\n \"sheetId\": \"1Rb2SAYvPxIuEYwlndR8KXtwHKiE0a079hqBGvb1yay0\",\r\n \"lookupColumn\": \"Email\",\r\n \"lookupValue\": \"={{$node[\\"Consulta\\"].json[\\"query\\"][\\"email\\"].toLowerCase()}}\",\r\n \"options\": {}\r\n },\r\n \"id\": \"07fab13c-dbcd-4e2a-b57e-95d4cdeac9ed\",\r\n \"name\": \"Consultar cadastro\",\r\n \"type\": \"n8n-nodes-base.googleSheets\",\r\n \"position\": [\r\n 900,\r\n 320\r\n ],\r\n \"typeVersion\": 2,\r\n \"credentials\": {\r\n \"googleSheetsOAuth2Api\": {\r\n \"id\": \"2\",\r\n \"name\": \"Jean - BotConversa\"\r\n }\r\n }\r\n },\r\n {\r\n \"parameters\": {\r\n \"operation\": \"upsert\",\r\n \"sheetId\": \"1Rb2SAYvPxIuEYwlndR8KXtwHKiE0a079hqBGvb1yay0\",\r\n \"key\": \"Email\",\r\n \"options\": {\r\n \"valueInputMode\": \"USER_ENTERED\"\r\n }\r\n },\r\n \"id\": \"69e922ca-5e72-4d19-ba34-0b93691de2b6\",\r\n \"name\": \"Cadastrar na planilha\",\r\n \"type\": \"n8n-nodes-base.googleSheets\",\r\n \"position\": [\r\n 1100,\r\n 500\r\n ],\r\n \"typeVersion\": 2,\r\n \"credentials\": {\r\n \"googleSheetsOAuth2Api\": {\r\n \"id\": \"2\",\r\n \"name\": \"Jean - BotConversa\"\r\n }\r\n }\r\n },\r\n {\r\n \"parameters\": {\r\n \"path\": \"3c28ab1b-a076-4d07-8cb8-147ca9b83a64\",\r\n \"responseMode\": \"lastNode\",\r\n \"responseData\": \"allEntries\",\r\n \"options\": {}\r\n },\r\n \"id\": \"f12d2c98-1116-405b-a63f-4d8161b5b2dc\",\r\n \"name\": \"Consulta\",\r\n \"type\": \"n8n-nodes-base.webhook\",\r\n \"position\": [\r\n 700,\r\n 320\r\n ],\r\n \"webhookId\": \"3c28ab1b-a076-4d07-8cb8-147ca9b83a64\",\r\n \"typeVersion\": 1\r\n },\r\n {\r\n \"parameters\": {\r\n \"httpMethod\": \"POST\",\r\n \"path\": \"3c28ab1b-a076-4d07-8cb8-147ca9b83a64\",\r\n \"options\": {}\r\n },\r\n \"id\": \"ad162d48-717a-4f39-9dd6-411b6ea328e0\",\r\n \"name\": \"Cadastro\",\r\n \"type\": \"n8n-nodes-base.webhook\",\r\n \"position\": [\r\n 700,\r\n 500\r\n ],\r\n \"webhookId\": \"9f516172-7c00-4965-926a-377ef04706c5\",\r\n \"typeVersion\": 1\r\n }\r\n ],\r\n \"connections\": {\r\n \"Colunas planilha\": {\r\n \"main\": [\r\n [\r\n {\r\n \"node\": \"Cadastrar na planilha\",\r\n \"type\": \"main\",\r\n \"index\": 0\r\n }\r\n ]\r\n ]\r\n },\r\n \"Consulta\": {\r\n \"main\": [\r\n [\r\n {\r\n \"node\": \"Consultar cadastro\",\r\n \"type\": \"main\",\r\n \"index\": 0\r\n }\r\n ]\r\n ]\r\n },\r\n \"Cadastro\": {\r\n \"main\": [\r\n [\r\n {\r\n \"node\": \"Colunas planilha\",\r\n \"type\": \"main\",\r\n \"index\": 0\r\n }\r\n ]\r\n ]\r\n }\r\n }\r\n}
Password
Anyone with the link will still need this password to view.
Self Destruct
5 minutes
1 hour
3 hours
6 hours
12 hours
24 hours
48 hours
72 hours
Sign in to enable "Never expires".
Create paste
Please verify you are human
Cancel