I am wanting to send a text message to customers letting them know when parts of their order have arrived at our distribution center. Frequently we’ll get multiple pieces of their total order that arrive, but not their entire order at 1 time. So the text message is to tell them X number of items of your order have arrive and this is what they are.
Right now I have it set up to where it will send a text message for each individual item. But I want to combine all items into 1 text message and list each item on a separate line.
This is an example of the data in Google Sheets. As you can see the Order # (column K) is the same on each row.
And here is the text message that sends via Twilio:
But that obviously would send 8 text messages to the customer. I want to send 1 text message to the customer, with each item listed (so 8 total rows at the bottom of the text message).
Hope this makes sense!
Best answer by PaulKortman
View original