Magento 2、Google Sheets和邮件自动化模板
中级
这是一个CRM领域的自动化工作流，包含 10 个节点。主要使用 Code、Gmail、HttpRequest、GoogleSheets、ScheduleTrigger 等节点。 Magento 2、Google Sheets和邮件自动化模板
前置要求
- •Google 账号和 Gmail API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (10 个)
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "c3b23fffea49117e798bf0289bfe84ed0e7c634b0def397db74b35f7d28d1f5f",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "a30bba15-3032-4abe-9431-dfadae71ed3f",
"name": "获取周日期",
"type": "n8n-nodes-base.code",
"position": [
-220,
-660
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2
},
{
"id": "40c5272c-b09f-427d-add9-c6460a23177f",
"name": "获取上周订单",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
220,
-660
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "94b4787c-b5ae-427d-b7cd-b83748964e6f",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
440,
-660
],
"parameters": {},
"typeVersion": 2
},
{
"id": "47f7cc41-ee09-4f5a-a00d-d73cae9db4ac",
"name": "每周摘要",
"type": "n8n-nodes-base.code",
"position": [
660,
-760
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f168f3d2-7c77-4d27-a497-e43baed3f23f",
"name": "产品细分",
"type": "n8n-nodes-base.code",
"position": [
660,
-560
],
"parameters": {},
"typeVersion": 2
},
{
"id": "cc8cf65e-ba9c-479b-b739-9c4e5c99bc50",
"name": "记录每周摘要",
"type": "n8n-nodes-base.googleSheets",
"position": [
880,
-760
],
"parameters": {},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "7f1cc863-1d7f-465c-b0cd-16ee528c5c8d",
"name": "记录产品细分",
"type": "n8n-nodes-base.googleSheets",
"position": [
880,
-560
],
"parameters": {},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "a51b42b7-b591-4e07-8a4d-5f4f567cd26c",
"name": "创建电子表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
-660
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "be5e4ccd-a578-4c89-9b73-ea113f750dd6",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-440,
-660
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "8c24cf2f-80c3-4626-a0ff-cf620137a524",
"name": "发送消息",
"type": "n8n-nodes-base.gmail",
"position": [
1100,
-760
],
"webhookId": "60b87c75-b243-46de-9d5c-3ad324d8ddc5",
"parameters": {},
"typeVersion": 2.1
}
],
"pinData": {},
"connections": {
"Code": {
"main": [
[
{
"node": "Product Breakdown",
"type": "main",
"index": 0
},
{
"node": "Weekly Summary",
"type": "main",
"index": 0
}
]
]
},
"GET Week Dates": {
"main": [
[
{
"node": "Create spreadsheet",
"type": "main",
"index": 0
}
]
]
},
"Weekly Summary": {
"main": [
[
{
"node": "Log Weekly Summary",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "GET Week Dates",
"type": "main",
"index": 0
}
]
]
},
"Product Breakdown": {
"main": [
[
{
"node": "Log Products Breakdown",
"type": "main",
"index": 0
}
]
]
},
"Create spreadsheet": {
"main": [
[
{
"node": "Get Last Week Orders",
"type": "main",
"index": 0
}
]
]
},
"Log Weekly Summary": {
"main": [
[
{
"node": "Send a message",
"type": "main",
"index": 0
}
]
]
},
"Get Last Week Orders": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Log Products Breakdown": {
"main": [
[]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个中级难度的工作流，适用于CRM等场景。适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
每日Magento 2客户同步到Google通讯录和Sheets（无重复）
每日Magento 2客户同步到Google通讯录和Sheets（无重复）
Code
Split Out
Http Request
+5
11 节点Kanaka Kishore Kandregula
CRM
从 Stripe 支付自动交付模板给客户
使用Stripe、GPT-4o和Gmail的自动化模板交付系统
If
Code
Gmail
+12
44 节点Rahul Joshi
CRM
通过Gmail审批自动禁用一年未售出的Magento 2产品
通过Gmail审批自动禁用一年未售出的Magento 2产品
If
Code
Gmail
+7
22 节点Kanaka Kishore Kandregula
Document Extraction
Magento 2低库存提醒通过Slack和Gmail（MSI兼容）
Magento 2低库存提醒通过Slack和Gmail（MSI兼容）
If
Code
Gmail
+4
18 节点Kanaka Kishore Kandregula
Miscellaneous
通过REST API修复并重新发送Magento 2访客订单邮件
通过REST API修复并重新发送Magento 2访客订单邮件
If
Code
My Sql
+3
10 节点Kanaka Kishore Kandregula
CRM
分析区域绩效
使用Bright Data MCP和GPT-4o分析销售区域绩效
Set
Code
Gmail
+8
17 节点Yaron Been
CRM
工作流信息
难度等级
中级
节点数量10
分类1
节点类型5
作者
Kanaka Kishore Kandregula
@kmyprojectsExperienced Magento 2 Developer with 10+ years of expertise in building and optimizing eCommerce solutions. Over the past year, I’ve expanded my skills into workflow automation using n8n, streamlining business processes and integrating systems for efficiency. Passionate about solving complex problems, enhancing performance, and leveraging automation to drive smarter workflows.
外部链接
在 n8n.io 上查看 →
分享此工作流