🚀 自动化Stripe支付恢复：跟踪失败和跟进邮件
中级
这是一个Invoice Processing领域的自动化工作流，包含 13 个节点。主要使用 Set, Switch, SendInBlue, GoogleSheets, StripeTrigger 等节点。 🚀 自动化Stripe支付恢复：跟踪失败和跟进邮件
前置要求
- •Google Sheets API 凭证
- •Stripe API Key
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "b6731f6e46273cffeac6b5188a5b3bcb0840c00108e73b48ae2b799ac6e8e081",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "497e2fda-6782-4bc0-b594-11d545667b43",
"name": "Detect Failed Payments",
"type": "n8n-nodes-base.stripeTrigger",
"position": [
-2500,
160
],
"webhookId": "c23dd369-5c11-4166-ad55-0af41858c0d6",
"parameters": {},
"typeVersion": 1
},
{
"id": "7e739ab1-372e-45a1-bf66-69376d8615b0",
"name": "Extract User and Payment Info",
"type": "n8n-nodes-base.set",
"position": [
-2280,
160
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "1b2195ec-be80-401d-a504-498266bfb9a0",
"name": "Append or update row in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1840,
160
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "7edfaea7-a11f-4335-b17c-f7707049bd2c",
"name": "Remove Duplicates",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
-2060,
160
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e6498365-7e61-4d17-81e6-435776bdd96f",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1000,
100
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "572cc980-ab25-4a65-a63b-21633c4b28c3",
"name": "Update Email Count",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "740421e1-2a63-440a-aba2-f6848fa3ab25",
"name": "Get Payment Failure Leads",
"type": "n8n-nodes-base.googleSheets",
"position": [
-780,
100
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "ecb53f48-4515-4bad-9a3e-3191bf985d29",
"name": "Check for no. of emails sent",
"type": "n8n-nodes-base.switch",
"position": [
-560,
100
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "1fcea8aa-f547-48bc-92d5-2b3cd954a216",
"name": "Send First Email",
"type": "n8n-nodes-base.sendInBlue",
"position": [
-220,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ec8849dc-47e0-4a47-acf7-15bbdc0905bf",
"name": "Send Second Email",
"type": "n8n-nodes-base.sendInBlue",
"position": [
-220,
200
],
"parameters": {},
"executeOnce": false,
"typeVersion": 1
},
{
"id": "07d8a522-cd9b-451c-a45e-3b2074746b51",
"name": "Quit Sending Emails to these Leads",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
200
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "a6591c76-c5de-468c-b36e-23d867a5d1cb",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2840,
-220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "81c80cf6-b0ed-4dc5-8cd1-4e8b7d7f3409",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1560,
-220
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"e6498365-7e61-4d17-81e6-435776bdd96f": {
"main": [
[
{
"node": "740421e1-2a63-440a-aba2-f6848fa3ab25",
"type": "main",
"index": 0
}
]
]
},
"1fcea8aa-f547-48bc-92d5-2b3cd954a216": {
"main": [
[
{
"node": "572cc980-ab25-4a65-a63b-21633c4b28c3",
"type": "main",
"index": 0
}
]
]
},
"7edfaea7-a11f-4335-b17c-f7707049bd2c": {
"main": [
[
{
"node": "1b2195ec-be80-401d-a504-498266bfb9a0",
"type": "main",
"index": 0
}
]
]
},
"ec8849dc-47e0-4a47-acf7-15bbdc0905bf": {
"main": [
[
{
"node": "07d8a522-cd9b-451c-a45e-3b2074746b51",
"type": "main",
"index": 0
}
]
]
},
"497e2fda-6782-4bc0-b594-11d545667b43": {
"main": [
[
{
"node": "7e739ab1-372e-45a1-bf66-69376d8615b0",
"type": "main",
"index": 0
}
]
]
},
"740421e1-2a63-440a-aba2-f6848fa3ab25": {
"main": [
[
{
"node": "ecb53f48-4515-4bad-9a3e-3191bf985d29",
"type": "main",
"index": 0
}
]
]
},
"ecb53f48-4515-4bad-9a3e-3191bf985d29": {
"main": [
[
{
"node": "1fcea8aa-f547-48bc-92d5-2b3cd954a216",
"type": "main",
"index": 0
}
],
[
{
"node": "ec8849dc-47e0-4a47-acf7-15bbdc0905bf",
"type": "main",
"index": 0
}
]
]
},
"7e739ab1-372e-45a1-bf66-69376d8615b0": {
"main": [
[
{
"node": "7edfaea7-a11f-4335-b17c-f7707049bd2c",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 发票处理
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
基于Supabase、Google表格和Gmail的自动化用户重新激活系统
使用Supabase、Google表格和Gmail的自动化用户重新激活系统
Set
Code
Gmail
+
Set
Code
Gmail
14 节点iamvaar
社交媒体
LinkedIn和X病毒内容自动引擎
使用AI生成和发布自动创建LinkedIn和X的病毒内容
If
Set
Wait
+
If
Set
Wait
156 节点Diptamoy Barman
内容创作
AI 自动保存 Gmail 收据
AI自动保存Gmail收据到Google表格和Google云端硬盘
Set
Gmail
Merge
+
Set
Gmail
Merge
14 节点Matt Chong
发票处理
使用 Jotform、Gemini AI 和 Google Sheets 自动化内部投诉处理
通过 Jotform、Gemini AI 和 Google Sheets 实现内部投诉处理的自动化
If
Gmail
Google Sheets
+
If
Gmail
Google Sheets
22 节点iamvaar
工单管理
使用Airtable采购单创建和供应商邮件自动管理库存
使用Airtable采购单创建和供应商邮件自动管理库存
Code
Airtable
Send In Blue
+
Code
Airtable
Send In Blue
15 节点iamvaar
文档提取
Google Sheets和QuickBooks费用自动化模板
Google Sheets和QuickBooks费用自动化模板
If
Set
Split Out
+
If
Set
Split Out
16 节点Rosh Ragel
发票处理
