Monitor Medical Equipment with Google Sheets & Send WhatsApp and Email Alerts — n8n 工作流
概览
This n8n workflow monitors medical equipment usage by reading data daily at 6 AM from a Google Sheet, processes alerts for maintenance or calibration, and sends notifications to technicians and supervisors.
Good to Know Runs daily at 6 AM via cron trigger. Requires Google Sheet with equipment data. Sends alerts via email and WhatsApp. Logs all activities in the Google Sheet.
Google Sheet Structure
Sheet: A: Equipment ID | B: Equipment Name | C: Last Maintenance Date | D: Usage Hours E: Calib
使用的节点
Send EmailGoogle SheetsWhatsApp Business CloudCode
工作流预览
⚡
D
Daily Equipment Check (6…
Read Equipment Data
Process Equipment Alerts
F
Filter Equipment with Al…
Send Technician Email
F
Filter Critical Equipment
Send Critical Alert to S…
Log Maintenance Alerts
F
Filter Overdue Equipment
Update Equipment Status
T
Tack Break For 5 Sec
Send message
Send Critical Alert Mass…
13 nodes12 edges
工作原理
- 1
触发器
工作流由 定时 触发器启动，按预定计划运行。
- 2
处理
数据流经 13 个节点, connecting code, cron, emailsend。
- 3
输出
工作流完成自动化并将结果发送到配置的目标。
节点详情 (13)
SE#1
Send Email
emailSend
GO#2
Google Sheets
googleSheets
WHwhatsApp
#3
WhatsApp Business Cloud
CO#4
Code
code
如何导入此工作流
- 1点击右侧 下载 JSON 按钮保存工作流文件。
- 2打开你的 n8n 实例，依次点击 工作流 → 新建 → 从文件导入。
- 3选择下载的
monitor-medical-equipment-with-google-sheets-send-whatsapp-and-email-alerts文件并点击导入。 - 4为每个服务节点配置 凭证（API 密钥、OAuth 等）。
- 5点击 测试工作流 验证一切正常，然后激活它。
或直接在 n8n → 从 JSON 导入 中粘贴：
{ "name": "Monitor Medical Equipment with Google Sheets & Send WhatsApp and Email Alerts", "nodes": [...], ...}
集成
codecronemailsendfiltergooglesheetswaitwhatsapp
创建者
Oneclick AI Squad
@oneclick-ai
标签
codecronemailsendfiltergooglesheetswaitwhatsapp