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": "## 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": "데이터와 대화하기",
      "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. 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": "메모8",
      "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": "메모9",
      "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": "메모10",
      "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": "데이터와 채팅하기",
      "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": ""
      },
      "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
          }
        ]
      ]
    }
  }
}