Automate Prescription Delivery via Google Sheets to Email & WhatsApp — Workflow n8n

Moyen complexité⚥ DĂ©clencheur7 nƓudsđŸ·ïž Miscellaneouspar Oneclick AI Squad

Aperçu

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

NƓuds utilisĂ©s

Send EmailGoogle SheetsWhatsApp Business CloudCode

Aperçu du workflow

🌟 Features Included
- Automated Trigger: Monitors Google Sheet for new pres
- Smart Filtering: Only processes prescriptions with st
- Rich Email Format: Professional
F
Filter New Prescriptions
Format Prescription Data
Send WhatsApp
Log Notification
Update Prescription Status
⚡
G
Google Sheets Trigger
Send email
7 nodes7 edges

Comment ça fonctionne

  1. 1

    DĂ©clencheur

    Le workflow démarre avec un déclencheur déclencheur.

  2. 2

    Traitement

    Les donnĂ©es transitent par 7 nƓuds, connecting code, emailsend, filter.

  3. 3

    Sortie

    Le workflow termine son automatisation et livre le résultat à la destination configurée.

DĂ©tails des nƓuds (7)

SE

Send Email

emailSend

#1
GO

Google Sheets

googleSheets

#2
WH

WhatsApp Business Cloud

whatsApp

#3
CO

Code

code

#4

Comment importer ce workflow

  1. 1Cliquez sur le bouton Télécharger JSON à droite pour enregistrer le fichier du workflow.
  2. 2Ouvrez votre instance n8n. AccĂ©dez Ă  Workflows → Nouveau → Importer depuis un fichier.
  3. 3Sélectionnez le fichier automate-prescription-delivery-via-google-sheets-to-email-whatsapp téléchargé et cliquez sur Importer.
  4. 4Configurez les identifiants pour chaque nƓud de service (clĂ©s API, OAuth, etc.).
  5. 5Cliquez sur Tester le workflow pour vérifier que tout fonctionne, puis activez-le.

Ou collez directement dans n8n → Importer depuis JSON :

{ "name": "Automate Prescription Delivery via Google Sheets to Email & WhatsApp", "nodes": [...], ...}

Intégrations

codeemailsendfiltergooglesheetsgooglesheetstriggerwhatsapp

Obtenir ce workflow

Téléchargez et importez en un clic

Télécharger JSONVoir sur n8n.io
NƓuds7
Complexitémedium
DĂ©clencheurtrigger
CatégorieMiscellaneous

Créé par

Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

Tags

codeemailsendfiltergooglesheetsgooglesheetstriggerwhatsapp
⚡

Nouveau sur n8n ?

n8n est un outil d'automatisation de workflows gratuit et open-source. HĂ©bergez-le vous-mĂȘme ou utilisez la version cloud.

Obtenir n8n gratuitement →

Related Miscellaneous Workflows

COGMGOME+2
high

Automate Google Form Tracking & Gmail Alerts via n8n

Boost your administrative efficiency with this comprehensive n8n automation suite designed to bridge the gap between data collection and actionable insights. This workflow transforms standard Google Form submissions into a high-performance management ecosystem. Instead of manually checking spreadsheets, the system triggers instantly upon form submission, updating a centralized Google Sheets dashboard with real-time statistics while simultaneously executing conditional logic via the Code node. The automation intelligently distinguishes between new registrants and follow-ups, triggering personalized Gmail acknowledgments for immediate engagement. Furthermore, it incorporates a sophisticated reminder logic to ensure no student or lead falls through the cracks. By leveraging Webhook and Respond to Webhook nodes, the suite maintains a low-latency connection between your front-end forms and back-end database. This setup eliminates manual data entry errors, reduces response times by up to 90%, and provides stakeholders with a live visual overview of registration trends. It is an essential toolkit for any organization looking to scale their intake process without increasing headcount. **Common Use Cases:** - Educational Workshop & Course Enrollment Management - Automated Event Registration with Instant Attendee Confirmation - Customer Inquiry Routing and Lead Nurturing Pipeline

🔗 Webhook·20 nodes