GPT-4.1-miniを使用して、新しいGoogleスプレッドシート項目からAIによる説明文を生成
中級
これはContent Creation, Multimodal AI分野の自動化ワークフローで、9個のノードを含みます。主にGoogleSheets, Agent, GoogleSheetsTrigger, LmChatOpenAi, OutputParserStructuredなどのノードを使用。 GPT-4.1-mini を使用して新しい Google スプレッドシート項目の AI 説明を生成する
前提条件
- •Google Sheets API認証情報
- •OpenAI API Key
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "0ad754e7-e05a-4935-a792-f3178248099a",
"name": "OpenAI チャットモデル",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-1024,
160
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "4l6TDfLZVFS24g3X",
"name": "OpenAi account 4"
}
},
"typeVersion": 1.2
},
{
"id": "7f83e0b2-5561-480f-b3c6-9bba76158752",
"name": "構造化出力パーサー",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-832,
128
],
"parameters": {
"jsonSchemaExample": "{\n\t\"description\": \"description\"\n}"
},
"typeVersion": 1.3
},
{
"id": "d88108ee-e1a0-43d2-948a-37bd706a33b5",
"name": "Update row in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-672,
-336
],
"parameters": {
"columns": {
"value": {
"topic": "={{ $('Row added - Google Sheet').item.json.topic }}",
"description": "={{ $json.output.description }}"
},
"schema": [
{
"id": "topic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "topic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"topic"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit#gid=0",
"cachedResultName": "data"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit?usp=drivesdk",
"cachedResultName": "Sheets Triggers"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "bfa0fde3-6ddb-4e69-a1d5-b6d86ef89672",
"name": "Append row in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-656,
-32
],
"parameters": {
"columns": {
"value": {
"Update": "={{ $('Row added - Google Sheet').item.json.topic }} was added"
},
"schema": [
{
"id": "Update",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Update",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"topic"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 196803262,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit#gid=196803262",
"cachedResultName": "actions"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit?usp=drivesdk",
"cachedResultName": "Sheets Triggers"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "ae9c19db-71eb-4b38-adba-ca5d7468bdc2",
"name": "付箋16",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2432,
-656
],
"parameters": {
"width": 2016,
"content": "## 📬 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/)"
},
"typeVersion": 1
},
{
"id": "6196c4fc-679c-4b5e-bbcc-685917d4fa5a",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2432,
-480
],
"parameters": {
"color": 5,
"width": 904,
"height": 860,
"content": "### Step 1: Set Up Your Google Sheets\n\n**Option 1: Use Our Pre-Made Template (Recommended)**\n1. Copy our template: [AI Description Generator Template](https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit?usp=sharing)\n2. Click \"File\" → \"Make a copy\" to create your own version\n3. Rename it as desired (e.g., \"My AI Content Generator\")\n4. Note your new sheet's URL - you'll need this for the workflow\n\n**Option 2: Create From Scratch**\n1. Go to [Google Sheets](https://sheets.google.com/)\n2. Create a new spreadsheet\n3. **Set up the main \"data\" tab:**\n - Rename \"Sheet1\" to \"data\"\n - Set up column headers in row 1:\n - A1: `topic`\n - B1: `description`\n4. **Create an \"actions\" tab:**\n - Add a new sheet and name it \"actions\"\n - Set up column headers:\n - A1: `Update`\n5. Copy your sheet's URL\n\n### Step 2: Configure Google API Access\n\n1. **Enable Google Sheets API**\n - Go to [Google Cloud Console](https://console.cloud.google.com/)\n - Create a new project or select existing one\n - Enable \"Google Sheets API\"\n - Enable \"Google Drive API\"\n\n"
},
"typeVersion": 1
},
{
"id": "ab630ed2-52a0-42ac-9e3d-3d9826ceb7e4",
"name": "Row added - Google Sheet",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-1376,
96
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit#gid=0",
"cachedResultName": "data"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit?usp=drivesdk",
"cachedResultName": "Sheets Triggers"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "5qZk3IRejGCu9qrm",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "5b4d1f11-89c8-4b38-89f1-2e353eaa9b40",
"name": "Description Writer",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-992,
-112
],
"parameters": {
"text": "={{ $json.topic }}",
"options": {
"systemMessage": "write a description of the topic. \n\noutput like this. \n\n{\n\t\"description\": \"description\"\n}"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "8150251e-63e2-43a0-8952-85b86c796df0",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1504,
-480
],
"parameters": {
"color": 4,
"width": 1096,
"height": 860,
"content": "\n### Step 4: Import and Configure the N8N Workflow\n\n1. **Import the Workflow**\n - Copy the workflow JSON from the template\n - In your N8N instance, go to Workflows → Import from JSON\n - Paste the JSON and import\n\n2. **Configure OpenAI Credentials**\n - Click on the \"OpenAI Chat Model\" node\n - Set up credentials using your OpenAI API key\n - Test the connection to ensure it works\n\n3. **Configure Google Sheets Integration**\n \n **For the Trigger Node:**\n - Click on \"Row added - Google Sheet\" node\n - Set up Google Sheets Trigger OAuth2 credentials\n - Select your spreadsheet from the dropdown\n - Choose the \"data\" sheet\n - Set polling to \"Every Minute\" (already configured)\n\n"
},
"typeVersion": 1
}
],
"pinData": {
"Row added - Google Sheet": [
{
"topic": "n8n",
"description": ""
}
]
},
"connections": {
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "5b4d1f11-89c8-4b38-89f1-2e353eaa9b40",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"5b4d1f11-89c8-4b38-89f1-2e353eaa9b40": {
"main": [
[
{
"node": "d88108ee-e1a0-43d2-948a-37bd706a33b5",
"type": "main",
"index": 0
},
{
"node": "bfa0fde3-6ddb-4e69-a1d5-b6d86ef89672",
"type": "main",
"index": 0
}
]
]
},
"ab630ed2-52a0-42ac-9e3d-3d9826ceb7e4": {
"main": [
[
{
"node": "5b4d1f11-89c8-4b38-89f1-2e353eaa9b40",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "5b4d1f11-89c8-4b38-89f1-2e353eaa9b40",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - コンテンツ作成, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
ブログ作成・エディタ
Google Sheetsに基づくブログライティング＆エディタ(GPT-4)
If
Code
Filter
+
If
Code
Filter
18 ノードRobert Breen
コンテンツ作成
ポッドキャストノート記録器
GPTとGeminiを使用して性能データを組み合わせて、高転換率のMeta広告スクリプトを作成
Set
Google Sheets
Manual Trigger
+
Set
Google Sheets
Manual Trigger
12 ノードRobert Breen
コンテンツ作成
ブログコンテンツの多言語自動翻訳
GPT-4oとMarkdownを使用してブログ記事を自動で複数の言語に翻訳
Set
Merge
Split Out
+
Set
Merge
Split Out
12 ノードRobert Breen
コンテンツ作成
ダン・バー氏社 Reports 構造化データ抽出（GPT-4o）
GPT-4o を使って邓白氏公司報告から構造化データを抽出
Http Request
Convert To File
Agent
+
Http Request
Convert To File
Agent
11 ノードRobert Breen
コンテンツ作成
Apify + GPT-4o-mini を使ってタグ分析から Instagram キャプションを生成
Apify + GPT-4o-mini を使ってタグ分析から Instagram キャプションを生成
Set
Code
Merge
+
Set
Code
Merge
17 ノードRobert Breen
コンテンツ作成
AIウェブサイトチャットボット - GPTとGoogleスプレッドシートによるCRMリード収集
GPTとGoogleスプレッドシートを統合したAIウェブサイトチャットボット - CRMリード収集システム
Code
Google Sheets
Agent
+
Code
Google Sheets
Agent
14 ノードRobert Breen
リード獲得
ワークフロー情報
難易度
中級
ノード数9
カテゴリー2
ノードタイプ6
作成者
Robert Breen
@rbreenProfessional 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.
外部リンク
n8n.ioで表示 →
このワークフローを共有