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: - prescriptionid (unique ID) - patientname - patientemail - patientphone - doctorname - prescriptiondate - prescriptiondetails - dosageinstructions - followupdate (optional) - prescriptionstatus (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 YOURGOOGLESHEETID with your actual Google Sheet ID 2. Replace YOURWHATSAPPPHONENUMBERID 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: prescriptionid: RX001 patientname: John Doe patientemail: [email protected] patientphone: +1234567890 doctorname: Dr. Smith prescriptiondate: 2025-01-15 prescriptiondetails: Amoxicillin 500mg capsules dosageinstructions: Take 1 capsule 3 times daily with food followupdate: 2025-01-22 prescriptionstatus: new