Build apps on Twilio using SQL

Community Show & Tell
1

After several requests on our Stripe post (thanks @alex-godin and @chrisjordan9 for keeping us honest), we’re excited to announce that Sync Inc now supports Twilio.

We’ll sync all your Twilio messages, phone calls, recordings, and more to your Postgres database in real-time. Any new conversation will appear in your database in under a second.

Paired with Retool, you can use SQL to build apps on Twilio in no time. We stood up an SMS app to help with customer notifications in under an hour. End-to-end. We wrote up a tutorial to show how we did it. One thing that surprised us (in a good way) was how Retool's periodic queries allowed us to skip the Twilio webhooks entirely.

CleanShot 2021-09-30 at 15.06.38@2x
CleanShot 2021-09-30 at 15.06.38@2x3368×2656 873 KB

You can try our Twilio sync out free here: https://syncinc.so/sources/twilio

If you’re curious about how it all works, check out our docs: https://docs.syncinc.so/twilio/reference

We just launched this! Right now, we’re focused on syncing Twilio to your database so you can use SQL as opposed to HTTP to query your data. But because Twilio is such an event-oriented API, we’re wondering what extra features would be helpful here as you build.

We’re looking forward to hearing feedback and answering any questions.

1 Like
2

@goldman Would you be able to share the CSS for the timeline/texts?

3

Hey @mwh22 - thanks for checking out the tutorial!

Here is the CSS for the timeline / texts:

.outbound-reply {
  background: #1982FC;
  padding: 7px;
  border-radius: 15px;
  color: white;
}

.outbound-api {
  background: #1982FC;
  padding: 7px;
  border-radius: 15px;
  color: white;
}

.inbound {
  background: lightgrey;
  padding: 7px;
  border-radius: 15px;
  color: black;
}
4

Thanks @goldman !

5

https://syncinc.so/sources/twilio is down.