Match UserID (phone number) to Google Sheets phone number

(Ibrahim Ayub) #1

hello, i’m creating a sms chatbot (using a Twilio #) and when receiving a new message, I’m trying to get the user id (phone #) and match it to the associated row in google sheets. I’m getting the error “Google Sheets had a problem searching with given parameters. The name of the column might be not supported.” I think it’s an issue with the “+” at the beginning. I tried adding that to the google sheets # but still not working.

(Ibrahim Ayub) #2

figured out a workaround - used the text (string) service to split the userID to remove the + and used that output to search the google sheet

1 Like