Google Sheets… Your Next Database?

#googlesheets #js #webdev

🔗 Resources

📚 Chapters

00:00 Google Sheets Database?
00:35 Pros & Cons
01:15 Create a Spreadsheet
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

🔥 Watch more with Fireship PRO

Use code lORhwXd2 for 25% off your first payment.

🎨 My Editor Settings

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

[oyundimondesi]

next video:
"why i switched to powerpoint as my code editor"

[KevinVandyTech]

As someone who works somewhere where we are struggling to bring everyone out of excel hell and use real databases, I feel the need to hide that this exists.

[ruanmontelo]

"this is some serious gourmet sheet"

[lainworld]

Next video:
"Why using Google Slides is the best way in designing applications"

[isaque]

next video:
why chrome's search bar is the best JSON editor

[dtinth]

We used this technique once in production for a one-off live event website, with 1.5M visitors making 200M requests combined (100, 000 concurrent views). With a bunch of caching and prerendering in place, we only make Google Sheets API calls like once per minute, so _it does scale!_ 🚀

6:50 — To cache the result of `spreadsheet.values.get` call in-memory, the `p-memoize` package from npm can be used.

1:36 — Making a Sheet public is convenient, but not required to make it available to the app via the Service Account. At 4:05 notice how the Service Account looks like an email address. You can share your Google Sheet to that email address, and then the Service Account will have access to the Google Sheet. This way the sheet can be kept private.

Great video as always!

[pocketmage]

Next video:
"Why using google contacts is the best solution for user accounts"

[elbojoloco]

"next" level "sheet".

I could not hold in my laugh there.. What a perfect end to this perfect video.

[ajefersonstiv]

Totally NO, 😂😂😂 why u need google sheets when u can save all your data in word files with colors and fonts 🤩🔥

[Codeeee]

Next video: What made me prefer notepad over VS Code.

[stahllandon]

Thank goodness for this video. I've been wanting to set up a website for a family friend's company where they can manage their inventory that is visible on their website without needing to be super tech savvy. I came up with the idea of using Google sheets, but just didn't have the time to figure it out. This video is going to save me a lot of time. Thank you!

[chintu]

No sponsor bs, no merch gread, pure teaching, pure learning 👌🏻

[AndrewGray-natreve]

I've been doing this for years my dude lol

[fruitfcker]

0:52 If you're just going to read from Google Sheets, you can publish it as a CSV, get the URL and parse it. It won't eat up your API limits.

[PickleSurpriseVEVO]

The cursed stack

Sheets for database
COBOL compiled to WebAssembly binaries for server side
XHTML and in line css for client side/styling

[thisbloke]

We used Google Sheets a few years back to quickly build our design tables for mobile games. This allowed us to quickly rebalance and make major data changes without worrying about interfacing with the DB directly. We even built a sync tool that will do a two way sync between the sheet and the database. Was such a time saver in the end, totally recommend using it as a data admin tool.

[ModestTim]

Fun fact, you shared the sheet publicly with anyone who has the share link but you can also add your service accounts generated email to the sheets permissions instead so you don't have to make it public! This also works for anything in your google drive :)

[jonlothar]

Was not expecting this AT ALL, but man you gotta believe me when I say this is going to CHANGE MY LIFE

[adamhenriksson]

This seems like a nice solution for managing a product catalog for a store (if it's not rate-limited, otherwise things like Netlify are still infinitely better).

[vulnmachines]

In 2017, I have created my college project "Google sheet as database" and actually we had used spreadsheet as database using java servlet. In that project, through admin panel you can perform CRUD operation in googlesheet.