Registrar automáticamente nuevos correos de Gmail en Google Sheets
Intermedio
Este es unCRM, Multimodal AIflujo de automatización del dominio deautomatización que contiene 11 nodos.Utiliza principalmente nodos como Code, Gmail, Merge, Summarize, GoogleSheets. Registrar automáticamente nuevos correos de Gmail en Google Sheets
Requisitos previos
- •Cuenta de Google y credenciales de API de Gmail
- •Credenciales de API de Google Sheets
Nodos utilizados (11)
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": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "ab1b7d2d-7eac-45eb-9e0a-36f14c56df14",
"name": "Al hacer clic en 'Ejecutar flujo de trabajo'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-592,
-944
],
"parameters": {},
"typeVersion": 1
},
{
"id": "be31a0f1-8b41-48ea-b80b-cf3de29df733",
"name": "Nota Adhesiva4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1088,
-1536
],
"parameters": {
"width": 400,
"height": 1056,
"content": "\n## ⚙️ Setup Instructions\n\n### 1️⃣ Connect Gmail\n1. In **n8n → Credentials → New → Gmail OAuth2** \n2. Log in with your Gmail account & approve access \n3. Attach this credential to the **Get new messages** node in the workflow \n\n---\n\n### 2️⃣ Connect Google Sheets\n1. Copy this [Google Sheet template](https://docs.google.com/spreadsheets/d/1t5VXtbo9g7SvGDPmeZok4HG1K-WI1PS0DNBylzmhVwg/edit?usp=drivesdk) into your own Drive \n2. In **n8n → Credentials → New → Google Sheets (OAuth2)** → log in with your Google account & save \n3. In the workflow, select your Spreadsheet ID and Worksheet (Sheet1 by default) in the **Google Sheets nodes** \n\n---\n\n## 📬 Contact\nNeed help customizing this (e.g., filter by sender, auto-reply, or Slack notifications)? \n\n📧 **robert@ynteractive.com** \n🔗 **[Robert Breen](https://www.linkedin.com/in/robert-breen-29429625/)** \n🌐 **[ynteractive.com](https://ynteractive.com)**\n"
},
"typeVersion": 1
},
{
"id": "1d6e32b0-92fe-4473-a207-e895e66b79e2",
"name": "Nota Adhesiva52",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
-1296
],
"parameters": {
"color": 3,
"width": 224,
"height": 336,
"content": "### 1️⃣ Connect Gmail\n1. In **n8n → Credentials → New → Gmail OAuth2** \n2. Log in with your Gmail account & approve access \n3. Attach this credential to the **Get new messages** node in the workflow "
},
"typeVersion": 1
},
{
"id": "4f9c9dd4-6a32-4175-bde4-59224486c5ac",
"name": "Nota Adhesiva50",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
-1536
],
"parameters": {
"color": 7,
"width": 1392,
"height": 1056,
"content": "# 📋 Track Gmail Messages in Google Sheets with Automated Logging\n\nThis workflow automatically **fetches new Gmail messages since the last run** and appends them into a **Google Sheet** with their ID, snippet, and timestamp. \nUse it to keep an ongoing log of emails, create lightweight CRMs, or power downstream automations.\n\n---"
},
"typeVersion": 1
},
{
"id": "0ba209c5-f532-4a98-a60d-2c3867b7890f",
"name": "Nota Adhesiva54",
"type": "n8n-nodes-base.stickyNote",
"position": [
432,
-992
],
"parameters": {
"color": 3,
"width": 288,
"height": 368,
"content": "\n### 2️⃣ Connect Google Sheets\n1. Copy this [Google Sheet template](https://docs.google.com/spreadsheets/d/1t5VXtbo9g7SvGDPmeZok4HG1K-WI1PS0DNBylzmhVwg/edit?usp=drivesdk) into your own Drive \n2. In **n8n → Credentials → New → Google Sheets (OAuth2)** → log in with your Google account & save \n3. In the workflow, select your Spreadsheet ID and Worksheet (Sheet1 by default) in the **Google Sheets nodes** \n"
},
"typeVersion": 1
},
{
"id": "89e5ccfd-b798-427d-a3fb-e1c71e408076",
"name": "Agregar Correos a Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
544,
-752
],
"parameters": {
"columns": {
"value": {
"id": "={{ $json.id }}",
"snippet": "={{ $('Get Current Emails').item.json.snippet }}",
"datetime": "={{ $('Get Todays Date').item.json.date }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "snippet",
"type": "string",
"display": true,
"required": false,
"displayName": "snippet",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "datetime",
"type": "string",
"display": true,
"required": false,
"displayName": "datetime",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1t5VXtbo9g7SvGDPmeZok4HG1K-WI1PS0DNBylzmhVwg/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1t5VXtbo9g7SvGDPmeZok4HG1K-WI1PS0DNBylzmhVwg",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1t5VXtbo9g7SvGDPmeZok4HG1K-WI1PS0DNBylzmhVwg/edit?usp=drivesdk",
"cachedResultName": "Emails"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "7fed2ca3-3b0e-4cd9-89e1-364e21e1e67d",
"name": "Obtener Fecha de Hoy",
"type": "n8n-nodes-base.code",
"position": [
-176,
-848
],
"parameters": {
"jsCode": "// n8n Code node (JavaScript) - ISO UTC format\nconst now = new Date();\n\n// Output as ISO string (e.g., 2025-08-25T21:07:22Z)\nconst formatted = now.toISOString().replace(/\\.\\d{3}Z$/, 'Z');\n\nreturn [{ date: formatted }];\n"
},
"typeVersion": 2
},
{
"id": "57a1dc13-b00a-496c-b121-1b56444fc878",
"name": "Obtener Correos Actuales",
"type": "n8n-nodes-base.googleSheets",
"position": [
-416,
-1104
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1t5VXtbo9g7SvGDPmeZok4HG1K-WI1PS0DNBylzmhVwg/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1t5VXtbo9g7SvGDPmeZok4HG1K-WI1PS0DNBylzmhVwg",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1t5VXtbo9g7SvGDPmeZok4HG1K-WI1PS0DNBylzmhVwg/edit?usp=drivesdk",
"cachedResultName": "Emails"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "7a474f8f-7ca2-4c91-aff3-b69ecce19677",
"name": "Obtener Fecha Máxima",
"type": "n8n-nodes-base.summarize",
"position": [
-96,
-1216
],
"parameters": {
"options": {},
"fieldsToSummarize": {
"values": [
{
"field": "datetime",
"aggregation": "max"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "0a1d33af-d580-4753-af4c-aba65f7c623f",
"name": "Combinar",
"type": "n8n-nodes-base.merge",
"position": [
272,
-1264
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineAll"
},
"typeVersion": 3.2
},
{
"id": "2bc48807-0c03-4cac-ad18-60b99e7dc6aa",
"name": "Obtener mensajes nuevos",
"type": "n8n-nodes-base.gmail",
"position": [
272,
-976
],
"webhookId": "65ed2723-9363-4e24-a4a6-f3aba4e2c69d",
"parameters": {
"simple": false,
"filters": {
"receivedAfter": "={{ $json.max_datetime }}"
},
"options": {},
"operation": "getAll",
"returnAll": true
},
"credentials": {
"gmailOAuth2": {
"id": "Kk42lZeRBQx5U4HR",
"name": "Gmail account"
}
},
"typeVersion": 2.1
}
],
"pinData": {},
"connections": {
"0a1d33af-d580-4753-af4c-aba65f7c623f": {
"main": [
[
{
"node": "2bc48807-0c03-4cac-ad18-60b99e7dc6aa",
"type": "main",
"index": 0
}
]
]
},
"7a474f8f-7ca2-4c91-aff3-b69ecce19677": {
"main": [
[
{
"node": "0a1d33af-d580-4753-af4c-aba65f7c623f",
"type": "main",
"index": 0
}
]
]
},
"7fed2ca3-3b0e-4cd9-89e1-364e21e1e67d": {
"main": [
[
{
"node": "0a1d33af-d580-4753-af4c-aba65f7c623f",
"type": "main",
"index": 1
}
]
]
},
"2bc48807-0c03-4cac-ad18-60b99e7dc6aa": {
"main": [
[
{
"node": "89e5ccfd-b798-427d-a3fb-e1c71e408076",
"type": "main",
"index": 0
}
]
]
},
"57a1dc13-b00a-496c-b121-1b56444fc878": {
"main": [
[
{
"node": "7a474f8f-7ca2-4c91-aff3-b69ecce19677",
"type": "main",
"index": 0
}
]
]
},
"89e5ccfd-b798-427d-a3fb-e1c71e408076": {
"main": [
[]
]
},
"ab1b7d2d-7eac-45eb-9e0a-36f14c56df14": {
"main": [
[
{
"node": "7fed2ca3-3b0e-4cd9-89e1-364e21e1e67d",
"type": "main",
"index": 0
},
{
"node": "57a1dc13-b00a-496c-b121-1b56444fc878",
"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?
Intermedio - CRM, IA Multimodal
¿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 informes de ROI de campañas de marketing usando Google Sheets, GPT-4o y correo electrónico
Usar Google Sheets, GPT-4o y correo electrónico para generar informes de ROI de campañas de marketing
Code
Merge
Aggregate
+
Code
Merge
Aggregate
16 NodosRobert Breen
Resumen de IA
Generar informes de marketing desde Google Sheets usando GPT-4 y PDF.co
Usar GPT-4 insights y PDF.co para generar informes de marketing a partir de Google Sheets
Code
Merge
Aggregate
+
Code
Merge
Aggregate
15 NodosRobert Breen
Extracción de documentos
Generación de publicaciones para LinkedIn con IA y aprobación humana
Utiliza GPT-4, GoToHuman y Blotato para generar publicaciones de LinkedIn con aprobación humana
Code
Merge
Filter
+
Code
Merge
Filter
19 NodosRobert Breen
Redes sociales
Agregación de datos de gasto de marketing en Google Sheets usando tablas dinámicas personalizadas y VLOOKUP
Agregación de datos de gastos de marketing usando tablas dinámicas personalizadas y VLOOKUP en Google Sheets
Merge
Summarize
Google Sheets
+
Merge
Summarize
Google Sheets
10 NodosRobert Breen
Extracción de documentos
Informe automatizado de rendimiento de marketing por correo electrónico
Generación automatizada de informes de rendimiento de marketing por correo electrónico usando Google Sheets y Outlook
Merge
Summarize
Google Sheets
+
Merge
Summarize
Google Sheets
13 NodosRobert Breen
Extracción de documentos
Crear libros de Excel de varias hojas usando Google Drive y Sheets mediante la fusión de conjuntos de datos
Crear libros de Excel de varias hojas usando Google Drive y Sheets mediante la fusión de conjuntos de datos
Code
Merge
Google Drive
+
Code
Merge
Google Drive
12 NodosRobert Breen
Extracción de documentos
Información del flujo de trabajo
Nivel de dificultad
Intermedio
Número de nodos11
Categoría2
Tipos de nodos7
Descripción de la dificultad
Autor
Robert Breen
@rbreenProfessional services consultant with over 10 years of experience solving complex business problems across industries. I specialize in n8n and process automation—designing custom workflows that integrate tools like Google Calendar, Airtable, GPT, and internal systems. Whether you need to automate scheduling, sync data, or streamline operations, I build solutions that save time and drive results.
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo