Hello Guys can anyone help me on how to send hourly data for example: Column A is my TIME
i want to send per row base on the time in Column A i will send it to telegram.
I know the google sheet and telegram part im just having problem before that.
Page 1 / 1
Hey! You’re almost there — since you already have the Google Sheets and Telegram part handled, you just need a step that checks the current hour and matches it to Column A.
One way to do this is by using a Zapier Schedule trigger (runs every hour), then use a Filter or Lookup Row step in Google Sheets to find the row where Column A matches the current hour range (e.g. 01:00:00 - 01:59:59). Once matched, pass that row to your Telegram step.
Let me know if you want help setting up the filter logic!
thank you for answering's my question the problem with using this i can only use 1 bot per hour.
example i use 1 bot for 01:00:00 - 01:59:59
and 1 bot for 02:00:00 - 02:59:59
so ill be using 24 bot for the whole day?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.