How to Use Google Sheets as a Simple CMS

Подписаться 46 тыс.

Просмотров 9 тыс.

50% 1

Let’s raise funds for St. Jude! codinginpublic.dev/fundraiser/
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 🔗
- Google Docs: developers.google.com/apps-sc...
---------------------------------------
🎨 VSCode Theming
- Font: Cascadia Code: github.com/microsoft/cascadia...
- Theme: marketplace.visualstudio.com/...
- Icons: marketplace.visualstudio.com/...
---------------------------------------
🌐 Connect With Me 🌐
- Website: codinginpublic.dev
- Blog: chrispennington.blog
- Twitter: / cpenned
- Patreon: / coding_in_public
- Buy Me a Coffee: www.buymeacoffee.com/chrispen...

Хобби

Опубликовано:

4 сен 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 43

@cspjdbh 11 месяцев назад

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

@CodinginPublic 11 месяцев назад

Yeah, not sure how much I’ll use it going forward but it’s a nice little tool when you need it.

@gyanaranjan6526 11 месяцев назад

Finally someone made Excel as database.

@CodinginPublic 11 месяцев назад

“Database” 😉

@andersonmarquesbsb 11 месяцев назад

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 😎

@CodinginPublic 11 месяцев назад

Ha same! I was racking my brain trying to think of a simple solution and this is what I found!

@drewbird87 11 месяцев назад

Super cool. Thank you for sharing. 🙂

@CodinginPublic 11 месяцев назад

You're welcome! I was surprised when I ran across this last weekend and just had to share! Could be useful occasionally!

@Omar45 11 месяцев назад

Keep up the good work ! 🙌🏻

@CodinginPublic 11 месяцев назад

Thanks!

@hcoder 11 месяцев назад

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

@CodinginPublic 11 месяцев назад

Haha! Nice timing!

@CHILLQOUTES 11 месяцев назад

nice thank you so much keep up the goo work!

@CodinginPublic 11 месяцев назад

Thanks, my friend.

@simonswiss 11 месяцев назад

Very cool!

@CodinginPublic 11 месяцев назад

Yeah, it was a fun discovery!

@surakadotme 11 месяцев назад

thank you for this video, i love it.

@CodinginPublic 11 месяцев назад

You're welcome 😊

@mrrolandlawrence 5 месяцев назад

that is pretty nifty!

@CodinginPublic 5 месяцев назад

Don't tell the real devs, but I'm using this a lot and really enjoying it for simple little projects and forms. :) It's really nice when posting content, too.

@rodnoycry 3 месяца назад

Thank you man

@CodinginPublic 3 месяца назад

You're welcome!

@marcociau3987 4 месяца назад

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.

@ajaydeepsinghrajpoot 10 месяцев назад

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.

@CodinginPublic 10 месяцев назад

Possibly? Probably depends on how frequently the jobs would change. I have no idea how fast this is speedwise, etc.

@riigel 11 месяцев назад

do you have more complex examples using gsheets?

@CodinginPublic 11 месяцев назад

Not really. I don’t think I’d personally do something much more complex. At that point, I’d probably just use a CMS? Got any idea for how you’d use something more complex?

@BenKors 3 месяца назад

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.

@webstar722 11 месяцев назад

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😊

@CodinginPublic 10 месяцев назад

I wouldn't use this for a more complex database :) So I probably won't be making a video on it. I'm hopeful this gave you enough to get started though!

@TheCrowdel 11 месяцев назад

Will you make video about next or react again ?

@CodinginPublic 11 месяцев назад

Sure, have plans for it! I typically just do videos on whatever I'm learning/working on at the time. Been on a big Astro kick with 3.0, but have plans for more React (I've never actually done anything with Next on the channel, but I just built a site with it…so it'll probably happen :)

@GeorgeDonnelly 11 месяцев назад

LOL, fun idea.

@CodinginPublic 11 месяцев назад

Yeah, it was a nice way to provide a very low friction way to update the little landing page. Not sure on the speed of this but the site I used it on gets like 15 views a week and is literally a single page :) So figured if there was ever a time to try it, it was on this friend’s site.

@demetrycode 9 месяцев назад

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 '

@CodinginPublic 9 месяцев назад

Is this a sheet in the same google doc that is working? If so, it's probably line 3 here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-15y1D1mGKdE.htmlsi=VXqVrHXwU_DVthQ2&t=174 You'd need to account for multiple different sheet names.

@demetrycode 9 месяцев назад

@@CodinginPublic thx!!!

@cyberskul 5 месяцев назад

function doGet() { const doc SpreadsheetApp.getActiveSpreadsheet(); 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 ContentService.createTextOutput(JSON.stringify({data: result))).setMimeType(ContentService.MimeType.JSON); } "Not sure if correct but ye thas the code i guess"