Seguimiento automático de ingresos y gastos en Hojas de Cálculo de Google a través de Telegram
Avanzado
Este es unPersonal Productivityflujo de automatización del dominio deautomatización que contiene 31 nodos.Utiliza principalmente nodos como Code, Switch, Telegram, GoogleSheets, TelegramTrigger. Automatizar el seguimiento de ingresos y gastos en una hoja de cálculo de Google con Telegram
Requisitos previos
- •Bot Token de Telegram
- •Credenciales de API de Google Sheets
Nodos utilizados (31)
Categoría
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
"meta": {
"instanceId": "ba73835d772fb31a8c93dbcda773c1ef34e21227b9c152c1ee6fdf0eab995f28",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "326fd72f-6856-47f8-a033-7adbb2eea738",
"name": "Telegram - Incoming Webhook",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-100,
200
],
"webhookId": "d38ec46a-5c4e-48af-a415-400392021f4c",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "f8d79eab-fbcd-46e2-822d-b64f6cdf2343",
"name": "Detectar Tipo de Mensaje",
"type": "n8n-nodes-base.code",
"position": [
80,
200
],
"parameters": {},
"typeVersion": 2
},
{
"id": "cd68fd6e-653a-4cd1-92a4-ebcc7821c36e",
"name": "Enrutar por Tipo de Entrada",
"type": "n8n-nodes-base.switch",
"position": [
260,
200
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "4e054ecd-82dc-4e39-97f1-5bc2eb3e2e40",
"name": "Manejar /start o Entrada de Mensaje",
"type": "n8n-nodes-base.switch",
"position": [
480,
0
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "35faafd8-42c9-44cb-8612-deaa5270f186",
"name": "Mostrar Opciones de Ingreso/Gasto",
"type": "n8n-nodes-base.telegram",
"position": [
700,
-160
],
"webhookId": "34ce0d27-2e04-4402-beef-cbfc0b0c2c7f",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "83d3e6b4-c30c-418b-bc09-53876fd047a3",
"name": "Validar Formato de Entrada",
"type": "n8n-nodes-base.code",
"position": [
700,
20
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8bfb1fac-30ce-4c3a-b7af-2c8ffe6fb259",
"name": "Extraer Tipo de Dato",
"type": "n8n-nodes-base.code",
"position": [
940,
20
],
"parameters": {},
"typeVersion": 2
},
{
"id": "50185b94-d3ce-4c5b-b88a-eb48712abc1b",
"name": "Enrutar Basado en Tipo de Dato",
"type": "n8n-nodes-base.switch",
"position": [
1140,
20
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "dfa8ee96-8dee-4cf6-b14d-58aad6fb2c66",
"name": "Analizar Datos de Ingreso",
"type": "n8n-nodes-base.code",
"position": [
1340,
-100
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ba76cb99-365d-4b49-8935-ca44a17662b6",
"name": "Guardar Ingreso en Hoja",
"type": "n8n-nodes-base.googleSheets",
"position": [
1540,
-100
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "ea50a3b1-40ff-48d3-940c-badc9c474526",
"name": "Notificar al Usuario Ingreso Registrado",
"type": "n8n-nodes-base.telegram",
"position": [
1740,
-100
],
"webhookId": "39b21e24-7b4f-4c83-b410-e0824d8f1089",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "9d8399a5-f689-4589-b5ab-2b5735613a12",
"name": "Analizar Datos de Gasto",
"type": "n8n-nodes-base.code",
"position": [
1340,
40
],
"parameters": {},
"typeVersion": 2
},
{
"id": "73831130-fb6a-4040-8857-b256203b8502",
"name": "Guardar Gasto en Hoja",
"type": "n8n-nodes-base.googleSheets",
"position": [
1540,
40
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "fa0c19ae-f044-4533-b885-9ddc26522344",
"name": "Notificar al Usuario Gasto Pendiente",
"type": "n8n-nodes-base.telegram",
"position": [
1740,
40
],
"webhookId": "baf321e6-3b8f-4451-aaa3-a2c768635d55",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "f06a85ad-5f76-485c-94cf-8465aae0ea50",
"name": "Enviar Solicitud de Aprobación",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
40
],
"webhookId": "3745c927-de23-40f5-9149-9085fd62c886",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "4e3b3a12-3b18-4bd2-ac24-25e39e1c171b",
"name": "Analizar Respuesta de Callback",
"type": "n8n-nodes-base.code",
"position": [
480,
360
],
"parameters": {},
"typeVersion": 2
},
{
"id": "775e82a0-083b-4d1d-b31c-ce6069572e36",
"name": "Enrutar Basado en Tipo de Callback",
"type": "n8n-nodes-base.switch",
"position": [
700,
320
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "45561880-459f-4b5b-97b4-0f0d8185be2d",
"name": "Actualizar Estado de Aprobación",
"type": "n8n-nodes-base.googleSheets",
"position": [
940,
220
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "a5990c44-03a0-4fe5-b822-be593b352559",
"name": "Obtener Fila Aprobada",
"type": "n8n-nodes-base.googleSheets",
"position": [
1140,
220
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "ca1d1ff9-9d0c-44eb-8e64-4c2785692c35",
"name": "Notificar al Usuario del Resultado de Aprobación",
"type": "n8n-nodes-base.telegram",
"position": [
1340,
220
],
"webhookId": "8a346a95-d9a8-43e7-9b7e-46efcdfa53c9",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e5142ba0-50d8-450a-bbd1-45488cf6c386",
"name": "Obtener Fila para Vista Detallada",
"type": "n8n-nodes-base.googleSheets",
"position": [
940,
420
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "fe629ffa-ded8-4e94-bda9-a4206a928e06",
"name": "Formatear Mensaje de Detalle de Gasto",
"type": "n8n-nodes-base.code",
"position": [
1140,
420
],
"parameters": {},
"typeVersion": 2
},
{
"id": "fd3f93a9-6664-4821-9a37-8e63bcafdd8d",
"name": "Enviar Detalle de Gasto al Supervisor",
"type": "n8n-nodes-base.telegram",
"position": [
1340,
420
],
"webhookId": "0c007b17-b53c-4c0d-92e5-f9a7f5a270e5",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "461f7a4e-035b-4ed9-baa1-cd79586d2e3e",
"name": "Mostrar Formato de Entrada de Ingreso",
"type": "n8n-nodes-base.code",
"position": [
940,
580
],
"parameters": {},
"typeVersion": 2
},
{
"id": "afbeeb5b-21a3-4a89-b85d-cc85ff6fe19a",
"name": "Mostrar Formato de Entrada de Gasto",
"type": "n8n-nodes-base.code",
"position": [
940,
740
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a7efd0d0-363f-4d27-9744-81e3eb9587a5",
"name": "Enviar Mensaje de Formato de Ingreso",
"type": "n8n-nodes-base.telegram",
"position": [
1140,
580
],
"webhookId": "ad996647-1e41-4a81-9e31-001dc890cead",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "710ecddd-d353-41e7-8749-9a11e5816607",
"name": "Enviar Mensaje de Formato de Gasto",
"type": "n8n-nodes-base.telegram",
"position": [
1140,
740
],
"webhookId": "6307cfda-748c-47a6-8e6d-1428c69ee157",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "936e41c7-727c-47db-a093-c0ad14b86f0e",
"name": "Nota Adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1460,
-1000
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "aca473db-b4b3-4b48-8bb8-9f213af8fd0f",
"name": "Nota Adhesiva1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1700,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8065e1bb-a036-43dd-8427-1e98d9335339",
"name": "Nota Adhesiva2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1000,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "75124148-3558-4cba-84fd-eb2dafba86a6",
"name": "Nota Adhesiva3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1460,
840
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"a5990c44-03a0-4fe5-b822-be593b352559": {
"main": [
[
{
"node": "ca1d1ff9-9d0c-44eb-8e64-4c2785692c35",
"type": "main",
"index": 0
}
]
]
},
"8bfb1fac-30ce-4c3a-b7af-2c8ffe6fb259": {
"main": [
[
{
"node": "50185b94-d3ce-4c5b-b88a-eb48712abc1b",
"type": "main",
"index": 0
}
]
]
},
"dfa8ee96-8dee-4cf6-b14d-58aad6fb2c66": {
"main": [
[
{
"node": "ba76cb99-365d-4b49-8935-ca44a17662b6",
"type": "main",
"index": 0
}
]
]
},
"9d8399a5-f689-4589-b5ab-2b5735613a12": {
"main": [
[
{
"node": "73831130-fb6a-4040-8857-b256203b8502",
"type": "main",
"index": 0
}
]
]
},
"f8d79eab-fbcd-46e2-822d-b64f6cdf2343": {
"main": [
[
{
"node": "cd68fd6e-653a-4cd1-92a4-ebcc7821c36e",
"type": "main",
"index": 0
}
]
]
},
"cd68fd6e-653a-4cd1-92a4-ebcc7821c36e": {
"main": [
[
{
"node": "4e054ecd-82dc-4e39-97f1-5bc2eb3e2e40",
"type": "main",
"index": 0
}
],
[
{
"node": "4e3b3a12-3b18-4bd2-ac24-25e39e1c171b",
"type": "main",
"index": 0
}
]
]
},
"ba76cb99-365d-4b49-8935-ca44a17662b6": {
"main": [
[
{
"node": "ea50a3b1-40ff-48d3-940c-badc9c474526",
"type": "main",
"index": 0
}
]
]
},
"73831130-fb6a-4040-8857-b256203b8502": {
"main": [
[
{
"node": "fa0c19ae-f044-4533-b885-9ddc26522344",
"type": "main",
"index": 0
}
]
]
},
"f06a85ad-5f76-485c-94cf-8465aae0ea50": {
"main": [
[]
]
},
"83d3e6b4-c30c-418b-bc09-53876fd047a3": {
"main": [
[
{
"node": "8bfb1fac-30ce-4c3a-b7af-2c8ffe6fb259",
"type": "main",
"index": 0
}
]
]
},
"45561880-459f-4b5b-97b4-0f0d8185be2d": {
"main": [
[
{
"node": "a5990c44-03a0-4fe5-b822-be593b352559",
"type": "main",
"index": 0
}
]
]
},
"e5142ba0-50d8-450a-bbd1-45488cf6c386": {
"main": [
[
{
"node": "fe629ffa-ded8-4e94-bda9-a4206a928e06",
"type": "main",
"index": 0
}
]
]
},
"4e3b3a12-3b18-4bd2-ac24-25e39e1c171b": {
"main": [
[
{
"node": "775e82a0-083b-4d1d-b31c-ce6069572e36",
"type": "main",
"index": 0
}
]
]
},
"50185b94-d3ce-4c5b-b88a-eb48712abc1b": {
"main": [
[
{
"node": "dfa8ee96-8dee-4cf6-b14d-58aad6fb2c66",
"type": "main",
"index": 0
}
],
[
{
"node": "9d8399a5-f689-4589-b5ab-2b5735613a12",
"type": "main",
"index": 0
}
],
[]
]
},
"461f7a4e-035b-4ed9-baa1-cd79586d2e3e": {
"main": [
[
{
"node": "a7efd0d0-363f-4d27-9744-81e3eb9587a5",
"type": "main",
"index": 0
}
]
]
},
"afbeeb5b-21a3-4a89-b85d-cc85ff6fe19a": {
"main": [
[
{
"node": "710ecddd-d353-41e7-8749-9a11e5816607",
"type": "main",
"index": 0
}
]
]
},
"fa0c19ae-f044-4533-b885-9ddc26522344": {
"main": [
[
{
"node": "f06a85ad-5f76-485c-94cf-8465aae0ea50",
"type": "main",
"index": 0
}
]
]
},
"326fd72f-6856-47f8-a033-7adbb2eea738": {
"main": [
[
{
"node": "f8d79eab-fbcd-46e2-822d-b64f6cdf2343",
"type": "main",
"index": 0
}
]
]
},
"775e82a0-083b-4d1d-b31c-ce6069572e36": {
"main": [
[
{
"node": "45561880-459f-4b5b-97b4-0f0d8185be2d",
"type": "main",
"index": 0
}
],
[
{
"node": "45561880-459f-4b5b-97b4-0f0d8185be2d",
"type": "main",
"index": 0
}
],
[
{
"node": "e5142ba0-50d8-450a-bbd1-45488cf6c386",
"type": "main",
"index": 0
}
],
[
{
"node": "461f7a4e-035b-4ed9-baa1-cd79586d2e3e",
"type": "main",
"index": 0
}
],
[
{
"node": "afbeeb5b-21a3-4a89-b85d-cc85ff6fe19a",
"type": "main",
"index": 0
}
]
]
},
"fe629ffa-ded8-4e94-bda9-a4206a928e06": {
"main": [
[
{
"node": "fd3f93a9-6664-4821-9a37-8e63bcafdd8d",
"type": "main",
"index": 0
}
]
]
},
"4e054ecd-82dc-4e39-97f1-5bc2eb3e2e40": {
"main": [
[
{
"node": "35faafd8-42c9-44cb-8612-deaa5270f186",
"type": "main",
"index": 0
}
],
[
{
"node": "83d3e6b4-c30c-418b-bc09-53876fd047a3",
"type": "main",
"index": 0
}
]
]
}
}
}Preguntas frecuentes
¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Avanzado - Productividad personal
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
Generar imágenes con Pollinations y artículos de blog con Gemini 2.5 a través de Telegram
Generar imágenes con Pollinations a través de Telegram y generar artículos de blog con Gemini 2.5
If
Set
Code
+
If
Set
Code
34 NodosFahmi Oktafian
Creación de contenido
Construir un asistente de IA multimodal para Telegram con Gemini, voz y generación de imágenes
Construye un asistente de IA multimodal de Telegram usando Gemini, generación de voz e imágenes
If
Set
Code
+
If
Set
Code
95 NodosIniyavan JC
Productividad personal
Crear un chatbot de IA multimodal con Telegram, AIMLAPI y Google Sheets
Usar Telegram, AIMLAPI y Google Sheets para crear un chatbot de IA multimodal
If
Set
Code
+
If
Set
Code
25 NodosAI/ML API | D1m7asis
Productividad personal
Nueva tarea de Notion en Telegram
Crear tareas de Notion desde mensajes de Telegram usando GPT-3.5
Code
Switch
Telegram
+
Code
Switch
Telegram
11 NodosJason Krol
Productividad personal
Registro de gastos de Telegram y Google Sheets: Resumen semanal y recordatorio de presupuesto
Registros de gastos en Telegram y Google Sheets: resumen semanal y recordatorios de presupuesto
Code
Telegram
Google Sheets
+
Code
Telegram
Google Sheets
15 NodosGtaras
Productividad personal
🍳 Cocinero companion — Flujo de trabajo de 30 pasos (Telegram + Google Sheets + LLM)
Gestión de recetas con un robot de Telegram impulsado por IA y una base de datos de Google Sheets
Switch
Function
Telegram
+
Switch
Function
Telegram
41 NodosIssam AGGOUR
Productividad personal
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos31
Categoría1
Tipos de nodos6
Descripción de la dificultad
Autor
Fahmi Oktafian
@fahmi3322Hi! I’m Fahmi Oktafian, a developer and automation enthusiast with expertise in n8n, Node.js, and API integrations. I specialize in building smart, scalable workflows — from auto-publishing content to WordPress, sending automated Telegram notifications, to processing AI-based summaries and paraphrase. I’m passionate about helping businesses save time, increase efficiency, and automate their digital processes with clean and user-friendly solutions.
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo