This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "OpenAI Analytics \ub178\ub4dc \uc0ac\uc6a9\ubc95",
"nodes": [
{
"parameters": {},
"type": "n8n-nodes-base.manualTrigger",
"typeVersion": 1,
"position": [
-120,
0
],
"id": "7a33aa81-6fc5-4f6f-8065-bfd0dc76d11c",
"name": "When clicking \u2018Test workflow\u2019"
},
{
"parameters": {
"method": "POST",
"url": "https://api.openai.com/v1/responses",
"authentication": "predefinedCredentialType",
"nodeCredentialType": "openAiApi",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer $OPENAI_API_KEY"
}
]
},
"sendBody": true,
"specifyBody": "json",
"jsonBody": "{\n \"model\": \"gpt-4.1\",\n \"input\": [\n {\n \"role\": \"system\",\n \"content\": [\n {\n \"type\": \"input_text\",\n \"text\": \"\ub108\ub294 \uc0ac\uc6a9\uc790\uac00 \ud0a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uba74 \ud574\ub2f9 \uc815\ubcf4\uc758 \uc6f9\uc815\ubcf4\ub97c \uac80\uc0c9\ud558\uc5ec \ucd5c\uc2e0 \ud2b8\ub80c\ub4dc \ud55c\uc904 \uc694\uc57d\uacfc \ud575\uc2ec\ud0a4\uc6cc\ub4dc\uc640 \uac80\uc0c9\ub7c9\uc744 json \ub808\ucf54\ub4dc\ub85c \ucd9c\ub825\ud558\ub294 \ube44\uc11c\uc57c. \uc544\ub798 json \uc591\uc2dd\uc5d0 \ub9de\ucdb0 \uc751\ub2f5\ud574\uc918.\\n\\n* json \uc751\ub2f5 \ud615\uc2dd (\uc608\uc2dc)\\n{\\n \\\"trend_summary\\\" : \\\"....\\\", # \ucd5c\uc2e0\ud2b8\ub80c\ub4dc \uc694\uc57d 200\uc790 \ub0b4\uc678\\n \\\"keywords\\\" : { # \ud575\uc2ec\ud0a4\uc6cc\ub4dc (\uac80\uc0c9\ub7c9)\\n \\\"\ud0a4\uc6cc\ub4dc1\\\" : 10, \\n \\\"\ud0a4\uc6cc\ub4dc2\\\": 20,\\n ...\\n }\\n}\"\n }\n ]\n },\n {\n \"role\": \"user\",\n \"content\": [\n {\n \"type\": \"input_text\",\n \"text\": \"AI \uc790\ub3d9\ud654 \ud2b8\ub80c\ub4dc\"\n }\n ]\n }\n ],\n \"text\": {\n \"format\": {\n \"type\": \"text\"\n }\n },\n \"reasoning\": {},\n \"tools\": [\n {\n \"type\": \"web_search_preview\",\n \"user_location\": {\n \"type\": \"approximate\",\n \"country\": \"KR\"\n },\n \"search_context_size\": \"high\"\n }\n ],\n \"temperature\": 1,\n \"max_output_tokens\": 2048,\n \"top_p\": 1,\n \"store\": true\n}",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
280,
-340
],
"id": "e6adbe56-521c-4333-b107-12742558bb07",
"name": "HTTP Request",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"disabled": true
},
{
"parameters": {
"content": "## Responses API + Json Parse + Quick Chat \uc2dc\uac01\ud654",
"height": 260,
"width": 800
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
180,
-400
],
"id": "1823f0ce-98df-4910-89c6-66b83d26ca00",
"name": "Sticky Note",
"disabled": true
},
{
"parameters": {
"labelsMode": "array",
"labelsArray": "={{ $json.parsed_result.keywords.keys() }}",
"data": "={{ $json.data.keywords.values() }}",
"chartOptions": {
"backgroundColor": "#ffffff"
},
"datasetOptions": {
"backgroundColor": "#505aec"
}
},
"type": "n8n-nodes-base.quickChart",
"typeVersion": 1,
"position": [
720,
-340
],
"id": "6362de06-6d19-45a5-a0c6-fe5c61adc196",
"name": "QuickChart",
"disabled": true
},
{
"parameters": {
"authentication": "openAiApi",
"resource": "text",
"jsonInput": "={{ $json.output[1].content[0].text }}"
},
"type": "n8n-nodes-openai-analytics.openAIAnalytics",
"typeVersion": 1,
"position": [
500,
-340
],
"id": "2e167ca1-d3dd-4a3d-8d59-2ff7507b95db",
"name": "JSON \ud30c\uc2f1",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"disabled": true
},
{
"parameters": {
"authentication": "openAiApi",
"resource": "embedding",
"inputType": "multipleTexts",
"texts": [
"n8n",
"automation"
],
"options": {}
},
"type": "n8n-nodes-openai-analytics.openAIAnalytics",
"typeVersion": 1,
"position": [
280,
-40
],
"id": "cbd16efa-f7ae-4659-9d46-d970c97b90e0",
"name": "\ub2e8\uc5b4 \uc784\ubca0\ub529",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"disabled": true
},
{
"parameters": {
"content": "## \ud14d\uc2a4\ud2b8 \uc784\ubca0\ub529\uacfc \uc720\uc0ac\ub3c4 \uacc4\uc0b0",
"height": 260,
"width": 800
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
180,
-100
],
"id": "03e0350b-c074-4830-87cb-21c4cdbe20fd",
"name": "Sticky Note1",
"disabled": true
},
{
"parameters": {
"authentication": "openAiApi",
"resource": "embedding",
"operation": "embeddingBasedClassify",
"embeddingTargetText": "\ucd95\uad6c\ub294 \uc778\uae30\uc788\ub294 \uc2a4\ud3ec\uce20\uc785\ub2c8\ub2e4.",
"embeddingCategoriesMode": "saved",
"embeddingCategories": {
"values": [
{
"category": "\uad6d\uc5b4"
},
{
"category": "\uc601\uc5b4"
},
{
"category": "\uc218\ud559"
},
{
"category": "\uccb4\uc721"
}
]
},
"embeddingThreshold": 0.1
},
"type": "n8n-nodes-openai-analytics.openAIAnalytics",
"typeVersion": 1,
"position": [
540,
280
],
"id": "69aa4faf-98d4-4eb3-959c-0ec6686f093f",
"name": "\uc784\ubca0\ub529 \uae30\ubc18 \uce74\ud14c\uace0\ub77c\uc774\uc9d5",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"disabled": true
},
{
"parameters": {
"authentication": "openAiApi",
"resource": "embedding",
"operation": "llmBasedClassify",
"llmTargetText": "\ucd95\uad6c\ub294 \uc778\uae30\uc788\ub294 \uc2a4\ud3ec\uce20\uc785\ub2c8\ub2e4.",
"llmCategories": {
"values": [
{
"category": "\uad6d\uc5b4"
},
{
"category": "\uc601\uc5b4"
},
{
"category": "\uc218\ud559"
},
{
"category": "\uccb4\uc721"
}
]
}
},
"type": "n8n-nodes-openai-analytics.openAIAnalytics",
"typeVersion": 1,
"position": [
280,
280
],
"id": "11362636-c75b-4154-b975-3cd5fe3af2ea",
"name": "\uc5b8\uc5b4\ubaa8\ub378 \uae30\ubc18 \uce74\ud14c\uace0\ub77c\uc774\uc9d5",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"disabled": true
},
{
"parameters": {
"content": "## \ud14d\uc2a4\ud2b8 \ub370\uc774\ud130 \ubd84\ub958 (\uce74\ud14c\uace0\ub77c\uc774\uc9d5)",
"height": 260,
"width": 1660
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
180,
200
],
"id": "06da1827-987a-4f22-84ce-07388b245fef",
"name": "Sticky Note2",
"disabled": true
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1EAm3rTmvNl4ZRQkdYovUdfIYrrtseUr2dJlEihCISfI",
"mode": "list",
"cachedResultName": "\uc0c1\ud488 \ub9ac\ubdf0 DB",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAm3rTmvNl4ZRQkdYovUdfIYrrtseUr2dJlEihCISfI/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 1509395186,
"mode": "list",
"cachedResultName": "7416052718",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAm3rTmvNl4ZRQkdYovUdfIYrrtseUr2dJlEihCISfI/edit#gid=1509395186"
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
780,
280
],
"id": "72924f5a-784e-48ba-a956-a71c2667edc1",
"name": "Google Sheets",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"disabled": true
},
{
"parameters": {
"authentication": "openAiApi",
"resource": "embedding",
"operation": "embeddingBasedClassify",
"embeddingTargetText": "={{ $json.review }}",
"embeddingCategories": {
"values": [
{
"category": "\ubc30\uc1a1"
},
{
"category": "\uac00\uaca9"
},
{
"category": "\ud488\uc9c8"
},
{
"category": "\uae30\ud0c0\uc0ac\ud56d"
}
]
},
"embeddingThreshold": 0.1
},
"type": "n8n-nodes-openai-analytics.openAIAnalytics",
"typeVersion": 1,
"position": [
1000,
280
],
"id": "a943421c-2590-41cf-a785-5b0197cd673b",
"name": "OpenAI Analytics1",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"disabled": true
},
{
"parameters": {
"labelsMode": "array",
"labelsArray": "={{ $json.keys() }}",
"data": "={{ $json.values().map(e => e[\"count_category\"]) }}",
"chartOptions": {
"backgroundColor": "#ffffff"
},
"datasetOptions": {
"label": "\ub9ac\ubdf0\ubd84\uc11d"
}
},
"type": "n8n-nodes-base.quickChart",
"typeVersion": 1,
"position": [
1500,
280
],
"id": "c4ee6e49-43ac-4e49-93f7-80a059d61d6c",
"name": "QuickChart1",
"disabled": true
},
{
"parameters": {
"fieldsToSummarize": {
"values": [
{
"field": "=category"
}
]
},
"fieldsToSplitBy": "category",
"options": {
"outputFormat": "singleItem"
}
},
"type": "n8n-nodes-base.summarize",
"typeVersion": 1.1,
"position": [
1260,
280
],
"id": "997b918f-e77a-4ddf-9b2d-205afc2192e8",
"name": "Summarize",
"disabled": true
},
{
"parameters": {
"content": "## \ub808\ud3ec\ud2b8 \uc0dd\uc131",
"height": 260,
"width": 800
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
180,
500
],
"id": "25372dd2-a26f-45e8-b24e-705ca01815ca",
"name": "Sticky Note3",
"disabled": true
},
{
"parameters": {
"authentication": "openAiApi",
"resource": "report",
"reportInputText": "\uc774\ub178\ubc14\uc778\ucf54\ub9ac\uc544\u2219\uc11c\uc6b8 \uac15\ub0a8\uad6c\u2219\uacbd\ub825 1\ub144\n\n\n\n[\uc560\ub4dc\ud06c\ub798\ud504\ud2b8] \ud37c\ud3ec\uba3c\uc2a4 \ub9c8\ucf00\ud130\n\ud3ec\uc9c0\uc158 \uc0c1\uc138\n[\uc560\ub4dc\ud06c\ub798\ud504\ud2b8 \uc18c\uac1c]\n\uc560\ub4dc\ud06c\ub798\ud504\ud2b8\ub294 \uc774\ub178\ubc14\uc778\ucf54\ub9ac\uc544\uc758 \uc778\ud558\uc6b0\uc2a4 \uad11\uace0 \ub300\ud589\uc0ac\ub85c, \ud6a8\uc728\uc801\uc774\uace0 \ucc3d\uc758\uc801\uc778 \uad11\uace0 \ucee8\uc124\ud305\uc744 \ud1b5\ud574 \ube0c\ub79c\ub4dc \uac00\uce58\ub97c \uadf9\ub300\ud654\ud558\ub294 \uac83\uc744 \ubaa9\ud45c\ub85c \ud558\uace0 \uc788\uc5b4\uc694.\n\n\uc6b0\ub9ac\ub294 \ub370\uc774\ud130 \uae30\ubc18\uc758 \ub9c8\ucf00\ud305 \uc804\ub7b5\uacfc \ucc3d\uc758\uc801\uc778 \ud06c\ub9ac\uc5d0\uc774\ud2f0\ube0c \uc81c\uc791\uc744 \ubc14\ud0d5\uc73c\ub85c, \ube60\ub974\uac8c \ubcc0\ud654\ud558\ub294 \uad11\uace0 \uc2dc\uc7a5\uc5d0\uc11c \ub3c5\ubcf4\uc801\uc778 \uc131\uacfc\ub97c \ucc3d\ucd9c\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ud2b9\ud788, \uc81c\ub204 \ub2e8\ubc31\uc9c8 \ucee4\ud53c\uc640 \uac19\uc740 \ube0c\ub79c\ub4dc\uc758 \uc131\uacf5\uc801\uc778 \ucea0\ud398\uc778\uc744 \ud1b5\ud574 \uad11\uace0 \uc5c5\uacc4\uc758 \uc8fc\ubaa9\uc744 \ubc1b\uace0 \uc788\uc73c\uba70, TV \uad11\uace0, \ub514\uc9c0\ud138 \ucf58\ud150\uce20, \ube0c\ub79c\ub529 \uc804\ub7b5\uae4c\uc9c0 \ub2e4\uc591\ud55c \ubd84\uc57c\uc5d0\uc11c \uc804\ubb38\uc131\uc744 \ubc1c\ud718\ud558\uace0 \uc788\ub2f5\ub2c8\ub2e4.\n\n\uc774\ub7ec\ud55c \uc560\ub4dc\ud06c\ub798\ud504\ud2b8\uc5d0\uc11c \uc131\uacf5\uc801\uc778 \ucea0\ud398\uc778 \uacbd\ud5d8\uc744 \ud568\uaed8 \uc313\uc544\uac08 \uc2e4\ubb34\ud615 \uc778\uc7ac\ub97c \uae30\ub2e4\ub824\uc694.\n\n\n[\ubbf8\ub514\uc5b4\ud300 \uc18c\uac1c]\n\u2022 \ud574\ub2f9 \ud3ec\uc9c0\uc158 \ud569\uaca9\uc790\ub294 \uc774\ub178\ubc14\uc778\ucf54\ub9ac\uc544 \uc790\ud68c\uc0ac '\uc560\ub4dc\ud06c\ub798\ud504\ud2b8'\uc758 \ubbf8\ub514\uc5b4\ud300\uc5d0 \uc18c\uc18d\ub420 \uc608\uc815\uc774\uc5d0\uc694.\n\u2022 \ubbf8\ub514\uc5b4\ud300\uc5d0\ub294 \ucd1d 7\uba85\uc758 \uad6c\uc131\uc6d0\uc774 \ud568\uaed8\ud558\uba70, \ubbf8\ub514\uc5b4 \uc601\uc5c5 (\uad11\uace0 \uc0c1\ud488 \uc138\uc77c\uc988) \ubc0f \uc81c\uc548, \ub9e4\uccb4 \uacc4\uc57d/\uc9d1\ud589 \ub4f1\uc758 \uc5c5\ubb34\ub97c \uc218\ud589\ud558\uace0 \uc788\uc5b4\uc694.\n\uc8fc\uc694\uc5c5\ubb34\n\u318d Google, Naver \ub4f1 \uac80\uc0c9\uad11\uace0 \ucea0\ud398\uc778 \uc6b4\uc601\n\u318d Meta, Kakao \ub4f1 \ub514\uc2a4\ud50c\ub808\uc774/\uc18c\uc15c \ucea0\ud398\uc778 \uae30\ud68d \ubc0f \uc6b4\uc601\n\u318d \ucea0\ud398\uc778 \uc131\uacfc \ubd84\uc11d \ubc0f \ub9ac\ud3ec\ud2b8 \uc791\uc131\n\u318d \uace0\uac1d\uc0ac\uc758 \ube44\uc988\ub2c8\uc2a4 \ubaa9\ud45c\uc5d0 \ub9de\ucd98 \ud37c\ub110 \ubd84\uc11d \ubc0f \uc804\ub7b5 \uc81c\uc548\n\u318d \uad11\uace0 \uc18c\uc7ac \ud14c\uc2a4\ud2b8 \ubc0f A/B \uc2e4\ud5d8 \uc124\uacc4\n\u318d \uad11\uace0 \ub9e4\uccb4\uc0ac \ubc0f \uace0\uac1d\uc0ac \ucee4\ubba4\ub2c8\ucf00\uc774\uc158\n\uc790\uaca9\uc694\uac74\n\u318d \ud37c\ud3ec\uba3c\uc2a4 \ub9c8\ucf00\ud305 \uc2e4\ubb34 \uacbd\ub825 1\ub144 \uc774\uc0c1 (\uc9c1\uc811 \ucea0\ud398\uc778\uc744 \uc6b4\uc601\ud55c \uacbd\ud5d8 \ud544\uc218)\n\u318d Naver \ud30c\uc6cc\ub9c1\ud06c, Google Search Ads \ub4f1 \uac80\uc0c9\uad11\uace0 \uc2e4\ubb34 \uacbd\ud5d8\uc790\n\u318d \ube0c\ub79c\ub4dc \ud0a4\uc6cc\ub4dc \uc6b4\uc601, \uc804\ud658 \ucd5c\uc801\ud654, \ud0a4\uc6cc\ub4dc \uc804\ub7b5 \uacbd\ud5d8\n\u318d Meta, Kakao \ub4f1 \ub514\uc9c0\ud138 \uad11\uace0 \ub9e4\uccb4 \uc6b4\uc601 \uacbd\ud5d8\n\u318d\uad11\uace0 \uc131\uacfc\ub97c \ub17c\ub9ac\uc801\uc73c\ub85c \uc124\uba85\ud558\uace0, \uace0\uac1d\uacfc \uc6d0\ud65c\ud788 \uc18c\ud1b5\ud560 \uc218 \uc788\ub294 \ubd84\n\n\uc0c1\uc138 \uc815\ubcf4 \ub354 \ubcf4\uae30\n\ud0dc\uadf8\n\n\uc2dd\ub300\uc9c0\uc6d0\n\n\uc0ac\ub0b4\ub3d9\ud638\ud68c\n\n\uc790\uc720\ub85c\uc6b4\ud734\uac00\n\n\ud734\uac00\ube44\n\n\ubcf4\ub108\uc2a4\n\n\ucee4\ud53c\u00b7\uc2a4\ub0b5\ubc14\n\n51~300\uba85\n\n\uc124\ub9bd4~9\ub144\n\n\uc790\uae30\uacc4\ubc1c\uc9c0\uc6d0\n\n\ud3b8\uc758\uc2dc\uc124\n\n\uac74\uac15\uac80\uc9c4\uc9c0\uc6d0\n\n\uc720\uae09\ud734\uac00\n\n\uc778\uc6d0 \uae09\uc131\uc7a5\n\n\uc5f0\ubd09 \uc5c5\uacc4\ud3c9\uade0\uc774\uc0c1\n\ub9c8\uac10\uc77c\n\uc0c1\uc2dc\ucc44\uc6a9\n\uadfc\ubb34\uc9c0\uc5ed\nNAVER\n\u00a9 NAVER Corp.\n\uc11c\uc6b8\ud2b9\ubcc4\uc2dc \uac15\ub0a8\uad6c \ub3c4\uc0b0\ub300\ub85c4\uae38 13\n\n\uc774\ub178\ubc14\uc778\ucf54\ub9ac\uc544\n\ud310\ub9e4, \uc720\ud1b5\n\n\ud314\ub85c\uc6b0"
},
"type": "n8n-nodes-openai-analytics.openAIAnalytics",
"typeVersion": 1,
"position": [
280,
560
],
"id": "9c02814a-75fc-4022-b91b-ae6f5dee0627",
"name": "\uc790\ub3d9 \ub808\ud3ec\ud2b8 \uc0dd\uc131",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"disabled": true
},
{
"parameters": {
"content": "## OpenAI Python \ubd84\uc11d ( Assistants API Code \uc778\ud130\ud504\ub9ac\ud130 )",
"height": 260,
"width": 1400
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
180,
800
],
"id": "e5e1321a-4c5b-495b-9fb7-1efc67a34e38",
"name": "Sticky Note4",
"disabled": true
},
{
"parameters": {
"authentication": "openAiApi",
"operation": "createAssistant",
"assistantName": "\ub9ac\ubdf0 \ubd84\uc11d\uae30",
"assistantDescription": "\uc0c1\ud488 \ub9ac\ubdf0 \ub370\uc774\ud130\ub97c \ubd84\uc11d",
"assistantInstructions": "\ub108\ub294 \uc0c1\ud488 \ub9ac\ubdf0 \ub370\uc774\ud130\ub97c \ubd84\uc11d\ud558\ub294 \ubd84\uc11d\uac00\uc57c.\n\uc0ac\uc6a9\uc790\uac00 \ubd84\uc11d\uc694\uccad\ud558\ub294 \ub9ac\ubdf0\ub370\uc774\ud130\uc758 \ub2e8\uc5b4\ub4e4\uc744 \ud1a0\ud06c\ub098\uc774\uc9d5\ud574\uc11c, TF-IDF \uae30\uc900\uc73c\ub85c \uc810\uc218\uac00 \ub192\uc740 \ub2e8\uc5b4 10\uac1c\ub97c\nPython \uc73c\ub85c \ubd84\uc11d\ud574\uc918.\n\uacb0\uacfc\ub294 json \uc591\uc2dd\uc744 \uc0ac\uc6a9\ud574\uc11c \ucd9c\ub825\ud574\uc918. \n```json ... ``` \uac19\uc740 \ucf54\ub4dc \ube14\ub85d \ubb38\uc790\uc5f4\uc774\ub098 \uae30\ud0c0 \ubd80\uc5f0 \uc124\uba85\uc740 \uc0dd\uc131\ud558\uc9c0 \ub9d0\uace0 \uc624\uc9c1 Json \ubb38\uc790\uc5f4\ub9cc \uc0dd\uc131\ud574\uc918.\n\n* json \uc751\ub2f5\ud615\uc2dd\n{\n \"\ubc30\uc1a1\" : 13.123,\n \"\ub9cc\uc871\" : 12.33,\n ...\n}",
"assistantModel": "gpt-4.1",
"useCodeInterpreter": true,
"useRetrieval": true,
"responseFormatType": "json_object",
"useAdvancedSettings": true,
"temperature": 0.3,
"topP": 0.9,
"useFileAttachments": true,
"assistantFileIds": "={{ [$json.id] }}"
},
"type": "n8n-nodes-openai-analytics.openAIAnalytics",
"typeVersion": 1,
"position": [
700,
880
],
"id": "ca131fdf-48e5-41d9-84a0-c56a39ee8e38",
"name": "\ub9ac\ubdf0 \ubd84\uc11d \uc5b4\uc2dc\uc2a4\ud134\ud2b8 \uc0dd\uc131",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"authentication": "openAiApi",
"resource": "thread",
"operation": "createAndRunThread",
"threadInitialMessage": "=\ucca8\ubd80\ud55c \ud30c\uc77c\uc758 \uc0c1\ud488\ub9ac\ubdf0 \ubd84\uc11d\uc744 \ud574\uc918.\nreview \uc5f4\uc5d0 \ud14d\uc2a4\ud2b8 \ubb38\uc11c\uac00 \uc800\uc7a5\ub418\uc5b4 \uc788\uc5b4.",
"threadFileAttachmentMethod": "uploadFiles",
"threadAssistantSelection": "byId",
"threadAssistantId": "={{ $('\ub9ac\ubdf0 \ubd84\uc11d \uc5b4\uc2dc\uc2a4\ud134\ud2b8 \uc0dd\uc131').item.json.assistant.id }}",
"threadMaxPollTime": 300
},
"type": "n8n-nodes-openai-analytics.openAIAnalytics",
"typeVersion": 1,
"position": [
1140,
880
],
"id": "94c788e6-0961-4e18-bf35-d9de3e5a2d33",
"name": "\ubd84\uc11d \uc2a4\ub808\ub4dc \uc2e4\ud589",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"fileSelector": "/users/dante/downloads/tfidf.md",
"options": {
"fileName": "tfidf.md"
}
},
"type": "n8n-nodes-base.readWriteFile",
"typeVersion": 1,
"position": [
280,
880
],
"id": "0c470602-421c-4189-bbe3-27ef55f8a1cd",
"name": "\ubd84\uc11d\ubc29\ubc95\ub860 \ud30c\uc77c\ub85c\ub4dc"
},
{
"parameters": {
"authentication": "openAiApi",
"resource": "file",
"operation": "uploadFile"
},
"type": "n8n-nodes-openai-analytics.openAIAnalytics",
"typeVersion": 1,
"position": [
480,
880
],
"id": "2ef9bcd3-081c-4ed9-bb60-6d0a15bb74ff",
"name": "\ud30c\uc77c\uc5c5\ub85c\ub4dc",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"fileSelector": "/users/dante/downloads/reviews.csv",
"options": {
"fileName": "reviews.csv"
}
},
"type": "n8n-nodes-base.readWriteFile",
"typeVersion": 1,
"position": [
920,
880
],
"id": "c00524e6-7fd8-423c-8442-b1c3a3f938c4",
"name": "\ubd84\uc11d\ub300\uc0c1 \ub370\uc774\ud130\ub85c\ub4dc"
},
{
"parameters": {
"labelsMode": "array",
"labelsArray": "={{ JSON.parse($json.messages[0].content[0].text).keys() }}",
"data": "={{ JSON.parse($json.messages[0].content[0].text).values() }}",
"chartOptions": {
"backgroundColor": "#ffffff"
},
"datasetOptions": {
"backgroundColor": "#f5acac",
"label": "\ub9ac\ubdf0 \ud575\uc2ec\ud0a4\uc6cc\ub4dc"
}
},
"type": "n8n-nodes-base.quickChart",
"typeVersion": 1,
"position": [
1360,
880
],
"id": "a71c1bac-ac51-4cea-8d11-e3e5683f6fdb",
"name": "QuickChart2"
},
{
"parameters": {
"content": "# \ub2e8\ud14c\ub7a9\uc2a4 n8n \ub370\uc774\ud130\ubd84\uc11d \ub178\ub4dc \uc8fc\uc694 \uae30\ub2a5 \uc0ac\uc6a9\ubc95\n### n8n-nodes-openai-analytics\n\n",
"height": 120,
"width": 1100,
"color": 3
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
320,
-760
],
"id": "5395033c-171d-4dc6-b151-c94f845ff464",
"name": "Sticky Note5",
"disabled": true
},
{
"parameters": {
"authentication": "openAiApi",
"resource": "embedding",
"operation": "cosineSimilarity",
"cosineInputType": "jsonPath",
"vector1Path": "data[0].embedding",
"vector2Path": "data[1].embedding"
},
"type": "n8n-nodes-openai-analytics.openAIAnalytics",
"typeVersion": 1,
"position": [
520,
-40
],
"id": "c0e90268-d097-4636-baad-a8fd3fee6f26",
"name": "\ub2e8\uc5b4 \uc720\uc0ac\ub3c4 \uacc4\uc0b0",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"disabled": true
}
],
"connections": {
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
},
{
"node": "\ub2e8\uc5b4 \uc784\ubca0\ub529",
"type": "main",
"index": 0
},
{
"node": "\uc5b8\uc5b4\ubaa8\ub378 \uae30\ubc18 \uce74\ud14c\uace0\ub77c\uc774\uc9d5",
"type": "main",
"index": 0
},
{
"node": "\uc790\ub3d9 \ub808\ud3ec\ud2b8 \uc0dd\uc131",
"type": "main",
"index": 0
},
{
"node": "\ubd84\uc11d\ubc29\ubc95\ub860 \ud30c\uc77c\ub85c\ub4dc",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "JSON \ud30c\uc2f1",
"type": "main",
"index": 0
}
]
]
},
"JSON \ud30c\uc2f1": {
"main": [
[
{
"node": "QuickChart",
"type": "main",
"index": 0
}
]
]
},
"\ub2e8\uc5b4 \uc784\ubca0\ub529": {
"main": [
[
{
"node": "\ub2e8\uc5b4 \uc720\uc0ac\ub3c4 \uacc4\uc0b0",
"type": "main",
"index": 0
}
]
]
},
"\uc784\ubca0\ub529 \uae30\ubc18 \uce74\ud14c\uace0\ub77c\uc774\uc9d5": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"\uc5b8\uc5b4\ubaa8\ub378 \uae30\ubc18 \uce74\ud14c\uace0\ub77c\uc774\uc9d5": {
"main": [
[
{
"node": "\uc784\ubca0\ub529 \uae30\ubc18 \uce74\ud14c\uace0\ub77c\uc774\uc9d5",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets": {
"main": [
[
{
"node": "OpenAI Analytics1",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Analytics1": {
"main": [
[
{
"node": "Summarize",
"type": "main",
"index": 0
}
]
]
},
"Summarize": {
"main": [
[
{
"node": "QuickChart1",
"type": "main",
"index": 0
}
]
]
},
"\ub9ac\ubdf0 \ubd84\uc11d \uc5b4\uc2dc\uc2a4\ud134\ud2b8 \uc0dd\uc131": {
"main": [
[
{
"node": "\ubd84\uc11d\ub300\uc0c1 \ub370\uc774\ud130\ub85c\ub4dc",
"type": "main",
"index": 0
}
]
]
},
"\ubd84\uc11d\ubc29\ubc95\ub860 \ud30c\uc77c\ub85c\ub4dc": {
"main": [
[
{
"node": "\ud30c\uc77c\uc5c5\ub85c\ub4dc",
"type": "main",
"index": 0
}
]
]
},
"\ud30c\uc77c\uc5c5\ub85c\ub4dc": {
"main": [
[
{
"node": "\ub9ac\ubdf0 \ubd84\uc11d \uc5b4\uc2dc\uc2a4\ud134\ud2b8 \uc0dd\uc131",
"type": "main",
"index": 0
}
]
]
},
"\ubd84\uc11d\ub300\uc0c1 \ub370\uc774\ud130\ub85c\ub4dc": {
"main": [
[
{
"node": "\ubd84\uc11d \uc2a4\ub808\ub4dc \uc2e4\ud589",
"type": "main",
"index": 0
}
]
]
},
"\ubd84\uc11d \uc2a4\ub808\ub4dc \uc2e4\ud589": {
"main": [
[
{
"node": "QuickChart2",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "8ccbe675-f48a-45d1-8191-7bdf0fe2e64c",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "C42IxxLmg2z4BI3t",
"tags": [
{
"createdAt": "2025-05-13T21:48:46.312Z",
"updatedAt": "2025-05-13T21:48:46.312Z",
"id": "17aNPkNcl3APRz42",
"name": "\ub370\uc774\ud130\ubd84\uc11d"
}
]
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApiopenAiApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
OpenAI Analytics 노드 사용법. Uses httpRequest, quickChart, n8n-nodes-openai-analytics, googleSheets. Event-driven trigger; 25 nodes.
Source: https://github.com/dandacompany/n8n-workflows/blob/2bbb7f1b4cc8f34f1dc5c18abad70014400c670d/analyzers/openai_analytics_nodes_basic_usage.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow automatically collects all comments from a specified YouTube video and analyzes the sentiment of each comment using an AI model (e.g., GPT, Claude or Gemini). The sentiment (Positive, Ne
Sentiment Analysis, Google Sheets, HTTP Request +2
This is the final piece of the AI content factory. This workflow takes your text-based video scripts and automatically generates high-quality audio voiceovers for each one, turning your text into read
Read Write File, Google Sheets, HTTP Request +2
Ask questions like “How much did I spend on food last month?” and get instant answers from your financial data — directly in Telegram.
Telegram Trigger, OpenAI, Google Sheets +2
The Problem That it Solves
Google Drive Trigger, OpenAI, Google Drive +5
This intelligent email automation workflow helps you maximize engagement through domain-based outreach. It utilizes AI-powered personalization and strategic follow-ups to increase response rates. The
Gmail, HTTP Request, Google Sheets +1