Use t.me/BotFather
Follow this tutorial: https://sysopstechnix.com/insert-data-into-google-sheets-via-oauth-2-0-using-shell-script/ download client_secret_.json and copy to src/client_secret.json
copy this one: https://docs.google.com/spreadsheets/d/1DwihAqU_0W-z4bn5LQRb3IKuw9DMaXEH-RQG-J2QeXg/edit?usp=sharing
export BOT_TOKEN=<your bot token>
export SPREADSHEET_ID=<id of your spreadsheet, can be found in the link after /d/ and before slash (/)>
run in cmd
source .env
python3 venv venv
source venv/bin/activate
pip install -r requirements.txt
python main.py
for second run,