Gform到GitHub
高级
这是一个Engineering, Product, AI领域的自动化工作流，包含 17 个节点。主要使用 If, Github, HttpRequest, GoogleSheets, Agent 等节点，结合人工智能技术实现智能自动化。 Google表单提交创建GitHub问题错误报告
前置要求
- •GitHub Personal Access Token
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (17)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "A7VNezDsDXf8tgIx",
"meta": {
"instanceId": "ef9a435dc5fb323832174ee57609152fe23226e84a00823788faba3ead1d45dd",
"templateCredsSetupCompleted": true
},
"name": "Gform 到 GitHub",
"tags": [],
"nodes": [
{
"id": "0535cad3-e8c2-4e30-bf07-96c7cddca135",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
580,
200
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "de598b4e-d613-4408-8789-6e0228df15d9",
"name": "窗口缓冲记忆",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
740,
200
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "86a8012f-11b3-4422-84cc-cac76b33cb68",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
900,
200
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "7b141119-3d4e-4442-a851-03940cab8973",
"name": "条件判断",
"type": "n8n-nodes-base.if",
"position": [
260,
-80
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "52764f8d-357b-41f9-a259-6fc0709391dc",
"name": "过滤已发布的问题",
"type": "n8n-nodes-base.noOp",
"position": [
100,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ea22664f-8dcc-46fa-b85c-c99cad081e40",
"name": "格式化消息/输出解析",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
640,
-60
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "e291a507-75bf-4c03-adb2-271c7df94f41",
"name": "将新表单提交添加到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
20,
-80
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "a525c614-201e-466b-b283-823f6396af3f",
"name": "Google Form 触发器",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-220,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d5cf1f03-b9c5-4b6e-830b-de5133641c45",
"name": "在 GitHub 添加问题",
"type": "n8n-nodes-base.github",
"position": [
1180,
-60
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1136c762-2dda-409e-8689-8553e3568ddd",
"name": "发送带链接的 Discord 通知",
"type": "n8n-nodes-base.httpRequest",
"position": [
1480,
-60
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "911bd61d-07fe-4829-afc5-9023bd95d577",
"name": "将 GitHub 链接添加到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1760,
-60
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "f0b39a2e-04be-4c98-8887-4bbc28963f58",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-260,
-160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "488638f2-4dbd-4cbf-b208-fda165197148",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
220,
-160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b6f5ef45-239f-4383-9eba-53022f4b8e03",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
580,
-160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "93b4a53a-079d-4e9b-946a-5b8a8236fc99",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1100,
-160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c9c27b76-5ffd-4f50-b6ec-192934eb465d",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1700,
-160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e493762c-d9a7-4c94-8b91-8aee195788ac",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1420,
-160
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": true,
"pinData": {},
"settings": {
"callerPolicy": "workflowsFromSameOwner",
"executionOrder": "v1"
},
"versionId": "d55e1aaf-2b40-47e6-b017-6b6bf10caa38",
"connections": {
"If": {
"main": [
[
{
"node": "format message /output parsing",
"type": "main",
"index": 0
}
],
[
{
"node": "Filter out already posted issues",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "format message /output parsing",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Add issue to GitHub": {
"main": [
[
{
"node": "Send notification to discord w link",
"type": "main",
"index": 0
}
]
]
},
"Google Form Trigger": {
"main": [
[
{
"node": "Add new Form submissions to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Window Buffer Memory": {
"ai_memory": [
[
{
"node": "format message /output parsing",
"type": "ai_memory",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "format message /output parsing",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Add Github link to the sheet": {
"main": [
[]
]
},
"format message /output parsing": {
"main": [
[
{
"node": "Add issue to GitHub",
"type": "main",
"index": 0
}
]
]
},
"Send notification to discord w link": {
"main": [
[
{
"node": "Add Github link to the sheet",
"type": "main",
"index": 0
}
]
]
},
"Add new Form submissions to Google Sheets": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 工程, 产品, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
与数据对话：将文本转换为 SQL 查询和可视化曲线
与数据对话：将文本转换为 SQL 查询和可视化曲线
If
Set
Merge
+12
36 节点hippolyte-hu
工程
使用 OpenAI、Google Sheets、Jina AI 和 Slack 的 AI 驱动信息监控
基于AI的信息监控，集成OpenAI、Google Sheets、Jina AI和Slack
If
Set
Code
+10
31 节点Dataki
销售
使用Telegram、Google表格和AI创建产品满意度调查
通过Telegram、Google表格和AI创建产品满意度调查
If
Set
Redis
+12
40 节点Jimleuk
工程
仅从数据库架构生成 SQL 查询 - AI 驱动
仅从数据库架构生成 SQL 查询 - AI 驱动
If
Set
Merge
+11
29 节点Yulia
工程
🉑 使用Google Translate和GPT-4o生成语言学习Anki闪卡
🉑 使用Google Translate和GPT-4o生成语言学习Anki闪卡
If
Set
Merge
+10
21 节点Samir Saci
其他
HDW潜在客户越野车
使用AI代理的自动化LinkedIn潜在客户生成、评分与沟通
If
Code
Sort
+17
86 节点Andrey
销售
