自动化JotForm提交到Google Sheets
中级
这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 12 个节点。主要使用 Code, Wait, HttpRequest, GoogleSheets, ManualTrigger 等节点。 自动化JotForm提交到Google Sheets
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "4dec90995ececbc62e9e87d2686828c375ae5080bb5c39789af3396400555208",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "8ec873d2-615b-4f5d-8dbd-fd8707a35e64",
"name": "获取所有提交",
"type": "n8n-nodes-base.httpRequest",
"position": [
-272,
-32
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "ad59d4c5-e709-49a9-93a5-ca8dd023f0ac",
"name": "当点击“执行工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-528,
-32
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ab335e18-901d-4733-8c61-595f05ede02c",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
288,
-32
],
"parameters": {},
"typeVersion": 3
},
{
"id": "9d4c6804-440a-4a6c-aabd-f51bbd071751",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
832,
-288
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e409f00f-02b1-4a87-8553-13909cc8da23",
"name": "在表格中追加行",
"type": "n8n-nodes-base.googleSheets",
"position": [
976,
16
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "e2b900db-b9eb-45e8-9e59-a8e258d03c59",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
-64,
-32
],
"parameters": {},
"typeVersion": 2
},
{
"id": "51639a36-6d3f-4437-a6fd-c16f96b5c255",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
640,
0
],
"webhookId": "f22a4495-ea34-4a2e-b8ca-116da66ef4c3",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "d4b9f5d5-625f-4635-ad96-b1e78d4a9569",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-352,
-112
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e7149bdd-2981-4de6-840a-71fec52e8b2a",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-96,
-112
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "311426d1-5c9e-43ab-8f6a-7dd5c849309f",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
928,
-64
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fc1f4b5b-a491-41cc-bfd8-d9aeafad891c",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
224,
-352
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8e6ab364-5d2c-4e99-b9f1-af26815e3c03",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
544,
-64
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Code": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"get all submissions": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "get all submissions",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 潜在客户开发, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Google Sheets检测电商平台与技术栈
使用Google Sheets检测电商平台与技术栈
Code
Wait
Http Request
+5
12 节点Ajay Yadav
潜在客户开发
科技新闻聚合器：The Verge和TechCrunch RSS到Notion，含GPT-4摘要
科技新闻聚合器：The Verge和TechCrunch RSS到Notion，含GPT-4摘要
If
Code
Html
+11
37 节点moosa
杂项
模板HP - 内容排期
使用GPT-4、Apify和Google Sheets自动生成Instagram内容排期
Set
Code
Wait
+9
24 节点keisha kalra
内容创作
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
基于AI的潜在客户生成系统（邮件个性化和LinkedIn）
基于AI的潜在客户生成系统：包含邮件个性化和LinkedIn功能
If
Code
Limit
+11
51 节点Matthieu
潜在客户开发
使用免费邮箱丰富功能自动化Google Maps潜在客户生成至Google Sheets
使用免费邮箱丰富功能自动化Google Maps潜在客户生成至Google Sheets
If
Code
Split Out
+5
18 节点Zain Khan
潜在客户开发
