How to make Ring Central watch an SMS opt in response and update Airtable..AI Asst is crazy

How To
,
22

Thanks for the detailed response! I believe that when I send the SMS I can get the conversation ID in addition to the phone number so I could watch for that specifically somehow but my plan is to have it check every incoming message and then check if it Airtable record is waiting for a response. I’m not too worried about the syntax errors because I would simply set up a “who hasn’t responded” view in Airtable and check on those manually. OR eventually use AI I suppose.

I am not sure I have to worry about valid or invalid since it will just be looking for the yes or no (or other words such as Nope or yep if I want to add them) within like 48 hours or less. And if Airtable is waiting for the response it will then update.

I like the idea of setting up RingCentral with a Make Webhook. That would be great but maybe not as easy, for me anyway, as using Make.

Once a yes or no is received then Airtable is updated and future conversations will not update anything. The Scenario will just check SMS and then do nothing.

What do you think?

23

Is a conversation ID nothing more than a function of the phone number of the sender and receiver?

In Airtable you could have a field for the conversation ID, update it when you send out the note asking if they want to opt in to SMS.

You could have a second field that tracks their opt in status (Yes, No, or Blank/Not Responded), a third field that tracks when that message was sent and a fourth field to tracks number of hours elapsed.

When a new SMS arrives (which fires the Make webhook), look up the conversation in Airtable and if the existing response is blank, elapsed hours is less than 48, and the SMS text is “Yes” or “No” then you can update the opt in status in AT (and perhaps also acknowledge the message by sending them a reply)

All other conditions you simply do nothing.

Setting up a webhook event on the RingCentral side should be super easy. When you set it up it will ask for a Webhook URL, which you create in Make by adding a Webhook Trigger module in a new Scenario.

1 Like