This workflow follows the Google Sheets → Googlesheetstrigger recipe pattern — see all workflows that pair these two integrations.
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 →
{
"updatedAt": "2025-04-10T20:02:42.464Z",
"createdAt": "2025-04-10T14:57:11.371Z",
"id": "DOsnZzfRMMDyeNaU",
"name": "[SANTOBET] FLUXO TODO - BACKUP",
"active": false,
"isArchived": false,
"nodes": [
{
"parameters": {},
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
280,
-140
],
"id": "f432b215-d68f-48b6-9c0b-5ff6840802db",
"name": "No Operation, do nothing"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "638eba1a-c0a0-4329-bd59-5da00d1e2823",
"name": "EMAIL",
"value": "={{ $('Switch').item.json.body.name }}",
"type": "string"
},
{
"id": "9b98b952-c484-43b3-b734-a96f86a422b7",
"name": "TELEFONE",
"value": "={{ $('Switch').item.json.body.phone }}",
"type": "string"
},
{
"id": "409704e8-fc9d-412f-8b5c-fbde67860fcd",
"name": "DATA",
"value": "={{ $json.formattedDate }}",
"type": "string"
},
{
"id": "a0d9b15e-23a1-4dc3-b904-a159db745a5b",
"name": "VALOR",
"value": "={{ $('Switch').item.json.body.amount }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-60,
-420
],
"id": "2a37731d-9409-4f2a-8865-2462ced89c5a",
"name": "Edit Fields3"
},
{
"parameters": {
"content": "## PIX GERADO\n** REGISTRO DE PIX GERADOS",
"height": 260,
"width": 1220
},
"type": "n8n-nodes-base.stickyNote",
"position": [
-540,
-520
],
"typeVersion": 1,
"id": "628e8175-61b3-4c2a-a4cc-42375d84b9aa",
"name": "Sticky Note3"
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME",
"mode": "list",
"cachedResultName": "SANTOBET - WEBHOOK",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 1535349365,
"mode": "list",
"cachedResultName": "DEPOSITO GERADO",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit#gid=1535349365"
},
"columns": {
"mappingMode": "autoMapInputData",
"value": {},
"matchingColumns": [
"EMAIL"
],
"schema": [
{
"id": "EMAIL",
"displayName": "EMAIL",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "TELEFONE",
"displayName": "TELEFONE",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "DATA",
"displayName": "DATA",
"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": "PIX GERADO",
"displayName": "PIX GERADO",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
200,
-420
],
"id": "d2fb25e9-3f5d-46a7-96c8-402f083eb982",
"name": "SALVA JOGADOR NO SHEET1",
"retryOnFail": true,
"waitBetweenTries": 5000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "formatDate",
"date": "={{ new Date().toLocaleString('sv-SE', { timeZone: 'America/Sao_Paulo' }).replace('T', ' ') }}",
"format": "custom",
"customFormat": "dd-MM-yyyy - HH:mm",
"options": {}
},
"type": "n8n-nodes-base.dateTime",
"typeVersion": 2,
"position": [
-320,
-420
],
"id": "86ecdb2b-4b3a-46c4-8480-530c5f0c449e",
"name": "Date & Time1"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "638eba1a-c0a0-4329-bd59-5da00d1e2823",
"name": "EMAIL",
"value": "={{ $('Webhookpix').item.json.body.email }}",
"type": "string"
},
{
"id": "9b98b952-c484-43b3-b734-a96f86a422b7",
"name": "TELEFONE",
"value": "={{ $('Webhookpix').item.json.body.phone }}",
"type": "string"
},
{
"id": "409704e8-fc9d-412f-8b5c-fbde67860fcd",
"name": "DATA",
"value": "={{ $json.formattedDate }}",
"type": "string"
},
{
"id": "a0d9b15e-23a1-4dc3-b904-a159db745a5b",
"name": "VALOR",
"value": "={{ $('Webhookpix').item.json.body.amount }}",
"type": "string"
},
{
"id": "063d2ba6-8224-4576-a8e3-60401710cf19",
"name": "VL_TAXA",
"value": "={{ \n ( \n $('Webhookpix').item.json.body.amount <= 30 \n ? (0.80 + $('Webhookpix').item.json.body.amount * 0.01 - 0.01) // Removemos 0.01 para evitar arredondamento para cima\n : $('Webhookpix').item.json.body.amount * 0.04 - 0.01 // Tamb\u00e9m removemos 0.01 aqui para manter o padr\u00e3o\n )\n .toFixed(2) \n .replace('.', ',') \n .replace(/^(\\d+)(\\d{2})$/, 'R$ $1,$2') \n}}\n\n",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-100,
-140
],
"id": "6212fbd9-122c-4a51-ad9e-4f44a9394352",
"name": "Edit Fields5"
},
{
"parameters": {
"content": "## PIX pago\n** REGISTRO DE PIX GERADOS",
"height": 260,
"width": 1020
},
"type": "n8n-nodes-base.stickyNote",
"position": [
-540,
-240
],
"typeVersion": 1,
"id": "a415ce33-0cc9-4a59-9e24-f8828e9c4f29",
"name": "Sticky Note6"
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME",
"mode": "list",
"cachedResultName": "SANTOBET - WEBHOOK",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 1427298924,
"mode": "list",
"cachedResultName": "DEPOSITO PAGO",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit#gid=1427298924"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"EMAIL": "={{ $json.EMAIL }}",
"TELEFONE": "={{ $json.TELEFONE }}",
"DATA": "={{ $json.DATA }}",
" VALOR ": "={{ $json.VALOR }}",
"TAXA BSPAY": "={{ $json.VL_TAXA }}"
},
"matchingColumns": [],
"schema": [
{
"id": "EMAIL",
"displayName": "EMAIL",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "TELEFONE",
"displayName": "TELEFONE",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "DATA",
"displayName": "DATA",
"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": "TAXA BSPAY",
"displayName": "TAXA BSPAY",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
100,
-140
],
"id": "00357149-5e64-4313-b476-a0e773906f2a",
"name": "SALVA JOGADOR NO SHEET2",
"retryOnFail": true,
"waitBetweenTries": 5000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "formatDate",
"date": "={{ new Date().toLocaleString('sv-SE', { timeZone: 'America/Sao_Paulo' }).replace('T', ' ') }}",
"format": "custom",
"customFormat": "dd-MM-yyyy - HH:mm",
"options": {}
},
"type": "n8n-nodes-base.dateTime",
"typeVersion": 2,
"position": [
-300,
-140
],
"id": "5a35a938-9f2b-493f-82ac-983853c83db5",
"name": "Date & Time3"
},
{
"parameters": {
"httpMethod": "POST",
"path": "santopix",
"options": {}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-500,
-140
],
"id": "0a01d7d7-1b72-44db-9dd2-38f8c4efea7b",
"name": "Webhookpix"
},
{
"parameters": {},
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
480,
-420
],
"id": "c2a8b528-f0f3-4b32-8578-eb4e78682d88",
"name": "No Operation, do nothing2"
},
{
"parameters": {
"httpMethod": "POST",
"path": "santopixgerado",
"options": {}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-500,
-420
],
"id": "39785b97-b5b7-4568-9de5-824a14527cea",
"name": "Webhook1",
"disabled": true
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "638eba1a-c0a0-4329-bd59-5da00d1e2823",
"name": "EMAIL",
"value": "={{ $('Webhooksaque').item.json.body.email }}",
"type": "string"
},
{
"id": "409704e8-fc9d-412f-8b5c-fbde67860fcd",
"name": "DATA",
"value": "={{ $json.formattedDate }}",
"type": "string"
},
{
"id": "a0d9b15e-23a1-4dc3-b904-a159db745a5b",
"name": "VALOR",
"value": "={{ Number($('Webhooksaque').item.json.body.amount).toLocaleString('pt-BR', { minimumFractionDigits: 2 }) }}",
"type": "string"
},
{
"id": "3fd940c2-60b3-483d-81c8-6de80077569c",
"name": "TAXA BSPAY",
"value": "={{ \n ($('Webhooksaque').item.json.body.amount * 0.02) \n .toFixed(2) \n .replace('.', ',') \n .replace(/^(\\d+)(\\d{2})$/, 'R$ $1,$2') \n}}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-80,
300
],
"id": "d9747d69-7805-4758-b403-30aad837bc5e",
"name": "Edit Fields6"
},
{
"parameters": {
"content": "## SAQUE FEITO\n** REGISTRO SAQUE REALIZADO",
"height": 440,
"width": 1460
},
"type": "n8n-nodes-base.stickyNote",
"position": [
-540,
60
],
"typeVersion": 1,
"id": "a398d8cd-147c-4dd5-afa7-5c116fe44c06",
"name": "Sticky Note11"
},
{
"parameters": {
"operation": "formatDate",
"date": "={{ new Date().toLocaleString('sv-SE', { timeZone: 'America/Sao_Paulo' }).replace('T', ' ') }}",
"format": "custom",
"customFormat": "dd-MM-yyyy - HH:mm",
"options": {}
},
"type": "n8n-nodes-base.dateTime",
"typeVersion": 2,
"position": [
-280,
300
],
"id": "14025d4a-4f54-4887-9081-937683b3d464",
"name": "Date & Time7"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME",
"mode": "list",
"cachedResultName": "SANTOBET - WEBHOOK",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 571374243,
"mode": "list",
"cachedResultName": "AFILIADOS",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit#gid=571374243"
},
"filtersUI": {
"values": [
{
"lookupColumn": "EMAIL",
"lookupValue": "={{ $json.EMAIL }}"
}
]
},
"options": {
"returnFirstMatch": false
}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
120,
300
],
"id": "36631ea3-0072-44a0-8a7e-3180b8fff407",
"name": "Google Sheets8",
"executeOnce": false,
"alwaysOutputData": true,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "loose",
"version": 2
},
"conditions": [
{
"id": "69e591e4-0f41-4734-b9c8-ad4341c226a4",
"leftValue": "={{ $json.row_number }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
}
}
],
"combinator": "and"
},
"looseTypeValidation": true,
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
280,
260
],
"id": "3d7812d2-bbf8-4f64-906f-106fbce16b97",
"name": "If"
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME",
"mode": "list",
"cachedResultName": "SANTOBET - WEBHOOK",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 1387268248,
"mode": "list",
"cachedResultName": "SAQUES",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit#gid=1387268248"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"EMAIL": "={{ $json.EMAIL }}",
"DATA": "={{ $('Edit Fields6').item.json.DATA }}",
"VALOR": "={{ $('Edit Fields6').item.json.VALOR }}",
"AFILIADO S/N": "AFILIADO",
"TAXA BSPAY": "={{ $('Edit Fields6').item.json['TAXA BSPAY'] }}"
},
"matchingColumns": [],
"schema": [
{
"id": "EMAIL",
"displayName": "EMAIL",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "DATA",
"displayName": "DATA",
"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": "AFILIADO S/N",
"displayName": "AFILIADO S/N",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "TAXA BSPAY",
"displayName": "TAXA BSPAY",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
480,
340
],
"id": "327eb6f1-ac1e-4a56-8018-7f7aac72e24b",
"name": "SAQUE AFILIADO",
"retryOnFail": true,
"waitBetweenTries": 2000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME",
"mode": "list",
"cachedResultName": "SANTOBET - WEBHOOK",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 1387268248,
"mode": "list",
"cachedResultName": "SAQUES",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit#gid=1387268248"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"EMAIL": "={{ $('Edit Fields6').item.json.EMAIL }}",
"DATA": "={{ $('Edit Fields6').item.json.DATA }}",
"VALOR": "={{ $('Edit Fields6').item.json.VALOR }}",
"TAXA BSPAY": "={{ $('Edit Fields6').item.json['TAXA BSPAY'] }}"
},
"matchingColumns": [],
"schema": [
{
"id": "EMAIL",
"displayName": "EMAIL",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "DATA",
"displayName": "DATA",
"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": "AFILIADO S/N",
"displayName": "AFILIADO S/N",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "TAXA BSPAY",
"displayName": "TAXA BSPAY",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
480,
160
],
"id": "91685ad3-5f38-4fc0-9718-25b29cf0d8d5",
"name": "SAQUE JOGADOR",
"retryOnFail": true,
"waitBetweenTries": 2000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {},
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
700,
160
],
"id": "276188ef-98ef-4a83-82c9-5d9bd7be6333",
"name": "No Operation, do nothing1"
},
{
"parameters": {},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
700,
340
],
"id": "0155210b-63ff-4a7a-972e-e0180c568393",
"name": "5s"
},
{
"parameters": {
"operation": "formatDate",
"date": "={{ new Date().toISOString().split('T')[0] }}",
"format": "custom",
"customFormat": "dd-MM-yyyy",
"options": {}
},
"type": "n8n-nodes-base.dateTime",
"typeVersion": 2,
"position": [
1400,
340
],
"id": "c724d84c-91e2-4041-a138-12c1e1dffe9e",
"name": "Date & Time8"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME",
"mode": "list",
"cachedResultName": "SANTOBET - WEBHOOK",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 571374243,
"mode": "list",
"cachedResultName": "AFILIADOS",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit#gid=571374243"
},
"filtersUI": {
"values": [
{
"lookupColumn": "EMAIL",
"lookupValue": "={{ $json.EMAIL }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
960,
340
],
"id": "a47521de-d77a-4dcb-ac8a-cd68f9f81118",
"name": "Google Sheets9",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "5ae0d695-fdcd-4dca-bff7-e43ddfc29013",
"name": "TELEFONE",
"value": "=55{{ $json.TELEFONE.replace(/\\D/g, '') }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
1180,
340
],
"id": "336a8133-32a6-4f7a-88c8-e06d6ec32bf1",
"name": "Edit Fields8"
},
{
"parameters": {
"method": "POST",
"url": "=https://whatsapi.typebot.pro/message/sendText/SUPORTESB",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "apikey",
"value": "=57ec53c5bd97b369472d545052e77007"
}
]
},
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "number",
"value": "={{ $('Edit Fields8').item.json.TELEFONE }}"
},
{
"name": "text",
"value": "=\ud83d\udd25 CONFIRMA\u00c7\u00c3O DE SAQUE | SANTO BET \ud83d\udd25\n\n\ud83d\udcc5 Data: {{ $json['DATA PAGAMENTO'] }}\n\nOl\u00e1, {{ $('Google Sheets9').item.json.EMAIL }}!\nSeu saque no valor de R$ {{ $json.VALOR }} foi processado com sucesso! \u2705\ud83d\udcb0\n\ud83d\udd11 Chave Pix: {{ $json['CHAVE PIX'] }}\n\nAgradecemos sua parceria! Qualquer d\u00favida, estamos \u00e0 disposi\u00e7\u00e3o. \ud83d\udc9a\n\n\ud83d\udd39 Equipe Santo Bet"
}
]
},
"options": {}
},
"id": "9a4762a1-ef8f-4ce2-a30b-e8d0f8257312",
"name": "ENVIA MSG AO AFILIADO2",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
1940,
340
],
"alwaysOutputData": false
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME",
"mode": "list",
"cachedResultName": "SANTOBET - WEBHOOK",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 1588102366,
"mode": "list",
"cachedResultName": "SAQUE AFILIADO",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit#gid=1588102366"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"AVISO ENVIADO": "SIM",
"DATA PAGAMENTO": "={{ $json.formattedDate }}",
"EMAIL": "={{ $('5s').item.json.EMAIL }}",
"DATA": "={{ $json.formattedDate }}",
"STATUS": "PAGO",
"CHAVE PIX": "DADO OCULTO",
"VERIFICADO": "SIM",
"VALOR": "={{ $('SAQUE AFILIADO').item.json.VALOR }}"
},
"matchingColumns": [
"row_number"
],
"schema": [
{
"id": "EMAIL",
"displayName": "EMAIL",
"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": "DATA",
"displayName": "DATA",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "CHAVE PIX",
"displayName": "CHAVE PIX",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "VERIFICADO",
"displayName": "VERIFICADO",
"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
},
{
"id": "DATA PAGAMENTO",
"displayName": "DATA PAGAMENTO",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "RECUSA MOTIVO",
"displayName": "RECUSA MOTIVO",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "AVISO ENVIADO",
"displayName": "AVISO ENVIADO",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
1680,
340
],
"id": "9b3f2772-5fdc-4d15-942f-f848d0791db5",
"name": "Google Sheets10",
"retryOnFail": true,
"waitBetweenTries": 2000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"content": "## AVISO DE SAQUE FEITO PARA AFILIADO\n**ENVIA RELAT\u00d3RIO AO AFILIADO SOBRE SEU SAQUE",
"height": 300,
"width": 1220,
"color": 4
},
"type": "n8n-nodes-base.stickyNote",
"position": [
920,
200
],
"typeVersion": 1,
"id": "e4f1790b-3182-440b-b43f-ce678f2394cd",
"name": "Sticky Note14"
},
{
"parameters": {
"httpMethod": "POST",
"path": "santosaque",
"options": {}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-460,
300
],
"id": "898f8263-c36d-4f9c-914e-6284d610d5f5",
"name": "Webhooksaque"
},
{
"parameters": {
"httpMethod": "POST",
"path": "santocadastro",
"options": {}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-520,
620
],
"id": "e1861d79-a57e-4dfc-af00-0e022fa55116",
"name": "Webhook"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "7dd815a0-d0e5-47d0-b26e-3b90811a7b05",
"name": "NOME",
"value": "={{ $('Webhook').item.json.body.name }}",
"type": "string"
},
{
"id": "638eba1a-c0a0-4329-bd59-5da00d1e2823",
"name": "EMAIL",
"value": "={{ $('Webhook').item.json.body.email }}",
"type": "string"
},
{
"id": "9b98b952-c484-43b3-b734-a96f86a422b7",
"name": "TELEFONE",
"value": "={{ $('Webhook').item.json.body.phone }}",
"type": "string"
},
{
"id": "409704e8-fc9d-412f-8b5c-fbde67860fcd",
"name": "DATA",
"value": "={{ $json.formattedDate }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-100,
620
],
"id": "ab02d549-58a6-4d65-a9a8-78ee96def14d",
"name": "Edit Fields"
},
{
"parameters": {
"content": "## NOVO CADASTRO\n**REGISTRO DE NOVOS JOGADORES",
"height": 260,
"width": 1240
},
"type": "n8n-nodes-base.stickyNote",
"position": [
-540,
540
],
"typeVersion": 1,
"id": "ed5f741b-c14d-44ce-96d5-439e87c0f5af",
"name": "Sticky Note1"
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME",
"mode": "list",
"cachedResultName": "SANTOBET - WEBHOOK",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "JOGADOR",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit#gid=0"
},
"columns": {
"mappingMode": "autoMapInputData",
"value": {},
"matchingColumns": [
"NOME"
],
"schema": [
{
"id": "NOME",
"displayName": "NOME",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "EMAIL",
"displayName": "EMAIL",
"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": "DATA",
"displayName": "DATA",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "AFILIADO",
"displayName": "AFILIADO",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "INDICADO POR",
"displayName": "INDICADO POR",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "BOAS VINDAS ENVIADAS",
"displayName": "BOAS VINDAS ENVIADAS",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
120,
620
],
"id": "d5c9409b-3916-4e40-8ab3-fb8240851ca3",
"name": "SALVA JOGADOR NO SHEET",
"retryOnFail": true,
"waitBetweenTries": 5000,
"notesInFlow": true,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"notes": "Salvar jogador no sheet"
},
{
"parameters": {
"operation": "formatDate",
"date": "={{ DateTime.now().setZone(\"America/Sao_Paulo\").toFormat(\"yyyy-MM-dd\") }}",
"format": "custom",
"customFormat": "dd-MM-yyyy",
"options": {}
},
"type": "n8n-nodes-base.dateTime",
"typeVersion": 2,
"position": [
-300,
620
],
"id": "c4a400ee-ddfb-45ce-b881-f5e7ee955e07",
"name": "Date & Time"
},
{
"parameters": {
"method": "POST",
"url": "https://notify.typebot.pro/SANTOBET",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Title",
"value": "CADASTRO"
}
]
},
"sendBody": true,
"contentType": "raw",
"rawContentType": "text/html",
"body": "CADASTRO CONCLU\u00cdDO",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
340,
620
],
"id": "00cedbb0-3bbf-4359-80f5-aebaf6dd45d1",
"name": "NOTIFY CADASTRO",
"retryOnFail": false,
"waitBetweenTries": 3000,
"onError": "continueRegularOutput"
},
{
"parameters": {},
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
520,
620
],
"id": "c3776a80-283f-4d75-9739-d2a9e4c6ae1f",
"name": "No Operation, do nothing5"
},
{
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"leftValue": "={{ $json.data }}",
"rightValue": "OK",
"operator": {
"type": "string",
"operation": "equals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "ENVIADO"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "451ba9af-29c8-4475-bf7d-bcc70f07be0d",
"leftValue": "={{ $json.data }}",
"rightValue": "=OK",
"operator": {
"type": "string",
"operation": "notEquals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "ERRO"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.switch",
"typeVersion": 3.2,
"position": [
860,
1000
],
"id": "21be8740-0260-4349-b799-6bd13f93f3e1",
"name": "Switch2"
},
{
"parameters": {
"content": "## ENVIO DE SMS DE BOAS VINDAS\n** ENVIA SMS ATRAVES DA INTEGRAFLUX",
"height": 660,
"width": 2040,
"color": 4
},
"type": "n8n-nodes-base.stickyNote",
"position": [
-540,
840
],
"typeVersion": 1,
"id": "7c27aa17-0769-4319-ab88-6e258a10f93d",
"name": "Sticky Note5"
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME",
"mode": "list",
"cachedResultName": "SANTOBET - WEBHOOK",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "JOGADOR",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"EMAIL": "={{ $('Loop Over Items').item.json.EMAIL }}",
"BOAS VINDAS ENVIADAS": "SIM"
},
"matchingColumns": [
"EMAIL"
],
"schema": [
{
"id": "NOME",
"displayName": "NOME",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"displayName": "EMAIL",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "TELEFONE",
"displayName": "TELEFONE",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "DATA",
"displayName": "DATA",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "AFILIADO",
"displayName": "AFILIADO",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "INDICADO POR",
"displayName": "INDICADO POR",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "BOAS VINDAS ENVIADAS",
"displayName": "BOAS VINDAS ENVIADAS",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
1060,
900
],
"id": "84d1c832-4608-452c-a882-d02498a4dd14",
"name": "SMS OK",
"retryOnFail": true,
"waitBetweenTries": 5000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"method": "POST",
"url": "https://sms.aresfun.com/integration/ffc59c17-29ea-4ed8-87aa-359b679273c9",
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={\n \"name\": \"\",\n \"email\": \"{{ $('Google Sheets').item.json.EMAIL }}\",\n \"phone\": \"55{{ $json.TELEFONE.replace(/[()\\s-]/g, '') }}\",\n \"event\": \"new\"\n} ",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
660,
1000
],
"id": "27cc2bb3-2e16-4967-a2dc-cdd1f57802d8",
"name": "POST INTEGRAFLUX"
},
{
"parameters": {
"rule": {
"interval": [
{
"field": "minutes"
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
-760,
940
],
"id": "15e84fbf-b61a-4f1e-8991-d16e3840aca9",
"name": "Schedule Trigger",
"disabled": true
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME",
"mode": "list",
"cachedResultName": "SANTOBET - WEBHOOK",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "JOGADOR",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit#gid=0"
},
"filtersUI": {
"values": [
{
"lookupColumn": "BOAS VINDAS ENVIADAS"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
-280,
940
],
"id": "23b7b488-2657-414f-bdb6-73c243065067",
"name": "Google Sheets",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
200,
980
],
"id": "e122abf8-55fd-478a-9b47-21064ad66677",
"name": "Loop Over Items"
},
{
"parameters": {
"amount": 1
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
1320,
1080
],
"id": "d794d6d4-6298-4bc0-b79c-30845dfaf7ab",
"name": "Wait"
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME",
"mode": "list",
"cachedResultName": "SANTOBET - WEBHOOK",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "JOGADOR",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"EMAIL": "={{ $('Loop Over Items').item.json.EMAIL }}",
"BOAS VINDAS ENVIADAS": "ERRO AO ENVIAR"
},
"matchingColumns": [
"EMAIL"
],
"schema": [
{
"id": "NOME",
"displayName": "NOME",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"displayName": "EMAIL",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "TELEFONE",
"displayName": "TELEFONE",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "DATA",
"displayName": "DATA",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "AFILIADO",
"displayName": "AFILIADO",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "INDICADO POR",
"displayName": "INDICADO POR",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "BOAS VINDAS ENVIADAS",
"displayName": "BOAS VINDAS ENVIADAS",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
1060,
1080
],
"id": "48e00f5c-bf3a-4fbf-b94e-c2f35d446e3b",
"name": "SMS ERRO",
"retryOnFail": true,
"waitBetweenTries": 5000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME",
"mode": "list",
"cachedResultName": "SANTOBET - WEBHOOK",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "JOGADOR",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"EMAIL": "={{ $json.EMAIL }}",
"BOAS VINDAS ENVIADAS": "N\u00b0 ERRADO"
},
"matchingColumns": [
"EMAIL"
],
"schema": [
{
"id": "NOME",
"displayName": "NOME",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"displayName": "EMAIL",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "TELEFONE",
"displayName": "TELEFONE",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "DATA",
"displayName": "DATA",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "AFILIADO",
"displayName": "AFILIADO",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "INDICADO POR",
"displayName": "INDICADO POR",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "BOAS VINDAS ENVIADAS",
"displayName": "BOAS VINDAS ENVIADAS",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
-60,
1200
],
"id": "4e97cb64-0ed6-40dc-9b7f-d89702e8274c",
"name": "NUMERO ERRADO",
"retryOnFail": true,
"waitBetweenTries": 5000,
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"pollTimes": {
"item": [
{
"mode": "everyX",
"value": 5,
"unit": "minutes"
}
]
},
"documentId": {
"__rl": true,
"value": "1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME",
"mode": "list",
"cachedResultName": "SANTOBET - WEBHOOK",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "JOGADOR",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1gkiZcv4TIQVnSZTyGz6kzO3T-sACsUeDgGMXvOInhME/edit#gid=0"
},
"event": "rowAdded",
"options": {}
},
"type": "n8n-nodes-base.googleSheetsTrigger",
"typeVersion": 1,
"position": [
-500,
1160
],
"id": "17a1270e-67a7-4767-a10d-cc2941ddab12",
"name": "Google Sheets Trigger",
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {},
"type": "n8n-nodes-base.limit",
"typeVersion": 1,
"position": [
-280,
1160
],
"id": "cf656812-73c8-482a-ae08-258843fa177c",
"name": "Limit"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "be247335-eb24-4c3d-ae37-1c50deb39a4c",
"name": "TELEFONE",
"value": "={{ $('Google Sheets').item.json.TELEFONE }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
420,
1000
],
"id": "fbfed3c2-c2b4-43d2-91a9-fccd90b7deb9",
"name": "Edit Fields1"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "03ab580c-8f72-4587-898a-59c765b35c95",
"leftValue": "={{ $json.TELEFONE }}",
"rightValue": "(55)",
"operator": {
"type": "string",
"operation": "notContains"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
-80,
940
],
"id": "ec42c8e2-0439-4c8d-b73b-5df88e47dabd",
"name": "If1"
},
{
"parameters": {},
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
180,
1280
],
"id": "59906e4c-8db5-4c93-9171-dc9e625ac249",
"name": "No Operation, do nothing3"
},
{
"parameters": {
"aggregate": "aggregateAllItemData",
"options": {}
},
"type": "n8n-nodes-base.aggregate",
"typeVersion": 1,
"position": [
-60,
1660
],
"id": "6e05409b-9dfb-4df9-81e8-69b8da8533a5",
"name": "Aggregate"
},
{
"parameters": {
"method": "POST",
"url": "=https://whatsapi.typebot.pro/message/sendText/BOSS",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "apikey",
"value": "=57ec53c5bd97b369472d545052e77007"
}
]
},
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "number",
"value": "120363382224860301@g.us"
},
{
"name": "text",
"value": "=\ud83d\udcca RELAT\u00d3RIO SANTOBET\n\ud83d\udcc5 DATA: {{ $('Date & Time4').item.json.formattedDate }}\n\nN\u00daMEROS TOTAL USU\u00c1RIOS\n\ud83d\udc65 N\u00b0 TOTAL DE JOGADORES: {{ $('Aggregate').item.json.data[2]['DASHBOARD SANTOBET'] }}\n\ud83e\udd1d N\u00b0 TOTAL AFILIADOS: {{ $('Aggregate').item.json.data[4]['DASHBOARD SANTOBET'] }}\n\nRELAT\u00d3RIO GERAL\n\ud83d\udcc9 TOTAL PIX PAGOS: {{ $('Aggregate').item.json.data[13]['DASHBOARD SANTOBET'] }}\n\ud83d\udcc9 SAQUES JOGADORES: {{ $('Aggregate').item.json.data[2].col_3 }}\n\ud83d\udcc9 SAQUE AFILIADOS: {{ $('Aggregate').item.json.data
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.
googleSheetsOAuth2ApigoogleSheetsTriggerOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
This workflow automatically backs up player data from your SantoBet system into Google Sheets, ensuring all critical information like player profiles and timestamps is securely stored and easily accessible for review or recovery. It's ideal for betting platform operators who need reliable data preservation without manual intervention, saving hours of tedious export tasks. The key step involves a webhook trigger that captures incoming data, processes it through field edits and date formatting, then saves structured records to two dedicated sheets for comprehensive archiving.
Use this workflow when handling high-volume player registrations or updates in a live betting environment, where real-time backups prevent data loss from system glitches. Avoid it for static datasets that don't require frequent syncing, or if your setup lacks webhook integration for incoming events. Common variations include adding email notifications after backups or filtering data by player status before saving to sheets.
About this workflow
[SANTOBET] FLUXO TODO - BACKUP. Uses googleSheets, httpRequest, googleSheetsTrigger. Webhook trigger; 57 nodes.
Source: https://github.com/woakes070048/N8N_2025/blob/95a39dbe988cf5a13eb6234468a54d8639792685/[santobet]-fluxo-todo---backup-DOsnZzfRMMDyeNaU.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
FLUXO DISPARO DATA E HORA. Uses itemLists, googleSheets, httpRequest. Webhook trigger; 48 nodes.
Item Lists, Google Sheets, HTTP Request
This workflow allows you to accept online payments via YooKassa and log both orders and transactions in Google Sheets — all without writing a single line of code. It supports full payment flow: produc
Google Sheets, HTTP Request
Transform your n8n instance management with this advanced automation system featuring artificial intelligence-driven workflow selection. This template provides comprehensive maintenance operations wit
n8n, HTTP Request, Google Sheets +1
Enrich any list of people with verified contact info using this workflow. This n8n automation scrapes TruePeopleSearch using Zyte's extraction API to safely bypass bot protection and extract detailed
Google Sheets, HTTP Request
Convalidaciones Académicas - Estructura Base. Uses googleSheets, emailSend, googleDrive, httpRequest. Webhook trigger; 35 nodes.
Google Sheets, Email Send, Google Drive +2