Overview • Installation • Run Command

SPC BOT is a discord bot I made to automate verification process for the campus placement in RVCE.

It's main job is to use the data present in google spreadsheet and verify it with the data of responses from a downloaded .xlsx file.

The prefix for this bot is -. Use command -help to explore different commands.

The recommended python version for this bot is 3.8+. To install the packages used in this project, you can use the following commands in the command prompt.

pip install discord.py
pip install gspread
pip install oauth2client
pip install openpyxl
pip install os
pip install requests
pip install dotenv

You need to create a project in the Google's Developers Console.

After creating the project go to the marketplace and install the following apis:

• Google Sheets API
• Google Drive API

To access the google spreadsheet you want to work with you will have to create a Google Service Account. Give editor access to this account in the spreadsheet you are working on. Download the service account API key in JSON format and upload it in your working directory.

To make your own bot go to Discord's Developers Portal and create an application. Go to OAuth2 and select bot then enable all the text permissions, you will get a link and this will be the invitation link for your bot. Copy the token for your bot and create a .env file in the working directory. In the .env file type TOKEN=yourcopiedtoken.

python spcbot.py

After the bot is online, you can use the -help command to get started.