Google Sheets… Your Next Database? 

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

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.

"this is some serious gourmet sheet"

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

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

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

This is some next level sheet! 👌

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!

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

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

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

I've been doing this for years my dude lol

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!

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

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 :)

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

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.

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.

We need FireSheet

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

GERN stack. 😂

Holy sheet this is awesome!

Very quickly becoming my favorite dev channel

next video: "Why Google Docs is the best IDE"

Man I love your videos, keep up the good work, I find it very useful!

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).

A WARNING TO ANYONE THINKING OF ACTUALLY DOING THIS! (even for prototyping): The caveats mentioned in this video cannot be overstated. I actually did some freelance work on an existing app built fully around a google sheets "database", so would like to share my experience. The app was only being accessed by a few dozen users at a time but was already grinding to a halt in production due to the API rate limit. Queries would randomly fail with unhelpful errors, leading to endless retries and a terrible UX. Even when not rate limited, both read and write queries are many, many times slower than a real database. I would argue it isn't good for anything, even prototyping, because it makes the feedback loop painfully slow. I ended up having to rewrite the entire backend of the mentioned app because it was tightly coupled to the sheets API. If you are going to use this for prototyping (and I would strongly recommend you don't), you MUST use the repository design pattern, otherwise, you will bake in the dependency on sheets and likely end up shipping it to production, which trust me, you really do not want to do at any scale.

Incredibly high quality content!

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.

I was looking for this yesterday and you made this video 🔥🔥🔥

The real mystery is how can you release back to back 7min edutaining videos. Always amazing 🙏⚡️🔥🌊

Thank You so much! it was actually better than looking over the boring documentation.

jeff you are love

Thanks for always informing us of the latest hot sheet

Love your Next.js content!

wow, this is so nice, I will definitely give it a try, this weekend. thanks.

Just what I need. Thanks :)

The information is useful and the puns are hilarious 😊

We use Google Sheets in production to interact with Firestore and change data in the Firestore DB. Any changes in the Firestore DB would be reflected in the sheet. We used something a lot simpler though called Appscript.

I'm so happy I subbed to this channel lol

I just spent 3 hours trying to figure out the auth part of this. Thanks a ton.

And here I was thinking of making a series of using GQL along with Firebase for a better Read experience. Guess we'll use Sheets instead. Dope video Jeff!

The most underrated channel, this guy is working as an amateur, not as a professional who only works for money he researched and mix different topics that nobody can use in their company love you bro ❤

thought it was a super early or a bit late april fools vid, but it wasn't and i love it !!

Oh my, this is perfect for a personal project of mine

I've been waiting for this sheet for so long..

Wow this was a great vid! thanks 🙏

Would've made it more realistic if you were developing Google® Sheets based server in Google® Docs with Google® Golang & store them in the Google® Drive😅

Your content is dope ❤️

Our team at Microsoft already using it for more than a decade, love to see it in action by new developers

Cool. Thanks for sharing.

Holy crap. I did this as a project in college to make it easier for random people to manage a DB. I thought it was a really jank idea but this is much better explained. Kind of gave me some nostalgia.

I've used it before with an Android app, but it becomes very slow when amount of data increases, so I changed to Firebase.

Holy sheet this is amazing!!

that ending was such punch to the guts amazing, 10 out of 10

Hahaha man! Never thought it like that, love your videos

Very helpful thanks.

I actually used google sheets in a hobby project last year I skipped to whole authentication process though. Each sheet has a public readonly API that can be used if the sheet is shared publicly. Just make sure only you can edit it

sheets.new is a quicker way to create new sheet

About 3 years ago I wrote a site that used the HTML directly from the sheet to render components directly into the front end, no server. Wildest thing I've ever done and the site is still operational.

Your sheet is the best sheet of all the sheet!

Next level 👏

I love the "Next" level "Sheet" and the title Your "Next" Database. Anyway, great video!

A few days ago working on a Google Sheets plugin I thought exactly the same thing! If only Google App Script were a little bit more stable...

Thank you for the advanced tips it helped me with my project.

Very nice!

Excellent!

Your course on next js may have changed my life

Missing these types of videos. I don't like tech news, because somewhere or the other I got to know about them, but videos like these are priceless @fireship

Thank you!!

Thank you!

I have a client who's data I've been saving in GS for a long time. I was looking to create a frontend for the same. Finally found the best solution. Thank you

You can also write a script in the google sheet itself and then just call it like an API. We actually recently implemented a similar thing. The sheet acts as a Dashboard for our clients.

I did the same thing using PHP. great stuff

That is some next level sheeeeet!

Damn i just needed this, how can you read my mind

Hell yeah. I do this as well but I do static generation with it. Gotta go fast on those CDNs

That's some next level sheet bruh

great stuff

Oh yeah, I used Goggle sheets for one of my projects too. But the API limit was a huge issue

wow, this is some next level sheet

Beyond the fact that this is totally awesome, I just learned how to authenticate any service in GCP for my personal acct and wire up a boilerplate Next.js project. Three for the price of one!

Connecting to google apis using a service account key is one of the most pain in the butt things I've ever done. This is a great tutorial on how to do that. I wish I had this a long time ago.

The acid compliant bit got me laughing.

This is the equivalent of using HTML/CSS instead of professional Image Editing software, which is something I definitely, 100% do not do. At all. Ever. Fantastic video as always!

NEXT LEVEL SHEET

creating a 'holy-sheet' next app 😍

Google sheets is the perfect Dynamic Config or a database for product details if you're building a site for a mom and pop shop (allowing them to update themes and product details on the fly)

I have learnt a lot of new things that I have never worked with from your videos, like AWS, nginx, kubernetes, graphQL(and other dbs), typescript to name a few. One thing that I don't understand is how they work together. I would really love to see a video where you design a mock system using all of these (and possibly more) and explain each of their roles and why you chose it (kinda like your reverse-cloud migration video using raspberry pi). Whenever I think of a software architecture I think of them as several layers that interact with each other. However, I am unable to assign which layer what belongs to by watching a stand alone tutorial about a single tool. Btw, I am a college senior pursuing CS major and I love your content. Thanks for all the awesome contents.

You read my mind.

This is so disgustingly hacky ...I love it

that acid cat lol

what do you do if you dont have an app engine default service account?

Please do a series about this topic ,iam waiting ❤️❤️

I was googling this on Tuesday 😩 how did you know

Could you do a video on setting up an ELK stack? Its really cool and powerful stuff but theres a few stumbling blocks if you dont quite understand it

Hey, would be awesome if you could cover some more niche js stuff, like generators, Proxy or some cool esnext features

Haha I was just thinking of this yesterday

the end is SAVAGE jajajahahajaja

This is a great idea, think of all the companies down the road trying to decouple and re-normalize their data inside these piece of sheet databases!