How to Use Google Sheets as a Simple CMS

While not ideal for anything complex, Google Sheets can act as a very simple CMS. In this video, I'll show you how to set up a simple API endpoint that returns the results of a Google Sheet as JSON.

🔗 Key Links 🔗

---------------------------------------
🎨 VSCode Theming

---------------------------------------

🌐 Connect With Me 🌐

[cspjdbh]

This isn't something I was expecting learning today, but it does bring ideas for other things 🤔

[gyanaranjan]

Finally someone made Excel as database.

[andersonmarquesbsb]

Unexpectedly useful. Haha. I don't think I'd ever search for this, but it gives me some ideas already. Will try to deploy something this week! Thank you 😎

[hcoder]

I was thinking something like this today. Totally shocked! 🎇

[CHILLQOUTES]

nice thank you so much keep up the goo work!

[surakadotme]

thank you for this video, i love it. <3

[marcociau]

Awesome. Currently I use Google Sheets for project budgeting and then, imports my tables to my project proposal.. Maybe I con follow your approach to automate task.

[BENKORS]

Instead of this method I pulled the data into my main server using a google service account json and broadcasted using a self hosted api. Then pulled into the other site I was running. I like this google scripts method. Might give it a go. I think there are higher limits when using the service account though.

[ajaydeepsinghrajpoot]

Do you think it would be a good idea to use this as a cms for a job posting web app. I want to post only selected few jobs and most probably it'll be done manually.

[riigel]

do you have more complex examples using gsheets?

[webstar]

Please, can you make a full video on how this google sheet can be transformed into a complex database with more than 4 API endpoint, it will really be nice for my learning, Thank you😊

[TheCrowdel]

Will you make video about next or react again ?

[demetrycode]

First time I did it when this video came out - worked and works just fine. But when I create a new sheet and make same steps it throws me an error: Unexpected token '<', "<!doctype "... is not valid JSON

If I give URL of the first time made sheet into fetch method - works w no errors. It just doesn't want to work with all new sheets
any idea why this happens?

[cyberskul]

function doGet() {
const doc
const sheet doc.getSheetByName("Hours");
const values sheet.getRange(1, 1, 5, 2).getDisplayValues()
const result values.map((h) => ({
name: h[8],
hours: h[1]
}))
return
}


"Not sure if correct but ye thas the code i guess"

[raldskie]

I was intrigued with the google sheets.
But you explained it so well
And im invested to give it a try 😎