One of the questions we get a TON at Autocode is "how do I use Google Sheets as a database?". Sometimes you don't want to spin up a MySQL database, and just want something quick and easy for your Discord Bot. In today's video we'll be showing you how to do just that! Best of all, it's totally beginner friendly and doesn't need a server or installing anything.
π Build APIs and Discord Bots using Autocode for free at https://omg.ac/autocode
π Written guide - https://omg.ac/faqguide
βββ Join us in Discord βββ
π https://discord.gg/autocode
βββ Follow us elsewhere! βββ
πΊ https://twitch.tv/autocode
π¦ https://twitter.com/autocode
πΈ https://instagram.com/autocodehq0:00 Intro
0:18 Project Review
0:37 Duplicating the example Google Sheet
1:17 Accessing data from Google Sheets
4:45 Using JavaScript Map to filter data
5:53 Sending our questions to Discord
7:20 Testing our command in Discord
7:42 Creating a Query command
10:25 Adding Error Checking
11:38 Storing frequency
16:15 Accessing the answer
17:00 Testing our code
18:00 Sending our answers to Discord
19:42 Outro
24 Comments