使用 GPT-4.1-mini 为新 Google Sheets 条目生成 AI
中级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 9 个节点。主要使用 GoogleSheets, Agent, GoogleSheetsTrigger, LmChatOpenAi, OutputParserStructured 等节点。 使用 GPT-4.1-mini 为新 Google Sheets 条目生成 AI 描述
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "0ad754e7-e05a-4935-a792-f3178248099a",
"name": "OpenAI Chat Model",
"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": "Structured Output Parser",
"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": "Sticky Note16",
"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": "Sticky Note",
"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": "Sticky Note1",
"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": {
"0ad754e7-e05a-4935-a792-f3178248099a": {
"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
}
]
]
},
"7f83e0b2-5561-480f-b3c6-9bba76158752": {
"ai_outputParser": [
[
{
"node": "5b4d1f11-89c8-4b38-89f1-2e353eaa9b40",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
基于Google Sheets记忆的博客写作与编辑器 (GPT-4)
基于Google Sheets记忆的博客写作与编辑器 (GPT-4)
If
Code
Filter
+
If
Code
Filter
18 节点Robert Breen
内容创作
使用GPT和Gemini结合性能数据创建高转化率Meta广告脚本
使用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
内容创作
邓白氏公司报告结构化数据提取（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 查看 →
分享此工作流