8
n8n Españolamn8n.com

Análisis de datos para principiantes: fusionar, filtrar y resumir en Google Sheets con GPT-4o

Avanzado

Este es unDocument Extraction, AI Summarizationflujo de automatización del dominio deautomatización que contiene 21 nodos.Utiliza principalmente nodos como If, Set, Code, Merge, Filter. Análisis de datos para principiantes: fusionar, filtrar y resumir en Google Sheets con GPT-4o

Requisitos previos
  • •Credenciales de API de Google Sheets
  • •Clave de API de OpenAI

Nodos utilizados (21)

If
Set
Code
Merge
Filter
Summarize
StickyNote
GoogleSheets
ManualTrigger
Agent
LmChatOpenAi
OutputParserStructured

Categoría

Extracción de documentos
Resumen de IA
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
React Flow
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
  "meta": {
    "instanceId": "efb474b59b0341d7791932605bd9ff04a6c7ed9941fdd53dc4a2e4b99a6f9439",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "a241764c-eb51-4d7a-b5d4-3aa517a9195f",
      "name": "Google Sheets1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -160,
        280
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 173686600,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19aUQYZq02qHsCelO4eeV4sx_MTJJupC5qe0gDLQBtRA/edit#gid=173686600",
          "cachedResultName": "Sheet2"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "19aUQYZq02qHsCelO4eeV4sx_MTJJupC5qe0gDLQBtRA",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19aUQYZq02qHsCelO4eeV4sx_MTJJupC5qe0gDLQBtRA/edit?usp=drivesdk",
          "cachedResultName": "Sample Marketing Data"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "WsgMg14OYooIdvn7",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "d7b9ee1a-f87d-42f6-b480-8ee687612f33",
      "name": "Filtrar",
      "type": "n8n-nodes-base.filter",
      "position": [
        340,
        120
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "65acf956-5912-4070-8896-923b74548a5e",
              "operator": {
                "type": "number",
                "operation": "gte"
              },
              "leftValue": "={{ $json.Clicks }}",
              "rightValue": 5
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "872dd275-ca9a-4d30-8ac1-e1e921f5e6fd",
      "name": "Convertir nombres de tabla y columnas en texto único para el agente",
      "type": "n8n-nodes-base.code",
      "position": [
        1380,
        280
      ],
      "parameters": {
        "jsCode": "return [\n  {\n    json: {\n      text: items.map(item => JSON.stringify(item.json)).join('\\n'),\n    },\n  },\n];\n"
      },
      "typeVersion": 2
    },
    {
      "id": "4b8595d1-d975-49f6-bff0-265aef52042f",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1620,
        500
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "ghJTvay8CvwXDsXz",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "c83d8a13-b2da-42f5-b137-763fa06e22e4",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1800,
        500
      ],
      "parameters": {
        "jsonSchemaExample": "{\n\t\"paragraph\": \"full paragraph\"\n}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "c1ad3e75-1964-4f3b-b60c-a9531f8770f7",
      "name": "Nota Adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -440,
        -200
      ],
      "parameters": {
        "width": 700,
        "height": 880,
        "content": "### 📌 Merge Multiple Datasets\n\nPull two Google Sheets:\n\n- **Marketing data** (performance metrics)  \n- **Leader assignment** (who manages each channel)\n\nThen merge the two sheets based on the **Channel** field.\n\n---\n"
      },
      "typeVersion": 1
    },
    {
      "id": "9de427fa-c2e0-4de0-8e7b-35d4566f3d6e",
      "name": "Nota Adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        280,
        -200
      ],
      "parameters": {
        "color": 5,
        "width": 380,
        "height": 880,
        "content": "\n### 📌 Filter and If Steps\n\n**Step 1:** Filter records with **Clicks ≥ 5**  \n**Step 2:** Branch logic:\n\n- If **Spend ≥ 350** → `\"Great\"` outcome  \n- Else → `\"Poor\"` outcome\n\n---"
      },
      "typeVersion": 1
    },
    {
      "id": "8aa28836-07db-42f7-b2da-0b2e656e92c7",
      "name": "Nota Adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        680,
        -200
      ],
      "parameters": {
        "color": 3,
        "width": 380,
        "height": 880,
        "content": "### 📌 Summarize and Set Steps\n\nFor each branch (**Great** / **Poor**):\n\n- Count the number of rows per **Leader**  \n- Assign outcome labels  \n- Prepare fields like `Leader`, `Outcome`, and `Day count`\n\n---"
      },
      "typeVersion": 1
    },
    {
      "id": "1fb89d3c-a10e-490d-998a-42436a1d05d0",
      "name": "Nota Adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1100,
        -200
      ],
      "parameters": {
        "color": 2,
        "width": 860,
        "height": 880,
        "content": "### 📌 Analyze Results with an AI Agent\n\n- Merge both sets of labeled outcomes  \n- Convert to a readable text format  \n- Use an **AI Agent** to summarize and compare performance of leaders  \n- Output a **paragraph** that identifies the **best** and **worst** performers and **why**"
      },
      "typeVersion": 1
    },
    {
      "id": "02854b46-8baf-438e-b110-92ce4e96dd6b",
      "name": "Datos de Marketing de Ejemplo",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -160,
        80
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19aUQYZq02qHsCelO4eeV4sx_MTJJupC5qe0gDLQBtRA/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "19aUQYZq02qHsCelO4eeV4sx_MTJJupC5qe0gDLQBtRA",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/19aUQYZq02qHsCelO4eeV4sx_MTJJupC5qe0gDLQBtRA/edit?usp=drivesdk",
          "cachedResultName": "Sample Marketing Data"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "WsgMg14OYooIdvn7",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "cf5b6397-fe1a-46db-928a-5903507ef424",
      "name": "Iniciar Flujo de Trabajo",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -380,
        180
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "58039c62-8b23-4114-9e86-5502c82719ee",
      "name": "Combinar en el Campo Canal",
      "type": "n8n-nodes-base.merge",
      "position": [
        60,
        180
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "fieldsToMatchString": "Channel"
      },
      "typeVersion": 3.2
    },
    {
      "id": "7ed757ca-05b7-41af-9f70-f88b9aba4981",
      "name": "Verificar si el gasto supera $350",
      "type": "n8n-nodes-base.if",
      "position": [
        460,
        340
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "c0cba05b-63ba-420e-851a-caf2bf9b9914",
              "operator": {
                "type": "number",
                "operation": "gte"
              },
              "leftValue": "={{ $json['Spend ($)'] }}",
              "rightValue": 350
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "73aeb996-58d7-4492-a948-bc6f9f92cb46",
      "name": "Contar días malos",
      "type": "n8n-nodes-base.summarize",
      "position": [
        740,
        100
      ],
      "parameters": {
        "options": {},
        "fieldsToSplitBy": "Leader",
        "fieldsToSummarize": {
          "values": [
            {
              "field": "row_number"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "af21446e-d779-4937-bee4-d650dccd8f32",
      "name": "Contar días buenos",
      "type": "n8n-nodes-base.summarize",
      "position": [
        760,
        300
      ],
      "parameters": {
        "options": {},
        "fieldsToSplitBy": "Leader",
        "fieldsToSummarize": {
          "values": [
            {
              "field": "row_number"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "9b6bb3eb-aae2-4317-8551-78fb81312765",
      "name": "Organizar campos en una tabla",
      "type": "n8n-nodes-base.set",
      "position": [
        920,
        120
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "e2f52c05-13a5-4692-bbea-87642535145e",
              "name": "Outcome",
              "type": "string",
              "value": "Poor"
            },
            {
              "id": "8c353e0a-409f-4cff-a1b9-17259cc3a1dd",
              "name": "# of Days",
              "type": "number",
              "value": "={{ $json.count_row_number }}"
            },
            {
              "id": "82d2f8dd-54b8-42c8-b502-6ae1fc76e1fe",
              "name": "Leader",
              "type": "string",
              "value": "={{ $json.Leader }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "b5780191-2068-4595-b18c-16626003145d",
      "name": "Organizar segundo conjunto de datos en una tabla",
      "type": "n8n-nodes-base.set",
      "position": [
        920,
        320
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "f3f79a06-acb9-4b89-a7ab-438358b4395e",
              "name": "Outcome",
              "type": "string",
              "value": "Great"
            },
            {
              "id": "e79913fa-a2ec-459c-a00d-df23bb1a2a25",
              "name": "# of Days",
              "type": "number",
              "value": "={{ $json.count_row_number }}"
            },
            {
              "id": "a6b563e3-0776-4916-a9f3-05d38a67330a",
              "name": "Leader",
              "type": "string",
              "value": "={{ $json.Leader }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "097dc227-3999-427c-9900-008845b00131",
      "name": "Unir fuentes de datos",
      "type": "n8n-nodes-base.merge",
      "position": [
        1180,
        220
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "1ec5183b-be3f-447a-b312-56420ac5c706",
      "name": "Agente de IA - Resumir Rendimiento del Líder",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1600,
        180
      ],
      "parameters": {
        "text": "={{ $json.text }}",
        "options": {
          "systemMessage": "You are given a list of outcomes by leader. write a summary of the outcomes and identify who is doing the best and worst, and why. \n\noutput as one paragraph. \n\nOutput like this. \n\n{\n\t\"paragraph\": \"full paragraph\"\n}"
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2
    },
    {
      "id": "0a53ca1a-53f0-4d68-b70f-e5fff251af5f",
      "name": "Nota Adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -440,
        -400
      ],
      "parameters": {
        "color": 4,
        "width": 1100,
        "content": "### 📌 Setup Instructions\n\nBefore running the workflow:\n\n1. **Copy the sample Google Sheet**  \n   [Click here to copy the Google Sheet](https://docs.google.com/spreadsheets/d/19aUQYZq02qHsCelO4eeV4sx_MTJJupC5qe0gDLQBtRA/copy)\n\n2. **Connect Google Sheets API**  \n   - In n8n, go to **Credentials** and create a **Google Sheets OAuth2** credential.\n   - Make sure to authorize access to the copied spreadsheet.\n\n3. **Add your OpenAI API Key**  \n   - In the **AI Agent** step, connect your **OpenAI credential** using your API key.\n\n---"
      },
      "typeVersion": 1
    },
    {
      "id": "4dffd2eb-9a06-4103-97a5-47aeccdca95c",
      "name": "Nota Adhesiva5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        680,
        -400
      ],
      "parameters": {
        "color": 2,
        "width": 1280,
        "content": "### 👋 Questions or Feedback?\nFeel free to reach out — I’m happy to help!\n**Robert Breen**  \nFounder, Ynteractive  \n🌐 [ynteractive.com](https://ynteractive.com)  \n📧 robert@ynteractive.com  \n🔗 [LinkedIn: linkedin.com/in/robertbreen](https://www.linkedin.com/in/robertbreen)"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "d7b9ee1a-f87d-42f6-b480-8ee687612f33": {
      "main": [
        [
          {
            "node": "7ed757ca-05b7-41af-9f70-f88b9aba4981",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "73aeb996-58d7-4492-a948-bc6f9f92cb46": {
      "main": [
        [
          {
            "node": "9b6bb3eb-aae2-4317-8551-78fb81312765",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a241764c-eb51-4d7a-b5d4-3aa517a9195f": {
      "main": [
        [
          {
            "node": "58039c62-8b23-4114-9e86-5502c82719ee",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "cf5b6397-fe1a-46db-928a-5903507ef424": {
      "main": [
        [
          {
            "node": "02854b46-8baf-438e-b110-92ce4e96dd6b",
            "type": "main",
            "index": 0
          },
          {
            "node": "a241764c-eb51-4d7a-b5d4-3aa517a9195f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "af21446e-d779-4937-bee4-d650dccd8f32": {
      "main": [
        [
          {
            "node": "b5780191-2068-4595-b18c-16626003145d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4b8595d1-d975-49f6-bff0-265aef52042f": {
      "ai_languageModel": [
        [
          {
            "node": "1ec5183b-be3f-447a-b312-56420ac5c706",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "02854b46-8baf-438e-b110-92ce4e96dd6b": {
      "main": [
        [
          {
            "node": "58039c62-8b23-4114-9e86-5502c82719ee",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "58039c62-8b23-4114-9e86-5502c82719ee": {
      "main": [
        [
          {
            "node": "d7b9ee1a-f87d-42f6-b480-8ee687612f33",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7ed757ca-05b7-41af-9f70-f88b9aba4981": {
      "main": [
        [
          {
            "node": "73aeb996-58d7-4492-a948-bc6f9f92cb46",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "af21446e-d779-4937-bee4-d650dccd8f32",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c83d8a13-b2da-42f5-b137-763fa06e22e4": {
      "ai_outputParser": [
        [
          {
            "node": "1ec5183b-be3f-447a-b312-56420ac5c706",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "9b6bb3eb-aae2-4317-8551-78fb81312765": {
      "main": [
        [
          {
            "node": "097dc227-3999-427c-9900-008845b00131",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "097dc227-3999-427c-9900-008845b00131": {
      "main": [
        [
          {
            "node": "872dd275-ca9a-4d30-8ac1-e1e921f5e6fd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b5780191-2068-4595-b18c-16626003145d": {
      "main": [
        [
          {
            "node": "097dc227-3999-427c-9900-008845b00131",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "1ec5183b-be3f-447a-b312-56420ac5c706": {
      "main": [
        []
      ]
    },
    "872dd275-ca9a-4d30-8ac1-e1e921f5e6fd": {
      "main": [
        [
          {
            "node": "1ec5183b-be3f-447a-b312-56420ac5c706",
            "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 - Extracción de documentos, Resumen de IA

¿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

Extraer contactos de empresas locales con Google Sheets, SerpAPI, Apify y GPT-4o
Extraer contactos de empresas locales usando Google Sheets, SerpAPI, Apify y GPT-4o
Code
Filter
Summarize
+
Code
Filter
Summarize
18 NodosRobert Breen
Generación de leads
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
Grabador de notas de podcast
Crear guiones de anuncios de Meta de alta tasa de conversión utilizando datos de rendimiento combinados de GPT y Gemini
Set
Code
Merge
+
Set
Code
Merge
24 NodosRobert Breen
Extracción de documentos
Explorar nodos de n8n en la biblioteca de referencias visuales
Explorar nodos de n8n en la base de referencia visual
If
Ftp
Set
+
If
Ftp
Set
113 NodosI versus AI
Otros
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
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos21
Categoría2
Tipos de nodos12
Descripción de la dificultad

Adecuado para usuarios avanzados, flujos de trabajo complejos con 16+ nodos

Autor
Robert Breen

Robert Breen

@rbreen

Professional 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

Categorías

IA Multimodal
1540
Inteligencia Artificial
1108
Creación de contenido
695
Resumen de IA
516
Marketing
419
Chatbot de IA
251
Ingeniería
241
Investigación de mercado
203
Varios
193
Otros
176
Ventas
162
Operaciones de TI
156
Extracción de documentos
147
RAG de IA
146
Bloques de construcción
144
Redes sociales
137
Generación de leads
125
Productividad personal
117
DevOps
111
Recursos Humanos
101
Soporte
97
Nutrición de leads
87
CRM
82
Finanzas
81
Producto
77
Chatbot de soporte
76
Diseño
70
Gestión de tickets
67
Operaciones de seguridad
57
Procesamiento de facturas
53
Comercio de criptomonedas
49
Gestión de archivos
39
Gestión de proyectos
35
Wiki interno
32

Categorías: 34