Quick overview
Quick overview This workflow monitors a Google Drive folder for new prescription PDFs, extracts the text, uses OpenAI (GPT-4o-mini) to structure prescription details and draft a SOAP note, checks drugs against Google Sheets formulary and interaction tables, and notifies a pharmacist or patient via Telegram, with Slack error alerts. How it works Triggers when a new PDF is created in a specified Google Drive folder. Downloads the PDF and extracts its text content. Sends the extracted text to OpenAI (GPT-4o-mini) to return structured patient/prescription fields, a drug list, and a drafted SOAP note as JSON. Loads the approved formulary and the drug-interaction pairs from Google Sheets and cross-checks the prescribed drugs to detect off-formulary items and known interactions. If issues are found, sends a detailed Telegram alert to the pharmacist and appends the case to the Google Sheets FlaggedPrescriptions tab for auditing. If no issues are found, logs the prescription to the Google Sheets Prescriptions tab and sends a Telegram confirmation to the patient. If any node errors, posts an error message with execution details to a Slack channel. Setup Connect Google Drive OAuth2 credentials and set the folder ID in the Google Drive trigger to the intake folder for prescription PDFs. Add an OpenAI API credential and confirm the model selection (default: gpt-4o-mini) meets your needs. Connect Google Sheets OAuth2 credentials and create/update a spreadsheet with tabs named Formulary, Interactions, Prescriptions, and FlaggedPrescriptions, then set the spreadsheet ID in the Google Sheets nodes. Configure a Telegram bot credential and replace the pharmacist and patient chatId values used in the two Telegram messages. Connect Slack OAuth2 credentials and set the target Slack channel ID for workflow error alerts. An n8n automation workflow template by Rahul Joshi.
Rahul Joshi
web
free
Others in the same category, ranked by how often they are opened.
