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.
!list will retrieve a list of all questions from Google Sheets
!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
!add will add new questions and answers to our Google Sheets
- .insert() method
- Must be in this format !add <Question> answer: <answer>
!update will update the answer to an existing question in our database
!delete will clear a question and answer from a row
- Make a copy of my template to complete this guide. Click this Google Sheet Link. Navigate to File and select Make a 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.
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