SMS Reminders with Twilio
Example Robocorp robot that reads a Google Sheet table and sends SMS reminders using Twilio.
This robot reads details (name, details and mobile number) from a given Google Sheet, and sends an SMS reminder for each row using Twilio, using
RPA.Notifier library. The main purpose of the demo is to demonstrate the simplicity of SMS messaging from a robot.
Setting up required connections and secrets
This example uses the Vault in Control Room to store secrets that are required to access your Google Sheet for read and write, as well as the Twilio credentials. Next chapter walk you through the setup.
Google Sheets setup
Start by copying the Google Sheet for the demo purposes to yourself. Here's a sample. Make sure to use the same names for the two sheets:
Appt for appointments and
Log for the send log, and with the exact same column names (unless you want to edit the robot code accordingly).
Then, follow Google Sheet Service account setup guide from here. This example uses vault named
Also add in the same vault your
sheet_id as a key, and get the value from the URL of your Google sheet. It's the part of the URL that looks like this:
Twilio is used to send the SMS messages in this example. Unless you already have an account, you can create one for free at Twilio.com.
Next, find the account SID, Auth Token and your Twilio "from" number from the account details page, and add them to a Vault named
Twilio with key names
Connect VS Code with Control Room
Unless you created the robot already in the Control Room, that needs to be done next. Follow the guide here.
Once the robot is configured in the Control Room and you have the code open in VS Code, it's very handy to use the Mark the Monkey tab to link your development environment with the Control Room, as well as to connect with the Vault.
Good to go! Have fun and send us feedback! <3