Automate Prescription Delivery via Google Sheets to Email & WhatsApp

Description

This is a fully working n8n workflow that sends prescriptions to patients via email and WhatsApp when a doctor enters prescription data into a Google Sheet.

📋 Google Sheets Structure

Main Sheet:
Required columns:
prescription_id (unique ID)
patient_name
patient_email
patient_phone
doctor_name
prescription_date
prescription_details
dosage_instructions
followup_date (optional)
prescription_status (set to "new" for new prescriptions)

Log Sheet:
This will be auto-created with columns for tracking sent notifications.

🔧 Required Credentials Setup

Google Sheets OAuth2 API: Connect your Google account
SMTP Credentials: For email sending (Gmail, Outlook, etc.)
WhatsApp API: Meta Business WhatsApp API credentials

⚙️ Configuration Steps

Replace YOUR_GOOGLE_SHEET_ID with your actual Google Sheet ID
Replace YOUR_WHATSAPP_PHONE_NUMBER_ID with your WhatsApp Business phone number ID
Update the email sender address in the "Send Email" node
Set up your credentials in n8n

🌟 Features Included

Automated Trigger**: Monitors Google Sheet for new prescriptions
Smart Filtering**: Only processes prescriptions with status "new"
Rich Email Format**: Professional HTML email with prescription details
WhatsApp Integration**: Sends formatted prescription text
Comprehensive Logging**: Tracks all sent notifications
Status Updates**: Marks prescriptions as "sent" after processing
Error Handling**: Logs success/failure status for both channels

📱 Sample Data Format

Add rows to your sheet like this:
prescription_id: RX001
patient_name: John Doe
patient_email: [email protected]
patient_phone: +1234567890
doctor_name: Dr. Smith
prescription_date: 2025-01-15
prescription_details: Amoxicillin 500mg capsules
dosage_instructions: Take 1 capsule 3 times daily with food
followup_date: 2025-01-22
prescription_status: new