Hi.
Here is what I am trying to achieve with little success:
Users interact with my manychat bot and provide their username, email and phone which are saved as custom fields and uploaded into a google sheet. The users in this case are requesting something which they generally have to wait a few hours to a day to get an answer on. Once we have an answer we will update the google sheet and would LIKE this update to be sent back as a message in manychat.
My issue is I have tried to set up the zap g sheet new or updated spreadsheet row > sent msg to many chat user based on the new data. I can get it to send to a specific user, but I am not sure how to send it to any random user when a cell has been updated - it will only send to the one i selected in the zap.
Should I be adding in a 3rd step to the zap to search for user name etc? Can't figure this out, please help!