使用Gemini AI进行Jotform汇总与全面及抽象洞察
中级
这是一个自动化工作流，包含 12 个节点。主要使用 Set, Webhook, DataTable, GoogleDocs, GoogleSheets 等节点。 使用Gemini AI从Jotform数据生成全面和抽象摘要
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •Google Sheets API 凭证
- •Google Gemini API Key
使用的节点 (12)
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "aII3GCSHJ15ErlYd",
"meta": {
"instanceId": "885b4fb4a6a9c2cb5621429a7b972df0d05bb724c20ac7dac7171b62f1c7ef40",
"templateCredsSetupCompleted": true
},
"name": "使用 Gemini AI 进行 Jotform 汇总与全面及抽象洞察",
"tags": [
{
"id": "Kujft2FOjmOVQAmJ",
"name": "Engineering",
"createdAt": "2025-04-09T01:31:00.558Z",
"updatedAt": "2025-04-09T01:31:00.558Z"
},
{
"id": "ZOwtAMLepQaGW76t",
"name": "Building Blocks",
"createdAt": "2025-04-13T15:23:40.462Z",
"updatedAt": "2025-04-13T15:23:40.462Z"
},
{
"id": "ddPkw7Hg5dZhQu2w",
"name": "AI",
"createdAt": "2025-04-13T05:38:08.053Z",
"updatedAt": "2025-04-13T05:38:08.053Z"
}
],
"nodes": [
{
"id": "8b330c71-c374-45f1-b209-f222cde01637",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
-464,
-112
],
"webhookId": "f3c34cda-d603-4923-883b-500576200322",
"parameters": {
"path": "f3c34cda-d603-4923-883b-500576200322",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2.1
},
{
"id": "1ce7b1ab-bffa-4321-84f6-b86994f86388",
"name": "Google Gemini 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
-16,
96
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.0-flash-exp"
},
"credentials": {
"googlePalmApi": {
"id": "YeO7dHZnuGBVQKVZ",
"name": "Google Gemini(PaLM) Api account"
}
},
"typeVersion": 1
},
{
"id": "618b2a63-96f6-48fd-93c2-0ab011ce6c72",
"name": "多表：您可以连接多个表以实现有组织的数据结构",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
192,
96
],
"parameters": {
"jsonSchemaExample": "{\n\t\"comprehensive_summary\": \"\",\n \"abstract_summary\": \"\"\n}"
},
"typeVersion": 1.3
},
{
"id": "fe8330f1-da12-4d2d-9dd2-3471e3184baf",
"name": "持久化到 DataTable",
"type": "n8n-nodes-base.dataTable",
"position": [
512,
-240
],
"parameters": {
"columns": {
"value": {
"abstract_summary": "={{ $json.output.abstract_summary }}",
"comprehensive_summary": "={{ $json.output.comprehensive_summary }}"
},
"schema": [
{
"id": "comprehensive_summary",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "comprehensive_summary",
"defaultMatch": false
},
{
"id": "abstract_summary",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "abstract_summary",
"defaultMatch": false
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"summary"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"dataTableId": {
"__rl": true,
"mode": "list",
"value": "BS6vlRklZeHuVf1A",
"cachedResultUrl": "/projects/OFZrD6piltNz73Y6/datatables/BS6vlRklZeHuVf1A",
"cachedResultName": "JotformRegistration"
}
},
"typeVersion": 1
},
{
"id": "56bf001b-cbe4-48d6-afc8-ee6cfa6a5976",
"name": "在表格中追加或更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
512,
0
],
"parameters": {
"columns": {
"value": {
"abstract_summary": "={{ $json.output.abstract_summary }}",
"comprehensive_summary": "={{ $json.output.comprehensive_summary }}"
},
"schema": [
{
"id": "comprehensive_summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "comprehensive_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "abstract_summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "abstract_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"comprehensive_summary"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1JOEbaPC2T06_O6Jb_UMbS7oG3z5RncY7Wk1gNAcpicg/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1JOEbaPC2T06_O6Jb_UMbS7oG3z5RncY7Wk1gNAcpicg",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1JOEbaPC2T06_O6Jb_UMbS7oG3z5RncY7Wk1gNAcpicg/edit?usp=drivesdk",
"cachedResultName": "Jotoform Registration"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Zjoxh2BUZ6VXGQhA",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "1c5ef158-8280-4cbf-95f8-2a0993cf53e2",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-464,
-544
],
"parameters": {
"color": 7,
"width": 352,
"height": 272,
"content": ""
},
"typeVersion": 1
},
{
"id": "bc44ee25-7f8d-4955-aa7e-967394d81f3a",
"name": "全面与抽象汇总器",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
16,
-112
],
"parameters": {
"text": "=Build a comprehensive summary of the following {{ $json.body.pretty }}",
"batching": {},
"messages": {
"messageValues": [
{
"message": "You are an expert comprehensive summarizer"
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.7
},
{
"id": "4e9bf3c9-acbc-4bce-af59-3cfb3b43b0ef",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-816
],
"parameters": {
"width": 400,
"height": 544,
"content": "## 全面汇总"
},
"typeVersion": 1
},
{
"id": "f4b292b0-a173-44a2-9c42-f2a326f78903",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
352,
-816
],
"parameters": {
"width": 400,
"height": 544,
"content": "## 抽象汇总"
},
"typeVersion": 1
},
{
"id": "4c410111-74dc-4d89-9bf7-df06dc364c1f",
"name": "创建文档",
"type": "n8n-nodes-base.googleDocs",
"position": [
512,
256
],
"parameters": {
"title": "={{ $('Set the Input Fields').item.json.FormTitle }}-{{ $('Set the Input Fields').item.json.SubmissionID }}",
"folderId": "default"
},
"credentials": {
"googleDocsOAuth2Api": {
"id": "39XPsztp1DX0svZQ",
"name": "Google Docs account"
}
},
"typeVersion": 2
},
{
"id": "6b7ace69-f792-4040-87d6-6e857febd487",
"name": "设置输入字段",
"type": "n8n-nodes-base.set",
"position": [
-224,
-112
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "a3ce16f0-0a3c-4f77-b747-bd475def3862",
"name": "FormTitle",
"type": "string",
"value": "={{ $json.body.formTitle }}"
},
{
"id": "b65e18e1-3aaa-4c4e-a7c4-c011078af035",
"name": "SubmissionID",
"type": "string",
"value": "={{ $json.body.submissionID }}"
},
{
"id": "ea353a9b-54e3-4f23-bc62-a30388acf5c6",
"name": "body",
"type": "object",
"value": "={{ $json.body.toJsonString() }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "2270d28e-443a-480d-b44a-1683ed6d029d",
"name": "更新文档",
"type": "n8n-nodes-base.googleDocs",
"position": [
720,
256
],
"parameters": {
"actionsUi": {
"actionFields": [
{
"text": "=Comprehensive Summary - \n\n{{ $('Comprehensive & Abstract Summarizer').item.json.output.comprehensive_summary }}\n\nAbstract Summary - \n\n{{ $('Comprehensive & Abstract Summarizer').item.json.output.abstract_summary }}",
"action": "insert"
}
]
},
"operation": "update",
"documentURL": "={{ $json.id }}"
},
"credentials": {
"googleDocsOAuth2Api": {
"id": "39XPsztp1DX0svZQ",
"name": "Google Docs account"
}
},
"typeVersion": 2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "78e39833-6dee-4e69-9b48-f8b1fa198c19",
"connections": {
"Webhook": {
"main": [
[
{
"node": "Set the Input Fields",
"type": "main",
"index": 0
}
]
]
},
"Create a document": {
"main": [
[
{
"node": "Update a document",
"type": "main",
"index": 0
}
]
]
},
"Set the Input Fields": {
"main": [
[
{
"node": "Comprehensive & Abstract Summarizer",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "Comprehensive & Abstract Summarizer",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Comprehensive & Abstract Summarizer",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Comprehensive & Abstract Summarizer": {
"main": [
[
{
"node": "Persist On DataTable",
"type": "main",
"index": 0
},
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
},
{
"node": "Create a document",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
AI代理驱动的ProductHunt数据提取和搜索（使用Bright Data和Google Gemini）
使用Bright Data MCP和Google Gemini AI提取和搜索ProductHunt数据
Set
Function
Mcp Client
+10
21 节点Ranjan Dailata
人工智能
Brave搜索结构化数据提取（Bright Data MCP + Google Gemini）
使用Bright Data MCP和Google Gemini从Brave搜索中提取结构化数据
Set
Switch
Function
+9
24 节点Ranjan Dailata
人工智能
通过Bright Data提取、总结和分析亚马逊产品降价情况
使用Bright Data和Google Gemini提取、总结和分析亚马逊降价信息
Set
Wait
Merge
+14
26 节点Ranjan Dailata
人工智能
使用Bright Data和Google Gemini的Google Maps企业抓取和线索丰富
使用Bright Data和Google Gemini的Google Maps企业抓取和线索丰富工具
Set
Code
Wait
+11
29 节点Ranjan Dailata
潜在客户开发
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
通过 Decodo + Google Gemini 实现自动化 LinkedIn 人才分析与摘要
使用 Decodo、Gemini 和 Google Sheets 自动化 LinkedIn 人才画像与摘要
Set
Code
Merge
+6
13 节点Ranjan Dailata
工作流信息
难度等级
中级
节点数量12
分类-
节点类型9
作者
Ranjan Dailata
@ranjancseA Professional based out of India specialized in handling AI-powered automations. Contact me at ranjancse@gmail.com
外部链接
在 n8n.io 查看 →
分享此工作流