Category: Bot Automation

  Prerequisite: You have put your credential JSON file into your Python project directory, and you must install nest-asyncio, discord, keyring, gspread and oauth2client in your Python environment. You may install these libraries by Step 1: The channel id is the last part of the Discord link on your server. It will be defined as…

  You learned how to secure your Telegram Bot app with simple authentication in the previous article. This article will teach you how to create an option list for your users to choose from. The simple question, ‘Which fruit do you like the most?’ will be asked, and three options @Apple, @Watermelon, and @Mango will…

  In the previous article, you can access and update your Google Spreadsheet using Python, and you have created our Telegram Bot and stored it on our Python password vault – keyring. Securing your Telegram Bot app against unauthorized access is essential. A simple authentication method can ensure that only authorized users can access your…

  Nowadays, we can create a Python script to automate some processes by means of accessing the API services provided by other companies. To store those credential keys and sensitive information, using a  .env file could be a solution, but you have to ensure you won’t share your .env to the cloud mistakenly. The keyring…

  In the previous article, you learned some simple Python scripts to download and update your Google Spreadsheet. Before we use Google Spreadsheet as a user authentication method for the Telegram bot, we have to get our Telegram Bot first. This article will teach you how to apply for a Telegram Bot. Prerequisite: You have…

  In the previous article, you learned how to generate a credential file to access Google Spreadsheet and share a Google Spreadsheet with your Google Cloud service account. This article will provide a simple Python script for downloading Google Spreadsheet to your local drive and updating it to the latest version. The Google Spreadsheet used…

  We have created a Google Cloud service account and downloaded the credential.json file in the previous article. This article will teach you how to share a Google Spreadsheet with your Google Cloud service account. Step 1: Create a Google Spreadsheet. Generate some data like the following image. Step 2: Click the Share button on…

  Google provides a wide range of APIs allowing developers to integrate its services into their applications. In this article, you will learn how to generate a credential key to manage your Google Spreadsheet. Step 1: Create a Google Cloud account. Step 2: Click the NEW PROJECT button. Step 3: Enter the name of your…