Astrum Cletus Discord Bot

by | Jan 17, 2025 | Personal Projects | 0 comments

This discord named Cletus was a personal project designed and programmed by me for the Astrum discord based nation simulator. This bot could take a set order form from a player, and process the game structures they wished to build and then add the structures they built to a players structures totals, as well as calculating the cost of their projects. This Discord bot was connected to a Google Sheet using Google Developers Google Sheet API. The discord bot was fully programmed in Python 3. This bot is designed to pull from a preset form with edited values, it then breaks the form down into structures, and numbers of structures, and puts those values into 2 sperate index’s. Using those index’s, and values pulled from the Astrum Master Sheet the bot can calculate how many structures a player has, how much their order cost, as well as updating their national bank after the daily income is processed. This bot allowed for an in depth, and complex playing system for players to have a unique and free experience on discord, while also taking the work load off the admins when it comes to building orders.

[INSERT VIDEO OF CODE WORKING HERE]

Setting up the Discord Bot.
I set up the discord bot using the following website as a guide.
https://discordpy.readthedocs.io/en/stable/discord.html 

Connecting the Discord Bot to a Google Sheet.
The first step in this project was setting up a google developer account to get access to the google sheet API.              https://developers.google.com/profile

The second step would be to set up the Google Sheets API.
For this you will need to go to the google cloud console at https://console.cloud.google.com/ 
Next you will select your google account.
You will then go to the project manager, which is the menu next to the google cloud logo.
You will then make a new project and name this project then hit create.
You will then select the project once its made and appears in notifications.
You will then go to the navigation menu, and select API and services, and then hit Enabled APIs and services.
Then hit the Enable APIs and services tab at the top of the screen and search for the google sheets API.
You will then Enable the google sheets API.
You will then click the create credentials button.
You will then select the Application Data, hit next.
You will then create a service account, hit create and continue, make sure to give this service account the editor role, click continue, then done.
You will then hit the credentials tab, click the service account you made, click the keys tab, click add key, click create new key, then select JSON as key type, then click create.
You will then add that JSON file to the project directory for your Python Project.
You will then need to make a google sheet, and add your service account as an editor to the google sheet.

The third step in this process is to connect the bot python code to your google sheet.
You will need to install a few packages to interact with the google sheet.
The command to do this is as follows.
pip install –upgrade google-api-python-client google-auth-httplib2 google-auth-oauthlib gspread

Below is the code needed to set up the connection to the google sheet.

import gspread
from google.oauth2.service_account import Credentials
scopes = [“https://www.googleapis.com/auth/spreadsheets”]
creds = Credentials.from_service_account_file(“[Inset name of JSON file here”, scopes=scopes)
c = gspread.authorize(creds)
sheet_id = “[Put sheet id here]”
workbook = c.open_by_key(sheet_id)
sheet = workbook.worksheet(“[The sheet you want the bot to edit”)

Once you do this your python code will be connected to your google sheet.
Here is a in-depth video if you get lost. https://www.youtube.com/watch?v=zCEJurLGFRk

Next you will need to connect your code to your discord bot, to do this you will need to the discord.py library
pip install Discord.py
You will also need your discord API Key. At the bottom of your program you will put

Client.run(Put your discord API Key here)

You will also put the following code at the top of your program

intents = discord.Intents.default()
intents.message_content = True
client = discord.Client(intents=intents)
@client.event
async def on_ready():
    print(f’We have logged in as {client.user}’)

Here is an Example a fully working discord-python-google sheet bot

import discord
import datetime
import pytz
import gspread
import re
import time as t
#Time setup
from discord.ext import commands, tasks
time = datetime.time(hour=17, minute=20, tzinfo=pytz.timezone(“America/New_York”))
#Connection to google sheet
from google.oauth2.service_account import Credentials
scopes = [“https://www.googleapis.com/auth/spreadsheets”]
creds = Credentials.from_service_account_file(“[JSON FILE NAME HERE]”, scopes=scopes)
c = gspread.authorize(creds)
sheet_id = “[SHEET ID HERE]”
workbook = c.open_by_key(sheet_id)
sheet = workbook.worksheet(“Sheet1”)
#Commands sent by user bot returns values test
intents = discord.Intents.default()
intents.message_content = True
client = discord.Client(intents=intents)
@client.event
async def on_ready():
    print(f’We have logged in as {client.user}’)
@client.event
async def on_message(message):
    if message.author == client.user:
        return
    if message.content.startswith(‘$hello’):
        await message.channel.send(‘Hello!’)
    elif message.content.startswith(‘$Google’):
        value = sheet.acell(“B4”).value
        await message.channel.send(f'{value}’)
        await message.channel.send()
#Daily Loop Test
goodNightTime = datetime.time(hour=17, minute=20, second=00) #Create the time on which the task should always run
Client.run(Put your discord API Key here)

Once you do all of this you should have a functioning discord to google sheets bot.