Awesome
Tele_Sheet_bot
This Bot is written in Python with pyTelegramBotAPI.
An Example of the Google Sheet. You should follow this format for the code to work. Ideally just make a copy of this Google Sheet. https://docs.google.com/spreadsheets/d/1mE0O-fxkrgoQ2FTlSNbO1CPgEU0-VWbdz9QOQKA1OmU/edit#gid=0
Installation
First of all, you need to install the pyTelegramBotAPI.
sudo pip install pyTelegramBotAPI
oauth2client – to authorize with the Google Drive API using OAuth 2.0 gspread – to interact with Google Spreadsheets
pip install gspread oauth2client
Finally clone the repo
git clone https://github.com/JoachimStanislaus/Tele_Sheet_bot
After you clone, you need to add a few tokens.
This should be your Token received from Botfather.
bot = telebot.TeleBot('your telebot token from the botfather ')
https://www.wikihow.com/Know-Chat-ID-on-Telegram-on-Android
TelegramUsers = ["your telegram userid in integers "]
This guide will teach you how to get your json key and setup the gspread portion. https://www.twilio.com/blog/2017/02/an-easy-way-to-read-and-write-to-a-google-spreadsheet-in-python.html
credentials = ServiceAccountCredentials.from_json_keyfile_name("The name of the json key you downloaded earlier.json", scopes) #access the json key you downloaded earlier
Pretty Self explanatory... just change it to the name of your spreadsheet.
sheet = file.open('Name of your spreadsheet') # get the instance of the Spreadsheet
Usage
Once you're done setting it up and the bot is running.
Do /add to add and it will prompt you with several questions.
Running the Bot
You can one-time run the Bot with the command
python Tele_Sheet_bot.py
This isn't recommend. Use something like screen to hold the Bot. screen -S SheetBot Then just retype the command and you are finished!
Contributing
please email hello@joachimstanislaus.com first to discuss what you would like to change.