bot link: https://t.me/ev_log_bot
- A sample google sheet is available in this path: https://docs.google.com/spreadsheets/d/1JQ7Jq30OzmjmNJRzGwAfvjTW33TX4fpBH0vDSR_rqEc (version 4)
- Instructions to setup the bot is given here: https://blog.anbuchelva.in/blog/collect-ather-logs-to-google-sheets/
- There are few changes compared to the above instructions, especially on the Script Properties
The following Script Properties to be set on the demo file.
Variable / Property | Value | Remarks |
---|---|---|
ADMIN | Your Telegram ID | A numeric Value |
ALLOWED_USER_IDS | Your Telegram ID + If you want someone else to access your bot | A numeric Value |
SSID | ID of the sample google sheet after making a copy | Get it from Address bar. Only the ID not the URL |
DRIVE_FOLDER_ID | Create a folder in Google Drive and update the ID here | Get it from Address bar. Only the ID not the URL |
DOC_ID | Create a Doc file in Google Drive and update the ID here | Get it from Address bar. Only the ID not the URL |
SLIDE_ID | Create a slide from Google Drive and update the ID here | Get it from Address bar. Only the ID not the URL |
WEBHOOK_URL | Read the instructions from blog post | Keep it safe, do not share it with anyone. |
bot_token | Your telegram bot token form BotFather | Keep it safe, don't share it withanyone. |
GROUP_CHECK | false | Not required if you are not mainting a group |
GROUP_ID | NA | Not required if you are not mainting a group |
DRIVE_ID_USER_DATA | NA | Not required if you are not mainting a group |
LOG | false | It will fill up the sheets, used only for debugging purpose |
RUN_DATE_UPDATED | 0 | This will get updated automatically |
RUN_TIME_COUNT | 0 | This will get updated automatically |
RUN_TIME_MSEC | 0 | This will get updated automatically |
for any help contact https://t.me/ather_india (not affiliated with Ather Energy).