Help with Twilio when user replies 'STOP'

How To
1

I have a scenario that sends out texts via Twilio and works perfectly.

The numbers are stored in a Google spreadsheet.

I also created a webhook in Make.com that will accept any response from the user like stop, start, restart, etc.

Problem is, the only way I know how to identify who just replied is with the phone number.

However, here’s how Twilio displays the phone number: +1xxxxxxxxxx

But in my spreadsheet, the number format changes based on who entered it.

Sometimes the number is like this: (xxx) xxx-xxxx

Sometimes the number is like this: xxx-xxx-xxxx

etc.

So I need some other way to identify who replied with ‘stop’ so I won’t keep sending them texts in the future.

Is there any kind of unique ID value that Twilio assigns to a specific number that I can use?

Thanks

1 Like
2

Welcome to the Make community!

Please provide example output bundles of the trigger modulesby running the scenario (you can also get this without re-running your scenario from the History tab).

Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.

490×338 23.5 KB

A. Upload as a Text File

Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking on this button:

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved.

This will allow others to better assist you. Thanks!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3

Solution: I had the client reformat all phone numbers in the spreadsheet to the following format:

(xxx) xxx-xxxx

Then, in my scenario, I used the Phone Numbrer module to format the user’s number.

I then used the National Format version to match numbers in my spreadsheet.

3 Likes