Send Automated Appointment Reminders via SMS with Twilio Webhook

This n8n workflow simplifies the process of sending automated appointment reminders via SMS using Twilio, triggered by a webhook. It's designed to be flexible, allowing you to define the reminder message and recipient details dynamically.

What it does

This workflow automates the following steps:

1. Listens for incoming data: It starts by waiting for a POST request to its webhook URL. This webhook payload is expected to contain the necessary information for the SMS reminder, such as the recipient's phone number, appointment details, and the reminder message.
2. Prepares SMS content: A Code node processes the incoming webhook data to format the SMS message. This allows for dynamic message construction based on the provided appointment details.
3. Sends SMS reminder: It uses the Twilio node to send an SMS message to the specified phone number with the prepared content.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n instance: A running n8n instance.
• Twilio Account: An active Twilio account with an SMS-enabled phone number.
• Twilio Credentials: Your Twilio Account SID and Auth Token configured as credentials in n8n.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Twilio Credentials:
   • Click on the "Twilio" node.
   • Under the "Credentials" section, select your existing Twilio credentials or click "Create New" to add your Twilio Account SID and Auth Token.
3. Activate the Webhook:
   • Click on the "Webhook" node.
   • Copy the "Webhook URL". This is the URL you will send your appointment reminder data to.
4. Customize the Code Node:
   • Click on the "Code" node.
   • Review the JavaScript code. This is where you can define how the incoming webhook data is transformed into the SMS message.
   • The current code is a placeholder, and you will need to adapt it to parse the specific structure of your incoming webhook data and construct your desired SMS message. For example, if your webhook sends data.phoneNumber and data.appointmentTime, you would access them as $('Webhook').item.json.phoneNumber and $('Webhook').item.json.appointmentTime.
5. Activate the workflow: Toggle the workflow to "Active" in the top right corner of the n8n editor.
6. Trigger the workflow: Send a POST request to the Webhook URL (obtained in step 3) with the appointment reminder data in the request body. The structure of this data should match what you've configured in the "Code" node.

Example Webhook Payload (adjust based on your Code node logic):

{
  "phoneNumber": "+15551234567",
  "appointmentTime": "Tomorrow at 2 PM",
  "patientName": "John Doe",
  "clinicName": "My Clinic"
}