Agregación de datos de gasto de marketing en Google Sheets usando tablas dinámicas personalizadas y VLOOKUP
Intermedio
Este es unDocument Extraction, Multimodal AIflujo de automatización del dominio deautomatización que contiene 10 nodos.Utiliza principalmente nodos como Merge, Summarize, GoogleSheets, ManualTrigger. Agregación de datos de gastos de marketing usando tablas dinámicas personalizadas y VLOOKUP en Google Sheets
Requisitos previos
- •Credenciales de API de Google Sheets
Nodos utilizados (10)
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": "5432b2ed-adde-4021-b6b3-e75e43bd102c",
"name": "Al hacer clic en 'Execute workflow'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1744,
4816
],
"parameters": {},
"typeVersion": 1
},
{
"id": "20d77255-29ba-45aa-af1b-ff2b8ba91ef6",
"name": "Limpiar hoja",
"type": "n8n-nodes-base.googleSheets",
"position": [
-240,
4944
],
"parameters": {
"operation": "clear",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1235077339,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit#gid=1235077339",
"cachedResultName": "render pivot"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit?usp=drivesdk",
"cachedResultName": "Pivot Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "43298259-36ab-403d-91f8-0d0a499b6daf",
"name": "Pivotar",
"type": "n8n-nodes-base.summarize",
"position": [
-464,
5040
],
"parameters": {
"options": {},
"fieldsToSplitBy": "Name",
"fieldsToSummarize": {
"values": [
{
"field": "Spend ($)",
"aggregation": "sum"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "ea502cf7-be4a-41ac-a1e0-38f73398c95e",
"name": "Obtener datos de marketing",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1008,
4944
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit#gid=0",
"cachedResultName": "data"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit?usp=drivesdk",
"cachedResultName": "Pivot Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "896e5698-f99a-4e1b-ad4c-f5c4c07e847e",
"name": "Vlookup de datos",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1280,
5408
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 894339285,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit#gid=894339285",
"cachedResultName": "Lookup"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit?usp=drivesdk",
"cachedResultName": "Pivot Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "4178ff0a-9cbb-4eef-93d8-2a012471f0ed",
"name": "Combinar tablas (Vlookup)",
"type": "n8n-nodes-base.merge",
"position": [
-688,
5040
],
"parameters": {
"mode": "combine",
"options": {},
"fieldsToMatchString": "Channel"
},
"typeVersion": 3.2
},
{
"id": "3e622961-1081-40cd-870e-c3b0d114d3c0",
"name": "Crear tipo de 'Tabla dinámica'",
"type": "n8n-nodes-base.googleSheets",
"position": [
-224,
5152
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "sum_Spend_($)",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "sum_Spend_($)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1235077339,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit#gid=1235077339",
"cachedResultName": "render pivot"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit?usp=drivesdk",
"cachedResultName": "Pivot Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "c007458e-07ec-4b25-b898-272ce0fcde8f",
"name": "Nota adhesiva55",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1808,
4608
],
"parameters": {
"color": 7,
"width": 2144,
"height": 1056,
"content": "### Build a pivot-style marketing spend summary in Google Sheets using n8n (Merge + Summarize + Vlookup)\n\nThis workflow transforms raw marketing data from Google Sheets into a **pivot-like summary table**. It merges lookup data, groups spend by name, and appends the results into a clean reporting tab — all automatically, without needing to manually build pivot tables in Sheets.\n\n\n"
},
"typeVersion": 1
},
{
"id": "d004d740-9e2d-409a-b5df-960bd28482a7",
"name": "Nota adhesiva3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2240,
4608
],
"parameters": {
"width": 400,
"height": 1056,
"content": "\n## 🔑 Setup Instructions\n\n### 1) Connect Google Sheets (OAuth2)\n1. In **n8n → Credentials → New → Google Sheets (OAuth2)** \n2. Sign in with your Google account and grant access \n3. In each Google Sheets node, select your **Spreadsheet** and the appropriate **Worksheet**: \n - **data** (raw spend) \n - **Lookup** (channel reference table) \n - **render pivot** (output tab) \n\nhttps://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit?gid=894339285#gid=894339285\n\n## 📬 Contact \nNeed help customizing this (e.g., filtering by campaign, sending reports by email, or formatting your pivot)? \n\n- 📧 **rbreen@ynteractive.com** \n- 🔗 **[Robert Breen](https://www.linkedin.com/in/robert-breen-29429625/)** \n- 🌐 **[ynteractive.com](https://ynteractive.com)** \n"
},
"typeVersion": 1
},
{
"id": "2694e9b7-3405-4139-99bc-5ffd735f33a8",
"name": "Nota adhesiva65",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1344,
4880
],
"parameters": {
"color": 3,
"width": 224,
"height": 656,
"content": "### 1) Connect Google Sheets (OAuth2)\n1. In **n8n → Credentials → New → Google Sheets (OAuth2)** \n2. Sign in with your Google account and grant access \n3. In each Google Sheets node, select your **Spreadsheet** and the appropriate **Worksheet**: \n - **data** (raw spend) \n - **Lookup** (channel reference table) \n - **render pivot** (output tab) \n\nhttps://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit?gid=894339285#gid=894339285\n"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"43298259-36ab-403d-91f8-0d0a499b6daf": {
"main": [
[
{
"node": "20d77255-29ba-45aa-af1b-ff2b8ba91ef6",
"type": "main",
"index": 0
},
{
"node": "3e622961-1081-40cd-870e-c3b0d114d3c0",
"type": "main",
"index": 0
}
]
]
},
"896e5698-f99a-4e1b-ad4c-f5c4c07e847e": {
"main": [
[
{
"node": "4178ff0a-9cbb-4eef-93d8-2a012471f0ed",
"type": "main",
"index": 1
}
]
]
},
"ea502cf7-be4a-41ac-a1e0-38f73398c95e": {
"main": [
[
{
"node": "4178ff0a-9cbb-4eef-93d8-2a012471f0ed",
"type": "main",
"index": 0
}
]
]
},
"4178ff0a-9cbb-4eef-93d8-2a012471f0ed": {
"main": [
[
{
"node": "43298259-36ab-403d-91f8-0d0a499b6daf",
"type": "main",
"index": 0
}
]
]
},
"5432b2ed-adde-4021-b6b3-e75e43bd102c": {
"main": [
[
{
"node": "ea502cf7-be4a-41ac-a1e0-38f73398c95e",
"type": "main",
"index": 0
},
{
"node": "896e5698-f99a-4e1b-ad4c-f5c4c07e847e",
"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 - Extracción de documentos, 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
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
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
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
Análisis de datos para principiantes: fusionar, filtrar y resumir en Google Sheets con GPT-4o
Análisis de datos para principiantes: fusionar, filtrar y resumir en Google Sheets con GPT-4o
If
Set
Code
+
If
Set
Code
21 NodosRobert Breen
Extracción de documentos
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
Registrar automáticamente nuevos correos de Gmail en Google Sheets
Registrar automáticamente nuevos correos de Gmail en Google Sheets
Code
Gmail
Merge
+
Code
Gmail
Merge
11 NodosRobert Breen
CRM
Información del flujo de trabajo
Nivel de dificultad
Intermedio
Número de nodos10
Categoría2
Tipos de nodos5
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