Telegram bot to get data from Google Sheet, checks the very first column for time (in hours) and returns rows where time matches
1. Create Google Sheet with the data. The very first column is treated as a key for the start time of event. You may have multiple rows with the same key, all of them they will be displayed then.
| Start Time | Where | Description | Author |
|---|---|---|---|
| 9 | red room | first talk description | John Doe |
| 10 | red room | talk about javascript | Jack Black |
| 11 | red room | some marketing talk bs | William White |
| 9 | green room | some keynote talk | John Baker |
| 10 | green room | networking and coffee | Bob Will |
| 11 | green room | some use case for node.js | Diana White |
3. (for cloud9) Create account on c9.io, create Node.js workspace and run the command git clone [email protected]:emirn/google_sheet_reader_bot.git
4. Register telegram bot (send /newbot commmand to register bot with https://telegram.me/BotFather in Telegram) and copy token for newly created bot.
module.exports = {
'TelegramProductionURL': 'https://myapp-bot-app.herokuapp.com/', // your heroku app do not forget trailing "/" !!
'TelegramToken': '<telegram token here>', // Telegram token you got from @BotFather
'googleSheetKey': '<google sheet key>', // the key of the google sheet (should be public!), extract key from the google sheet doc publich url
"confTimeZone": "Europe/Berlin" // time zone of the conference so the bot could output events for the current time in the form like "Europe/Berlin", see http://momentjs.com/timezone/
}
8 (for heroku). Push the code to heroku using commands git add ., git commit -m "initial version" and then finally git push
9 (for cloud9). Simply run the bot on the workspace using the command node .. IMPORTANT: cloud9 is mostly for development purposes, if you want to run the bot as product then consider running on Heroku too.
Congrats! Now you may send the command like 10 to the bot and it will send you all events which are taking place at 10 o'clock according to the spreadsheet.
You may change the spreadsheet and the bot will take new data form the spreadheet online.
- add the bot to the Telegram using the link
https://telegram.me/yourbotwhereyourbotwill be replaced with your actual bot name - send 'Hi' to the bot to show events taking place at the current time (in the timeone defined by config.confTimeZone)
- or send the time in a form of 12 for 12 PM, 14:43 for 2.43 PM etc.
- the bot will list all events taking place at time entered
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent