Skip to main content
Question

Help to send Hourly data from Google Sheets to Telegram

  • July 4, 2025
  • 2 replies
  • 23 views

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. 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Forum|alt.badge.img+2
  • Beginner
  • 58 replies
  • July 6, 2025

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!


  • Author
  • Beginner
  • 1 reply
  • July 7, 2025

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?