Discord FAQ bot with Google Sheets as a database

A Frequently Asked Question Discord bot with prefix commands. Uses Google Sheets to store questions and answers.

Prefix Commands

!list will retrieve a list of all questions from Google Sheets

.select() method

listCommand

!ask will query the google sheet for a specific question asked and provide the answer. The google sheet will automatically add a count of +1 to keep track of the frequency for each question.

The question has to be exactly the same as it is stored in the Google Sheet

.select() method
.distinct() method
.update() method

ask

!add will add new questions and answers to our Google Sheets

.insert() method
Must be in this format !add <Question> answer: <answer>

add

!update will update the answer to an existing question in our database

.update() method
Must be in this format !update <Question to update> answer: <answer>

!delete will clear a question and answer from a row

.delete() method

delete

Setup

Make a copy of my template to complete this guide. Click this Google Sheet Link. Navigate to File and select Make a copy.

Copy

Link Google Sheets: Select the 1 required red button in the Linked Resources section. Follow the instructions closely to link your account and select the spreadsheet you just copied.
Link Discord Account: If this is your first time linking a Discord account, select Link a New Resource. Please follow the instructions in the popup window carefully as it will walk you through the following steps to create a Discord Application and link it to your Autocode account:

Create a Discord Application through the Discord Developer Portal
Retrieve Your Application Credentials
add an OAuth2 Redirect
Add a Bot User and Bot Token
Once you complete the guided steps select Finished Linking. A green checkmark will appear noting that you have completed these steps.

Test it out! Head on over to Discord and test every command!

Step by Step Guide

If you would like to create this app from scratch please follow our step by step guide here that explains how to set up every part of the code.

Troubleshoot

If you encounter any issues or if you need to add any functionality to this bot please don’t hesitate to reach out! I’d be happy to help!

Ping me on ourDiscord Developer server. Username is janeth#2189