Monitor Medical Equipment with Google Sheets & Send WhatsApp and Email Alerts — n8n Workflow

Medium complexity⏰ Scheduled13 nodes🏷️ Project Managementby Oneclick AI Squad

Overview

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

Nodes used

Send EmailGoogle SheetsWhatsApp Business CloudCode

Workflow Preview

How It Works
- Daily Equipment Check (6 AM) - Triggers the workflow.
- Read Equipment Data - Fetches data from Google Sheet.
- Process Equipment Alerts - Identifies maintenance nee
-
⚡
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

How it Works

  1. 1

    Trigger

    The workflow starts with a scheduled trigger, running on a defined schedule.

  2. 2

    Process

    Data flows through 13 nodes, connecting code, cron, emailsend.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (13)

SE

Send Email

emailSend

#1
GO

Google Sheets

googleSheets

#2
WH

WhatsApp Business Cloud

whatsApp

#3
CO

Code

code

#4

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded monitor-medical-equipment-with-google-sheets-send-whatsapp-and-email-alerts file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Monitor Medical Equipment with Google Sheets & Send WhatsApp and Email Alerts", "nodes": [...], ...}

Integrations

codecronemailsendfiltergooglesheetswaitwhatsapp

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes13
Complexitymedium
Triggerscheduled
CategoryProject Management

Created by

Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

Tags

codecronemailsendfiltergooglesheetswaitwhatsapp
⚡

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →