Fetching data from google sheet and display on telegram
Status: Closed · Asked by sdpldse on · 0 views
Is this possible that when a message is entered on telegram bot fetch the corresponding data from googlesheet and display it on the group.For example i have employ id and emply name on google sheet when i enter emply id on telegram fetch the data from google sheet and display the employ name
Is this possible that when a message is entered on telegram bot fetch the corresponding data from googlesheet and display it on the group.For example i have employ id and emply name on google sheet when i enter emply id on telegram fetch the data from google sheet and display the employ name
Yes, that's possible using Google Sheets Look Up method as shown below -
Please go through the Google Sheets Lookup tutorials which will guide you on how can fetch the employee details from Google sheets based on employ ID -
Hello I'm trying to what is done in the above video but for some reason when I lookup on the google sheet the actual rows etc do not populate.
I'm trying to update a google sheet once a google form is submitted, similar to what he did in the video.
Attached is an image of what I see in the lookup sheet...any ideas?
Step 1. Pabbly webhook triggers when google form submitted (have that linked in a google sheet)
Step 2. Google Sheet Lookup (match id)
Step 3. Update a value once step 2 matches on that same sheet.
Stuck at step 2. 