{"id":582,"date":"2025-01-17T04:37:53","date_gmt":"2025-01-17T04:37:53","guid":{"rendered":"https:\/\/portfolio.wcu.edu\/asmccoy2\/?p=582"},"modified":"2025-04-15T16:36:29","modified_gmt":"2025-04-15T16:36:29","slug":"astrum-cletus-discord-bot","status":"publish","type":"post","link":"https:\/\/portfolio.wcu.edu\/asmccoy2\/2025\/01\/17\/astrum-cletus-discord-bot\/","title":{"rendered":"Astrum Cletus Discord Bot"},"content":{"rendered":"

This discord bot 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.<\/p>\n

[INSERT VIDEO OF CODE WORKING HERE]<\/p>\n

Setting up the Discord Bot.
\nI set up the discord bot using the following website as a guide.
\nhttps:\/\/discordpy.readthedocs.io\/en\/stable\/discord.html\u00a0<\/a><\/p>\n

Connecting the Discord Bot to a Google Sheet.
\nThe first step in this project was setting up a google developer account to get access to the google sheet API.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 https:\/\/developers.google.com\/profile<\/a><\/p>\n

The second step would be to set up the Google Sheets API.
\nFor this you will need to go to the google cloud console at https:\/\/console.cloud.google.com\/\u00a0<\/a>
\nNext you will select your google account.
\nYou will then go to the project manager, which is the menu next to the google cloud logo.
\nYou will then make a new project and name this project then hit create.
\nYou will then select the project once its made and appears in notifications.
\nYou will then go to the navigation menu, and select API and services, and then hit Enabled APIs and services.
\nThen hit the Enable APIs and services tab at the top of the screen and search for the google sheets API.
\nYou will then Enable the google sheets API.
\nYou will then click the create credentials button.
\nYou will then select the Application Data, hit next.
\nYou will then create a service account, hit create and continue, make sure to give this service account the editor role, click continue, then done.
\nYou 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.
\nYou will then add that JSON file to the project directory for your Python Project.
\nYou will then need to make a google sheet, and add your service account as an editor to the google sheet.<\/p>\n

The third step in this process is to connect the bot python code to your google sheet.
\nYou will need to install a few packages to interact with the google sheet.
\nThe command to do this is as follows.
\npip install –upgrade google-api-python-client google-auth-httplib2 google-auth-oauthlib gspread<\/p>\n

Below is the code needed to set up the connection to the google sheet.<\/p>\n

\n
import gspread<\/div>\n<\/div>\n
\n
from google.oauth2.service_account import Credentials<\/div>\n
scopes = [“https:\/\/www.googleapis.com\/auth\/spreadsheets”]<\/div>\n
creds = Credentials.from_service_account_file(“[Inset name of JSON file here”, scopes=scopes)<\/div>\n
c = gspread.authorize(creds)<\/div>\n
sheet_id = “[Put sheet id here]”<\/div>\n
workbook = c.open_by_key(sheet_id)<\/div>\n
\n

sheet = workbook.worksheet(“[The sheet you want the bot to edit”)<\/p>\n

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

Next you will need to connect your code to your discord bot, to do this you will need to the discord.py library
\npip install Discord.py
\nYou will also need your discord API Key. At the bottom of your program you will put<\/p>\n

Client.run(Put your discord API Key here)<\/p>\n<\/div>\n

\n

You will also put the following code at the top of your program<\/p>\n

\n
intents = discord.Intents.default()<\/div>\n
intents.message_content = True<\/div>\n
client = discord.Client(intents=intents)<\/div>\n
@client.event<\/div>\n
async def on_ready():<\/div>\n
\n

\u00a0 \u00a0 print(f’We have logged in as {client.user}’)<\/p>\n

Here is an Example a fully working discord-python-google sheet bot<\/p>\n

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

Client.run(Put your discord API Key here)<\/p>\n

Once you do all of this you should have a functioning discord to google sheets bot.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

This discord bot 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 […]<\/p>\n","protected":false},"author":1963,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[17],"tags":[],"class_list":["post-582","post","type-post","status-publish","format-standard","hentry","category-personal-projects"],"_links":{"self":[{"href":"https:\/\/portfolio.wcu.edu\/asmccoy2\/wp-json\/wp\/v2\/posts\/582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/portfolio.wcu.edu\/asmccoy2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/portfolio.wcu.edu\/asmccoy2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/portfolio.wcu.edu\/asmccoy2\/wp-json\/wp\/v2\/users\/1963"}],"replies":[{"embeddable":true,"href":"https:\/\/portfolio.wcu.edu\/asmccoy2\/wp-json\/wp\/v2\/comments?post=582"}],"version-history":[{"count":2,"href":"https:\/\/portfolio.wcu.edu\/asmccoy2\/wp-json\/wp\/v2\/posts\/582\/revisions"}],"predecessor-version":[{"id":586,"href":"https:\/\/portfolio.wcu.edu\/asmccoy2\/wp-json\/wp\/v2\/posts\/582\/revisions\/586"}],"wp:attachment":[{"href":"https:\/\/portfolio.wcu.edu\/asmccoy2\/wp-json\/wp\/v2\/media?parent=582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/portfolio.wcu.edu\/asmccoy2\/wp-json\/wp\/v2\/categories?post=582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/portfolio.wcu.edu\/asmccoy2\/wp-json\/wp\/v2\/tags?post=582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}