提醒邮件
中级
这是一个Project Management领域的自动化工作流，包含 12 个节点。主要使用 Code, Cron, Filter, EmailSend, GoogleSheets 等节点。 使用 Google Sheets 和 SMTP 的自动化每日任务提醒邮件
前置要求
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "4CEVNvAxTcHxo9DD",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "提醒邮件",
"tags": [],
"nodes": [
{
"id": "d0351dad-1983-4dbc-a823-33aacbac1610",
"name": "每日提醒触发器",
"type": "n8n-nodes-base.cron",
"position": [
-1328,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "72e59a50-855c-46c4-a08f-86ba7fef5f7e",
"name": "读取内容日历",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1104,
0
],
"parameters": {},
"typeVersion": 4
},
{
"id": "88e008b6-d682-47f4-98b0-174c4539fcdb",
"name": "筛选今日任务",
"type": "n8n-nodes-base.filter",
"position": [
-880,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7c5f2a5f-e1fa-411f-a902-2ffa5c42a384",
"name": "发送提醒邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
-656,
0
],
"webhookId": "c9682789-c651-4290-a3af-45de98144088",
"parameters": {},
"typeVersion": 2
},
{
"id": "1c81c65c-b547-400f-89d2-4821bc8c546f",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
-432,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "01e7103e-017c-4daa-ae24-39acebda4443",
"name": "更新表格行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-208,
0
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "98dfa376-a5d8-4e1b-b304-a5218ee74cc4",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1424,
-224
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7a1a69e6-f3d2-4a83-8dba-ebca9afe62e9",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3447d4fc-6e15-483e-ab07-26ff743b369c",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1008,
-288
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "dd89d395-60e8-431c-a402-ecbe544a0555",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-752,
160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "31404004-0e48-46e8-b530-d08d8ecce0a7",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-576,
-272
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bf511f72-5e9b-4bb4-a2e4-633e666a0ca8",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-224,
160
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "8f5f4fbb-9a1e-43ca-bc6f-d813247f6450",
"connections": {
"Code": {
"main": [
[
{
"node": "Update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Send Reminder Email": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Filter Today's Tasks": {
"main": [
[
{
"node": "Send Reminder Email",
"type": "main",
"index": 0
}
]
]
},
"Read Content Calendar": {
"main": [
[
{
"node": "Filter Today's Tasks",
"type": "main",
"index": 0
}
]
]
},
"Daily Reminder Trigger": {
"main": [
[
{
"node": "Read Content Calendar",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 项目管理
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
医疗设备维护警报系统
使用Google Sheets监控医疗设备并发送WhatsApp和邮件警报
Code
Cron
Wait
+5
14 节点Oneclick AI Squad
项目管理
反馈保存和报告生成
使用Azure OpenAI和Google Sheets分析销售交易结果并生成报告
Set
Code
Email Send
+6
28 节点Rahul Joshi
客户关系管理
使用GPT-4o-mini和Gmail分析YouTube频道并发送性能报告
使用GPT-4o-mini和Gmail分析YouTube频道并发送性能报告
Code
Email Send
Http Request
+6
20 节点Rahul Joshi
市场调研
从 GoHighLevel 自动发送客户续约提醒到 Gmail 和 Slack
从GoHighLevel自动发送客户续约提醒到Gmail、Slack和Google Sheets
If
Code
Gmail
+7
19 节点Rahul Joshi
客户关系管理
退信与无效检测 (Gmail 触发器)
使用 Gmail、Google Sheets 和 Slack 自动化邮件退信与无效检测
Code
Cron
Gmail
+6
26 节点Rahul Joshi
从GoHighLevel自动清理非活跃交易到Slack和Sheets
将GoHighLevel中的非活跃交易自动清理至Slack和Sheets
Code
Slack
Filter
+4
15 节点Rahul Joshi
客户关系管理
工作流信息
难度等级
中级
节点数量12
分类1
节点类型6
作者
Rahul Joshi
@rahul08Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.
外部链接
在 n8n.io 查看 →
分享此工作流