将Hotmart事件保存到Google Sheets
中级
这是一个Other领域的自动化工作流,包含 11 个节点。主要使用 Set, Switch, Webhook, DateTime, GoogleSheets 等节点。 将Hotmart事件保存到Google Sheets
前置要求
- •HTTP Webhook 端点(n8n 会自动生成)
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"nodes": [
{
"id": "f3d411bd-3451-4150-ac3d-917680a7b520",
"name": "转换时间戳",
"type": "n8n-nodes-base.dateTime",
"position": [
1760,
560
],
"parameters": {},
"notesInFlow": false,
"typeVersion": 2
},
{
"id": "7d43d464-521f-472a-baf5-68398c02a1b8",
"name": "分支",
"type": "n8n-nodes-base.switch",
"notes": "- PURCHASE_PROTEST é a primeira notificação sobre pedido de reembolso;\n- SUBSCRIPTION_CANCELLATION acontece junto com o purchase_protest, quando o cliente pede reembolso dentro do período da garantia;\n- PURCHASE_REFUNDED só acontece quando ocorre o reembolso de fato;\n\n- PURCHASE_COMPLETE significa que acabou o período de garantia e o dinheiro já pertence ao vendedor;\n",
"position": [
1300,
480
],
"parameters": {},
"typeVersion": 3
},
{
"id": "9a5d6fa2-a3b2-4b31-b571-e89eb4adcfa9",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
-100
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0556e91b-1d39-4a8b-a01a-e0a197769d64",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
280
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e6e4eceb-f0b8-4249-8a67-fd3778592b93",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1660,
180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "561163ec-bb92-4ba9-8535-79616707e321",
"name": "保存执行数据",
"type": "n8n-nodes-base.executionData",
"position": [
1300,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9e46c093-b97d-459f-bcd0-fa88f89be573",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1200,
-100
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9453b331-89c5-40e3-a635-0ddd26589d72",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
1100,
560
],
"webhookId": "439a86fe-819c-4516-9ebf-54e779b560c3",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "75fbebfc-a5d5-4d23-a2b4-f00ceb20f360",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
2300,
560
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "a6cd632c-783e-4808-9e6c-2235bfa1d3b8",
"name": "设置一些数据",
"type": "n8n-nodes-base.set",
"position": [
2040,
560
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "364118a0-03ee-41ba-8f33-901ef25dea6a",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2240,
300
],
"parameters": {},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Switch": {
"main": [
[
{
"node": "Convert timestamp",
"type": "main",
"index": 0
}
],
[
{
"node": "Convert timestamp",
"type": "main",
"index": 0
}
],
[
{
"node": "Convert timestamp",
"type": "main",
"index": 0
}
],
[
{
"node": "Convert timestamp",
"type": "main",
"index": 0
}
],
[
{
"node": "Convert timestamp",
"type": "main",
"index": 0
}
],
[
{
"node": "Convert timestamp",
"type": "main",
"index": 0
}
],
[
{
"node": "Convert timestamp",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
},
{
"node": "Save execution data",
"type": "main",
"index": 0
}
]
]
},
"Set some data": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Convert timestamp": {
"main": [
[
{
"node": "Set some data",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 其他
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
Google上传至YouTube
自动化音乐视频创建与YouTube发布,含AI生成的Google Drive元数据
If
Set
Code
+13
73 节点danejw
其他
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
备份工作流到 GitHub
备份工作流到 GitHub
If
N8n
Set
+12
23 节点Solomon
其他
使用 Google Gemini 和 Telegram 转录音频文件
使用 Google Gemini 和 Telegram 转录音频文件
Merge
Switch
Webhook
+8
21 节点Solomon
其他
双向同步 Google 通讯录与 Notion
双向同步 Google 通讯录与 Notion
If
Set
Merge
+9
82 节点Solomon
其他
宠物店 4
🐶 宠物店预约 AI 代理
If
Set
Code
+41
187 节点Bruno Dias
人工智能
工作流信息
难度等级
中级
节点数量11
分类1
节点类型7
作者
Solomon
@solomonFreelance consultant from Brazil, specializing in automations and data analysis. I work with select clients, addressing their toughest projects. For business inquiries, email me at automations.solomon@gmail.com or message me on Telegram for a faster response.
外部链接
在 n8n.io 查看 →
分享此工作流