Hi everyone,
I am struggling with my scenario for Telegram <> Google Sheets connection.
I need to do the following:
- Telegram sends a name in text format and a command
- Google sheet searches in a spreadsheet and gives back a value (numerical score) that corresponds to the name, similar to how vlookup fetches the value from a particular column on the right of the value
- Telegram returns a message with this new value
I’ve already read through this post Telegram - Google Sheets Scenario, however, still can’t understand how to set up a condition that would check the value received from Telegram and compare it with a value in a Google Sheet column.
Will be immensely grateful for an advice on that