Google Sheets… Your Next Database?

[@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.

[@MM-vr8rj]

I'm currently working on my first ever paid assignment and the people I have to deal with had a terribly big excel sheet that they called a 'database'. I was shocked and advised they needed to hire another person that could convert that into an actual database. I ended up only working on the frontend thank god.

[@MM-vr8rj]

@@ssholum I think even Excel experts hate Excel

[@MM-vr8rj]

@@eric.m5790 huh GitHub is from Microsoft? And they didn't develop GitHub but simply paid for it? Lol

[@MM-vr8rj]

@@lucasbudega too late, they already hired someone =)

[@VITORB82]

@@MM-vr8rj as an ex Excel "expert", Excel sucks. As soon as i could i changed careers.

[@oyundimondesi4541]

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

[@kjn5991]

actually, there is a video of some dude recommending Word as a code editor 😂

[@phatakom]

@@kjn5991 joma 😂😂

[@akarshitbatra1754]

Actually word not pp

[@alegian7934]

it *is* turing complete

[@Anonymous-XY]

@@phatakom 😂

[@ruanmontelo]

"this is some serious gourmet sheet"

[@elgatito00]

😂😂

[@vishaljaiswal5000]

Google fiction

[@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!

[@deveshp9998]

Great results 💯 manh can you share some resources or code snippets on how you managed to do the caching bit?

[@KaiCodingJourney]

U r genius!!!!

[@VadimTi320]

To cache results is a great idea, since google doesnt provide a way to query data in sheets, and if you don't know which number of row of the sheet you data at you basicaly have to get all data of sheet and filter results. I had a project where estore had its products data in sheet, and app had to display data by a product SKU which was in a column. Ended up saving syncing sheet data in a real database every minute and query that database (which opened door for more advanced app functions)

[@noobgam6331]

it does not scale. caching is not scaling. Also don't forget to use a library for something that can be achieved in 2 lines of code, very classic for javascript development

[@ConnectidTechTalks]

Thanks for the info about keeping it private! Awesome!!

[@isaque1764]

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

[@holonaut]

not gonna lie, I use Chrome's console as my main json renderer

[@chotai]

@@holonaut isn't it devtools? I'm using same LoL

[@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!

[@lainworld]

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

[@cferracini]

but... figma is free (with limits but free)

[@georgle]

Lol using actual mockup software can't be me! But in all seriousness, using Google Slides is actually pretty decent for mockups, especially when collaborating with a less technical team

[@rakeshchowdhury202]

Um. I actually used to develop ui when I started c# in 2015

[@donaldli4755]

I think I saw someone built circuits using PowerPoint...

[@ricoaw500]

I'm using it before I know Figma and Adobe XD. lol

[@mirashif]

This is some next level sheet! 👌

[@musicgaines7170]

Thumbnail said that

[@rafadydkiemmacha7543]

Oh sheet!

[@fruitfcker5351]

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.

[@thallysondias]

nice! im just need this!

[@markussukhaboon9299]

And no credit card to set it up, if i understand it right.

[@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 🤩🔥

[@NPC-kw4sb]

Sheets has colors and fonts too

[@zeroww7]

How about writing the data down on paper and manually sending back the requested data by retyping every single time like things are supposed to be?

[@migueldomingos4570]

@@zeroww7 how about writing that data in tatoos made in your skin so that it is never lost unlike paper that can fly away?

[@kbabe3915]

@@migueldomingos4570 How about just remember 4Head

[@migueldomingos4570]

@@kbabe3915 That is way too non painless

[@pocketmage124]

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

[@Oo-d8q]

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

[@animatedzombie64]

😂 exactly,

[@kristopherrobin4001]

Big brain

[@Andreashoornstra10]

Notepad? Lame. I prefer coding into a stone tablet using hieroglyphs.

[@mythoughts1679]

Ram Size

[@nikeshthakor406]

I use nano file to code

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

[@Fireship]

Good call!

[@Coopervise]

Tried it out & this works. This small fact would probably convince more people to try it out rather than making your data public.

[@PickleSurpriseVEVO]

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

[@baggern]

Client-Server communication via SOAP over WebSockets

[@legrinu]

Sounds good, have many clients running this Stack, I call it the India street Stack

[@diablo.the.cheater]

Hey at least such stack would be secure as heck no hacker would even believe such stack to exist in the first place

[@yokowasis]

now, we have tail wind css and bootstrap 5, which is basically in line stylesheet.

[@TacticoolMobius]

I never worked on the Excel/COBOL stack but I already have software dev generational PTSD reading this.

[@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.

[@chintu2691994]

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

[@patricsteiner8483]

no useless intro, no cancer thumbnail, no talking boring and irrelevant shit. i hate people.

[@jonlothar6126]

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

[@yolo-mb4cy]

👀

[@satyampatel3713]

👀

[@AndrewGray-natreve]

I've been doing this for years my dude lol

[@dailymeow3283]

Seriously, what could be a good use of it,,, i mean i can make a json file in the backend and serve all the data

[@ImperiumLibertas]

@@dailymeow3283 not having to manage a whole backend for simple content. Although this really should never be used for anything important.

[@deebakapadia]

@@dailymeow3283 I could use it to serve some static files

[@sanjithudupa]

Haha me too. It feels weird to use it sometimes but in a pinch it works really nicely lol (when I am too lazy to self host a db or use something like mongo). But it become impractical after that

[@hakimramzani9174]

@@dailymeow3283 usually the excel comes from user or something

[@thesecopsgroup]

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.

[@adamhenriksson6007]

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

[@andrewdddo]

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

[@adityavsx]

@@tsnos2 wasn't it Microsoft doc? the JOMA one?

[@h3ftymouse]

Guess he's going for a job at Google, good on him

[@omminnoremac]

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.

[@awakenwithoutcoffee]

hi, im a beginner developer in need of a database that can store unique codes for a store franchise. What database do you recommend ?

[@8infinito8]

​​@@awakenwithoutcoffeeMySQL or PostgreSQL.

[@the.codepreneur]

+1 for the repository pattren so it is easier to switch to an other data store with ease

[@rkpinata373]

@@awakenwithoutcoffee supabase

[@Famelhaut]

lmaoooo

[@rabik_dev]

Holy sheet this is awesome!

[@ToddDunning]

Very quickly becoming my favorite dev channel

[@RajvirSingh1313]

We need FireSheet

[@goeland4585]

Sheet is Fire, yo

[@thetrends5670]

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

[@Superuser-r1y]

Can it handle 100k user per second?????

[@briball423]

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.

[@parthkharwar69]

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.

[@FlutterMapp]

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

[@AnshumanKumar007]

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.

[@timsecond]

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

[@CompanionCube]

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

[@saitejach9360]

There are some things which you have missed 1. if you are using a service account you need not make the sheet public. just give access to the service account. 2. Google sheets has a text per cell limit of 50,000 which is big but if you want to store big JSON it's a bit of trouble. 3. Also OAuth2 is more prefered than a service account since you cannot access sheets created by service accounts whereas sheets created by OAuth are easily viewable. 4. Also if anyone wants to use it only on the client-side and not on the server-side. There is an npm package called gapi-client which is helpful but really painful to use. 5. Also if you are going to use public google sheets then there is no need to authenticate or creating a google cloud account. You can directly make a call to the sheets.

[@imtiazbhimji123]

The last point was a violation. Lol. Appreciate the feedback though!

[@pettiboy]

Incredibly high quality content!

[@erdum]

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 ❤

[@Secreto31126]

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

[@arytiwa4351]

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

[@vivekagrawal4086]

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

[@FilledStacks]

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!

[@vladimirtsarapkin2840]

You may love google sheet or hate it but some bi4 s clients want to use it. Video is straight to the point. Thank you!

[@DanishShakeel]

GERN stack. 😂

[@nynra6584]

That is some serious programming skill 😯 1:52 > npx create-next-app holy-sheet

[@mohammadbasyouni7171]

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

[@itsjoshlee]

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

[@rahulgandla4948]

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

[@boiimcfacto2364]

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!

[@yunger7]

"Next level -shit- sheet" I am pretty sure the whole purpose of this video was to make that joke in the end.

[@ZenAzou]

that would actually be awesome XD

[@akhilnarayanan7182]

1:58 Holy sheet

[@Jono997]

It's better when you remember he was using a Next.js app to demonstrate it, so it's literally a Next level sheet.

[@brianevans4]

Your course on next js may have changed my life

[@ammartahir5871]

jeff you are love

[@himbary]

Thanks for always informing us of the latest hot sheet

[@nodisponible8]

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

[@krtirtho]

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😅

[@farhanaditya2647]

Lol

[@cubeofcheese5574]

UI Prototyping: Google Slides/Draw Code Editor: Google Docs Database: Google Sheets Hosting: Google Drive Dev Computer: Google Pixelbook

[@jesuszagal2737]

Hotel: trivago

[@weshuiz1325]

The internet: Nooo you cant use google sheet as a database Data Scientist: data go rrrrrrrr

[@ВасильКобрій]

The information is useful and the puns are hilarious 😊

[@ZachSuerdieck]

Your sheet is the best sheet of all the sheet!

[@Conspiraceez]

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

[@Hyperboid]

This also means you can use sheets as file storage if you base64 encode your binary files

[@boomerangfish3558]

I'm so happy I subbed to this channel lol

[@santanumukherjee4108]

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

[@shaileshaanand]

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

[@znacly1184]

Not acid compliant, but also not base compliant - not a dbms. What about synchronization (data races)? What occurs if two users request to update the same cell at the same time? Whos request "wins"? What happens to the additional request? Are data race conditions a concern? If so are they resolvable?

[@762dracoAK]

What do you recommend?

[@mr2octavio]

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

[@siddhantgadre]

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.

[@oskrm]

sheets.new is a quicker way to create new sheet

[@Fireship]

🔥🔥🔥

[@alegian7934]

@@Fireship 🔥🚢

[@modernkennnern]

Works for all other google software (Docs.new, sheets.new etc..)

[@farhanaditya2647]

wow

[@explosionimplosion4679]

docs.new and slides.new too!

[@soyitiel]

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

[@JonWoo]

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.

[@jsramraj]

Why so much hate comments? This tutorial showcases how you can use google sheet as a database and how you can access the google sheet data via rest api's. That doesn't you should all do that. This can help someone who might work on a hobby project without money to buy servers.

[@jazzmaster89]

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!

[@troglodytto]

6:25 I was expecting him to say "... followed by a BANG! ...."

[@massimo8408]

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

[@krellin]

I use google sheets as admin console, all backend services have separate sections in a single sheet, where i can configure things + see some stats and metrics that services update themselves, perfect and super easy to do no need to write an entire admin web app or something...

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

[@sherlockluk2225]

I really used Google Sheets for the database of my school project(about doing mobile app), glad that I am not the first person doing it

[@ronrupp_]

Love your Next.js content!

[@YonatanToker]

Just imagine putting Google Sheets database in your resume and employers read it😂

[@gregorymoore2877]

Only do that if you don't really want that position.

[@Coopervise]

Thank you for making a video for the solution that's not about using a third party with an affiliate code.

[@guitarheart94]

this guy is single-handedly teaching me what my professors should've taught me in college lol.

[@daddybruce8084]

That's some next level sheet bruh

[@alexleung842]

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)

[@renepromesse7410]

creating a 'holy-sheet' next app 😍

[@jimbob2629]

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!

[@macx4763]

This is so disgustingly hacky ...I love it

[@JohnnyAlex2u]

even though my car broke down this morning when I heard “ This is what I would call next level sheet “ it just made me forget all of it

[@lamphrangmilamin2966]

Your content is dope ❤️

[@AndyChamberlainMusic]

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

[@harnoorsingh1567]

At 2:00 😂. "Holy sheet"

[@JuSSayZ]

Tell me why when I was looking for database solutions my first thought was “I wish I could just use excel”

[@ilikememes9052]

Welcome to Google Onsite Interview Interviewer : Hey what Database you use for your projects. Candidate : I use Google Sheets... Interviewer : STOP! You are hired.

[@paci]

Find this implementation rather complicate when you can create an Apps Script to generate a json api from a google sheet and read the data from it.

[@pazu_513]

Let's say you're a freelancer making small websites and you have customers that want an easy, familar way to update the text content on their site. Wouldn't this be a really good solution for that kind of use-case?

[@Yazidn]

This would really be ideal for small personal custom projects when you're the only user and want to make your life easier!

[@nerminskenderovic]

How would you use this with React Query? And how would you update the spreadsheet?

[@onthecodeagain]

I once made a survey using sheets as the datastore. It worked really well! was just a bit slow..

[@mariogehnke7460]

1:38 that's not necessary: You don't have to share the Google Sheet publicly. Instead you can share it with you default service account. :)

[@ppmch]

How so?

[@ganeshdeshmukh8020]

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

[@FilipCodes]

Just what I need. Thanks :)

[@reevanthlama5278]

Holy “sheet”!!! 👀👀😝

[@rafaelpernil]

I did that in a dumb Android App of a contact agenda. It was pretty fun!