Is that what you were looking for? Or the script way? Ahh, I think I know what your refering to. Ok, so what I did was gather every carriers email to text address. I listed them here.
With those I just have everyone in the app add their phone number and choose one of these carriers from a drop down list. It’s mandatory for our employees. and i use a simple vlookup to lookup the send address to the carrier list and append that to the phone number. In their employee list theres a column for phone number and carrier. then theres the notification column. The notification column has this formula in it:
=ARRAYFORMULA(IF(Q2:Q=“”,“”,R2:R&VLOOKUP(Q2:Q,‘MISC TOOLS’!Y:Z,2,FALSE)))
The “Q” column is the carrier column. the “R” column is the phone number column and the vlookup just finds the end of the email/text. I have been since just using a script to send emails which in reality turn into notifications but webhooks just eliminates the scripts for button press notifications. I still need the scripts for live notifications.