Automated Patient Vitals Monitoring & Alerts with Philips IntelliVue & Google Sheets

This n8n workflow automates the process of fetching patient vital signs from a Philips IntelliVue system, recording them in Google Sheets, and sending email alerts for critical values. It simplifies patient monitoring by providing a streamlined way to track vitals and notify healthcare staff when immediate attention is required.

What it does

1. Schedules Data Fetch: The workflow is triggered periodically (e.g., every 5 minutes) to initiate the data collection process.
2. Fetches Patient Vitals: It makes an HTTP request to the Philips IntelliVue API to retrieve the latest patient vital signs.
3. Processes Vitals Data: A Code node processes the raw data from the Philips IntelliVue API, extracting relevant vital signs and patient information.
4. Stores Vitals in Google Sheets: The extracted vital signs are appended as a new row in a designated Google Sheet, creating a historical record.
5. Evaluates Vitals for Alerts: A Switch node checks if any of the recorded vital signs (e.g., heart rate, blood pressure, SpO2) fall outside predefined normal ranges.
6. Sends Email Alerts (if critical): If any vital sign is identified as critical, an email alert is sent to a specified recipient (e.g., nursing station, on-call doctor) with the patient's details and the critical vital sign.

Prerequisites/Requirements

• n8n Instance: A running n8n instance to host the workflow.
• Philips IntelliVue System: Access to a Philips IntelliVue patient monitoring system with API capabilities.
• Google Account: A Google account with access to Google Sheets.
• SMTP Server/Email Service: Configured email credentials within n8n to send alerts (e.g., via an SMTP server, Gmail, etc.).

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • HTTP Request Node (Philips IntelliVue): Configure the HTTP Request node with the correct URL, authentication (e.g., API key, OAuth), and any necessary headers for your Philips IntelliVue API.
   • Google Sheets Node: Set up a Google Sheets credential in n8n and select it in the Google Sheets node. Specify the Spreadsheet ID and Sheet Name where the patient vitals should be recorded.
   • Send Email Node: Configure your email credentials in n8n and select them in the Send Email node. Specify the recipient email address(es) and customize the email subject and body as needed.
3. Customize Code Node: Review and adjust the JavaScript code in the "Code" node to correctly parse the data returned by your Philips IntelliVue API and extract the specific vital signs and patient identifiers you wish to track.
4. Configure Switch Node Logic: Modify the conditions in the "Switch" node to define your critical vital sign thresholds (e.g., {{ $json.heartRate > 120 || $json.heartRate < 50 }}).
5. Adjust Cron Schedule: Configure the "Cron" node to run at your desired interval (e.g., every 5 minutes, every hour).
6. Activate the Workflow: Save and activate the workflow.