基于 GPT-5 Mini 的 Google Sheets 对话式数据分析

• •Google Sheets API 凭证
• •OpenAI API Key

{
  "meta": {
    "instanceId": "a2eaba9e45ad7aab18b25cf863df1e910fb6dd3b85279bde97d9bae4a72f6862",
    "templateId": "7449"
  },
  "nodes": [
    {
      "id": "cee2b611-5d08-4328-9c51-096bc979b6f7",
      "name": "分析数据",
      "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": "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": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        864
      ],
      "parameters": {
        "color": 7,
        "width": 1152,
        "height": 1168,
        "content": "## 使用 Google Sheets 和 OpenAI GPT-5 Mini 与您的数据对话"
      },
      "typeVersion": 1
    },
    {
      "id": "3abf3803-0403-4ea1-ac66-373b6821c2a1",
      "name": "与您的数据对话",
      "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": "便签 7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        1024
      ],
      "parameters": {
        "color": 7,
        "width": 480,
        "height": 432,
        "content": "### 3. 向您的数据提问"
      },
      "typeVersion": 1
    },
    {
      "id": "dc761ff8-ef7b-4535-989b-7d03886bd70c",
      "name": "## 为什么选择 4o 模型？👆",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -608,
        864
      ],
      "parameters": {
        "width": 528,
        "height": 1168,
        "content": "## 🎥 观看本教程"
      },
      "typeVersion": 1
    },
    {
      "id": "4137e8dc-aab2-486f-bf23-4a129f5f8241",
      "name": "便签 9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        1504
      ],
      "parameters": {
        "color": 3,
        "width": 480,
        "height": 432,
        "content": "### 1. 设置 OpenAI 连接"
      },
      "typeVersion": 1
    },
    {
      "id": "4c4db6fc-6973-4bb9-8dbd-c02086c25c47",
      "name": "便签10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        544,
        1504
      ],
      "parameters": {
        "color": 3,
        "width": 512,
        "height": 432,
        "content": "### 2. 准备您的 Google 表格"
      },
      "typeVersion": 1
    },
    {
      "id": "75869f50-156d-4723-a128-204c29f1b49d",
      "name": "与您的数据聊天",
      "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": "记忆存储",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        720,
        1328
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "bcf7f68a-0ce7-4a8f-9eed-a2cc5cb9124a",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        544,
        1024
      ],
      "parameters": {
        "color": 7,
        "width": 512,
        "height": 432,
        "content": "Emelia 触发器"
      },
      "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
          }
        ]
      ]
    },
    "8a231798-9b25-457d-a9cd-f4e6286958bb": {
      "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
          }
        ]
      ]
    }
  }
}