Análisis de datos conversacional en Google Sheets basado en GPT-5 Mini

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

{
  "meta": {
    "instanceId": "a2eaba9e45ad7aab18b25cf863df1e910fb6dd3b85279bde97d9bae4a72f6862",
    "templateId": "7449"
  },
  "nodes": [
    {
      "id": "cee2b611-5d08-4328-9c51-096bc979b6f7",
      "name": "Analizar Datos",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        768,
        1776
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 365710158,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit#gid=365710158",
          "cachedResultName": "Data"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit?usp=drivesdk",
          "cachedResultName": "Sample Marketing Data - n8n"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "8a231798-9b25-457d-a9cd-f4e6286958bb",
      "name": "Modelo de chat OpenAI",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        208,
        1760
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-nano",
          "cachedResultName": "gpt-4.1-nano"
        },
        "options": {}
      },
      "typeVersion": 1.2
    },
    {
      "id": "05badec7-f61b-4492-9fd2-6e571ed12541",
      "name": "Nota Adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        864
      ],
      "parameters": {
        "color": 7,
        "width": 1152,
        "height": 1168,
        "content": "## Talk to Your Data with Google Sheets & OpenAI GPT-5 Mini\nThis n8n workflow template creates an intelligent data analysis chatbot that can answer questions about data stored in Google Sheets using OpenAI's GPT-5 Mini model. The system automatically analyzes your spreadsheet data and provides insights through natural language conversations.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "3abf3803-0403-4ea1-ac66-373b6821c2a1",
      "name": "Habla con Tus Datos",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        688,
        1136
      ],
      "parameters": {
        "options": {
          "systemMessage": "Google Sheets Ask-Data \n\n\nYou are Ask-Data. Answer questions using Google Sheets ONLY via the tool below. Be precise and conservative. \n\nThere is only one dataset. dont ask what dataset it is. \n\nUse the data tool to answer the question."
        },
        "hasOutputParser": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "7736cb8c-0508-4bb5-a92a-850922e00f41",
      "name": "Nota Adhesiva7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        1024
      ],
      "parameters": {
        "color": 7,
        "width": 480,
        "height": 432,
        "content": "### 3. Ask Questions of Your Data\n\nYou can ask natural language questions to analyze your marketing data, such as:\n- **Total spend** across all campaigns.\n- **Spend for Paid Search only**.\n- **Month-over-month changes** in ad spend.\n- **Top-performing campaigns** by conversion rate.\n- **Cost per lead** for each channel."
      },
      "typeVersion": 1
    },
    {
      "id": "dc761ff8-ef7b-4535-989b-7d03886bd70c",
      "name": "Nota Adhesiva8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -608,
        864
      ],
      "parameters": {
        "width": 528,
        "height": 1168,
        "content": "## 🎥 Watch This Tutorial\n\n@[youtube](qsrVPdo6svc)\n\n\n### 1. Set Up OpenAI Connection\n\n#### Get Your API Key\n1. Visit the [OpenAI API Keys](https://platform.openai.com/api-keys) page.\n2. Go to [OpenAI Billing](https://platform.openai.com/settings/organization/billing/overview).\n3. Add funds to your billing account.\n4. Copy your API key into your **OpenAI credentials** in n8n (or your chosen platform).\n\n---\n### 2. Prepare Your Google Sheet\n\n#### Connect Your Data in Google Sheets\n- Data must follow this format: [Sample Marketing Data](https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit?gid=365710158#gid=365710158)\n- **First row** contains column names.\n- Data should be in **rows 2–100**.\n- Log in using **OAuth**, then select your workbook and sheet.\n\n---\n### 3. Ask Questions of Your Data\n\nYou can ask natural language questions to analyze your marketing data, such as:\n- **Total spend** across all campaigns.\n- **Spend for Paid Search only**.\n- **Month-over-month changes** in ad spend.\n- **Top-performing campaigns** by conversion rate.\n- **Cost per lead** for each channel.\n\n---\n## 📬 Need Help or Want to Customize This?\n📧 [robert@ynteractive.com](mailto:robert@ynteractive.com)  \n🔗 [LinkedIn](https://www.linkedin.com/in/robert-breen-29429625/)\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "4137e8dc-aab2-486f-bf23-4a129f5f8241",
      "name": "Nota Adhesiva9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        1504
      ],
      "parameters": {
        "color": 3,
        "width": 480,
        "height": 432,
        "content": "### 1. Set Up OpenAI Connection\n\n#### Get API Key:\n1. Go to [OpenAI Platform](https://platform.openai.com/api-keys)\n1. Go to [OpenAI Billing](https://platform.openai.com/settings/organization/billing/overview)\n2. Add funds to your billing account & copy your api key into the openAI credentials\n"
      },
      "typeVersion": 1
    },
    {
      "id": "4c4db6fc-6973-4bb9-8dbd-c02086c25c47",
      "name": "Nota Adhesiva10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        544,
        1504
      ],
      "parameters": {
        "color": 3,
        "width": 512,
        "height": 432,
        "content": "### 2. Prepare Your Google Sheet\n\n#### Connect your Data in Google Sheets\n- Data must be in a format similar to this: [Sample Marketing Data](https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit?gid=365710158#gid=365710158)\n- First row contains column names\n- Data in rows 2-100\n- Log in with OAuth2 and choose your workbook and sheet\n- Optional: Try connecting to Airtable, Notion or your Database"
      },
      "typeVersion": 1
    },
    {
      "id": "75869f50-156d-4723-a128-204c29f1b49d",
      "name": "Chatea con Tus Datos",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        176,
        1296
      ],
      "webhookId": "edca0f0a-77c3-43e5-8ece-e514a29446f5",
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.3
    },
    {
      "id": "81eb1883-633a-4c09-b78c-2999dc9c60be",
      "name": "Memoria",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        720,
        1328
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "bcf7f68a-0ce7-4a8f-9eed-a2cc5cb9124a",
      "name": "Nota Adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        544,
        1024
      ],
      "parameters": {
        "color": 7,
        "width": 512,
        "height": 432,
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "81eb1883-633a-4c09-b78c-2999dc9c60be": {
      "ai_memory": [
        [
          {
            "node": "3abf3803-0403-4ea1-ac66-373b6821c2a1",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "cee2b611-5d08-4328-9c51-096bc979b6f7": {
      "ai_tool": [
        [
          {
            "node": "3abf3803-0403-4ea1-ac66-373b6821c2a1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "3abf3803-0403-4ea1-ac66-373b6821c2a1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "75869f50-156d-4723-a128-204c29f1b49d": {
      "main": [
        [
          {
            "node": "3abf3803-0403-4ea1-ac66-373b6821c2a1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}