Automate Prescription Delivery via Google Sheets to Email & WhatsApp

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

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

⚙️ Configuration Steps

1. Replace YOUR_GOOGLE_SHEET_ID with your actual Google Sheet ID
2. Replace YOUR_WHATSAPP_PHONE_NUMBER_ID with your WhatsApp Business phone number ID
3. Update the email sender address in the "Send Email" node
4. 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: john@email.com
 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