This n8n workflow automates the process of sending daily health condition updates of patients to their assigned doctors and hospital staff. It runs every morning at 8 AM, pulls patient data from a Google Sheet, filters for active patients, and processes each patient’s data to generate personalized reports. These reports include vital signs, current condition, medication, and a condition status that highlights critical cases.
The workflow consists of several key steps:
– A cron trigger initiates the process daily at 8 AM.
– The Google Sheets node reads patient data from a specified sheet.
– A filter node ensures only active patients are included for reporting.
– A code node processes each patient’s data, generating email content, WhatsApp messages, and condition status, including highlighting critical cases.
– The system sends personalized email reports and WhatsApp notifications to doctors.
– Critical condition patients trigger an additional alert email to hospital staff.
– All reports are logged into a dedicated Google Sheet for record-keeping.
This automation is highly useful for healthcare providers seeking to streamline patient monitoring, ensure timely communication of health updates, and prioritize critical cases efficiently.
