How can i make it so a customer can only receive 1 text. SMS automation

[AlteredSphere]

Im trying to set up a scenario for my qr code sms campaign.

Customers are signing up by an in store qr code and incentivised to do so because of a reward (20% off coffee) you get for signing up.

The flow is landing page gathering customer data, to sheets, to sms module.

The problem i’m having is that i only want 1 sms to be sent per customer so that no one can redeem the offer more than once. The scenario i have doesnt seem to work, it just sends a text every time. Any help would be much appreciate. Thanks

The current scenario setup is this:

Webhook gathering customer data from landing page (carrd), then to a search rows google sheets, then a filter with ‘18. Total number of bundles’ numeric operator: equal to 0. Then a google sheets add row sow if the number doesnt already exist it will be added to the sheets. Then finally sent to an sms module to send out the offer.

[Donald_Mitchell]

Hello @AlteredSphere and welcome to the Make Community!

Phone numbers can be tricky since they need to be normalized before storing and using them.

Make has a Phone Number module to help make sure your phone numbers are standardized, you may be able to use that after the Webhook and before searching your Google Sheet.

[AlteredSphere]

Hi

Thanks so much for the response. Ill have a look at that then.