Streamline Prescription PDFs via WhatsApp with n8n and Supabase

Effortlessly Manage Prescription PDFs Through WhatsApp with n8n and Supabase

Revolutionize the way your clinic handles prescription documentation with a streamlined automation workflow that leverages WhatsApp, Google Gemini, and Supabase. This powerful n8n workflow automates the process of extracting, generating, and distributing prescription PDFs, ensuring efficient communication and record-keeping.

What this workflow does

• Trigger notifications: The workflow initiates upon receiving a new WhatsApp message on your WhatsApp Business Cloud number.
• Data extraction: Utilizes Google Gemini to extract crucial details such as the patient's name, doctor's name, and medication information, flagging any missing data for immediate attention.
• Error feedback: If necessary data is missing, it promptly informs the clinic staff via WhatsApp and logs a 'needs_review' status in Supabase.
• PDF generation: For complete prescriptions, it renders an HTML document, converts it to PDF using an HTML-to-PDF API, and securely uploads it to a public URL.
• Documentation delivery: Automatically sends the generated prescription PDF back to the sender through WhatsApp and logs a 'sent' status along with the PDF URL in Supabase.

Use cases

• Streamlined communication: Ideal for clinics looking to enhance their communication efficiency by automating prescription document handling through a familiar platform, WhatsApp.
• Record management: Supports medical institutions needing reliable digital record-keeping and quick retrieval of prescription details via Supabase logs.
• Error reduction: Beneficial for healthcare facilities aiming to minimize prescription errors by automatically flagging missing information and ensuring complete data capture.

Technical details

• Integrations: WhatsApp Business Cloud for message triggering and sending, Google Gemini API for data extraction, and HTML-to-PDF API for document conversion.
• Nodes used: if, set, supabase, WhatsApp, sticky note, HTTP request.
• Database logging: Efficiently records prescription data in a Supabase 'prescriptions' table, storing patient and doctor information along with the medication details and document URLs.