Google Sheets… Your Next Database?

Can you use Google Sheets as a database? Learn how to build a Next.js app using a spreadsheet as the data layer https://fireship.io/lessons/google-sheets-database-nextjs/

#googlesheets #js #webdev

🔗 Resources

Source Code https://github.com/fireship-io/google-sheets-database
Google APIs PRO Lesson https://fireship.io/lessons/google-apis-node-tutorial/
Next.js Full Course https://fireship.io/courses/react-next-firebase/
Google Sheets https://www.google.com/sheets/about/

📚 Chapters

00:00 Google Sheets Database?
00:35 Pros & Cons
01:15 Create a Spreadsheet
01:49 Create Next.js App
02:40 Ways to Authenticate Google APIs
03:34 GCP Service Account
04:36 Next Env Variables
05:07 Google API Auth
06:07 Query the Speadsheet

🤓 Install the quiz app

iOS https://itunes.apple.com/us/app/fireship/id1462592372?mt=8
Android https://play.google.com/store/apps/details?id=io.fireship.quizapp

🔥 Watch more with Fireship PRO

Upgrade to Fireship PRO at https://fireship.io/pro
Use code lORhwXd2 for 25% off your first payment.

🎨 My Editor Settings

– Atom One Dark
– vscode-icons
– Fira Code Font