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