bh notifier written in python

bh-notifier-python.py

import time
from datetime import datetime, timedelta

import dateutil
import pandas as pd
import schedule
import telebot

chat_id = '000'
token = "[token]"
bot = telebot.TeleBot(token)
csv_link = "https://docs.google.com/spreadsheets/d/[sheet-id]/gviz/tq?tqx=out:csv&sheet=Sh1"


def get_last_submission_date():
    data = pd.read_csv(csv_link)
    times = data['Timestamp'].dropna()
    last_time = times[times.size - 1]
    return dateutil.parser.parse(last_time).date()


def notify_about_form(days=0):
    def func():
        last_submission_date = get_last_submission_date()
        date = datetime.now().date() + timedelta(days=days)
        if last_submission_date < date:
            bot.send_message(chat_id, f"Please, send your form for {date}")

    return func


schedule.every().day.at("21:00").do(notify_about_form())
schedule.every().day.at("23:00").do(notify_about_form())
schedule.every().day.at("01:00").do(notify_about_form(days=-1))

while True:
    schedule.run_pending()
    time.sleep(1)