This bot update Google Sheets from Telegram bot and also sends an email as confirmation
- Id of the Google Sheet. (It is embeded in the url of google sheets)
- Web-app Url (You need to Generate Through google script)
- Telegram Bot TOKEN
- Gmail Account
var token = "<YOUR-BOT-TOKEN>";
var webAppUrl = "<YOUR-WEBAPP-URL"
var ssId = "<SSID>"
- Make a google script.
- Copy-paste the bot.js code in you script and fill the above details carefully.
- You will be poped up for google authentication to complete it.
- Add items by sending a message to telegram bot like "$500 FRUITS BANK"