
Twilio offers a wide variety of channels you can use to connect with your customers, for example, through an SMS or Phone Call. One of the ways you can use these channels is to collect data from your customers. Depending on the type of data, this can be a complex undertaking. Collecting individual words or numbers is usually pretty straightforward. However, when asking customers to share specific Times and Dates, this can be far more complex. A typical use-case might be the scheduling of an appointment. This is especially true when allowing customers to communicate in free form (for example, “I would like an appointment next Tuesday at 3 pm”).
In this blog, I will show you how you can extract Times and Dates during a phone call using JavaScript and serverless Twilio Functions without the need for any 3rd party integrations.
Prerequisites
To build this solution, you will …

Using Twilio, you can programmatically send customized SMS the way you want to, but your users may just want to send out SMS from a simple spreadsheet of their customers, without having to worry about how to program. Luckily, you can add that functionality to an Excel spreadsheet for them with Microsoft Office Scripts.
In this post, you will learn how to build a tool to send SMS to your customers from a Microsoft Excel sheet using Microsoft Office Scripts.
Are you using Google Sheets instead of Excel? Learn how to send SMS notifications from Google Sheets with Twilio.
Prerequisites
To build this solution, you will need:
- A free Twilio account
- An active phone number in your account if you want to send messages from a specific number, otherwise, you can get started without any setup for alphanumeric sender IDs.
- Access to Microsoft Office Scripts (as described …