Send Patient Condition Updates with Google Sheets, Email & WhatsApp Alerts

This n8n workflow streamlines hospital patient communication by triggering daily at 8 AM via cron to fetch active patient data from a Google Sheets 'Patients' sheet. It processes vital signs like temperature, blood pressure, heart rate, and conditions using a code node to generate personalized reports and flag critical priorities. Doctors receive detailed email summaries via Gmail and WhatsApp messages through API, ensuring timely updates without manual intervention.

For high-risk patients, an additional filter identifies critical conditions, triggering immediate email alerts to hospital staff for urgent action. All activities are logged back to a 'Reports_Log' sheet, providing an audit trail of sent notifications. This setup requires Google service account, Gmail app password, and WhatsApp API token.

Benefits include significant time savings for medical staff, reduced errors in reporting, 24/7 monitoring compliance, and scalable handling of hundreds of patients. Ideal use cases: hospitals, clinics, telemedicine services needing automated notifications to improve patient outcomes and operational efficiency.