css Audio - Active file-generic CSS - Active Generic - Active HTML - Active JS - Active SVG - Active Text - Active file-generic Video - Active header Love html icon-new-collection icon-person icon-team numbered-list123 pop-out spinner split-screen star tv
CodePen probably won't work great in this browser. We generally only support the major desktop browsers like Chrome, Firefox, Safari, and Edge. Use this one at your own risk! If you're looking to test things, try looking at Pens/Projects in Debug View.
user profile image

Working on a site for a restaurant where the owner needed a 'CMS' to edit the specials menu on a daily basis. Rather than use a bloated CMS like wordpress/drupal/joomal etc, I thought it would be slick if they could just use a simple google sheet... This allows the site to remain flat from a static site generator and is SUPER easy to edit. There are some usage restrictions from the Google Sheets API, but the cap is so high it will work just fine for a small project like a local restaurant.

Please feel free to edit to see how easy it is to update, the sheet is only linked to this pen for example purposes!

Comments

  1. It's great, thanks. I never thought that something like this would be so practical. You have some document that explains the process I would like to implement this content process in the future.

  2. awesome solution.

  3. Fantastic example, I have a doubt, taking into account that access is not available to the public, how so? Creating an administrator login and own layout with a sheet editing functionality? What is your opinion?

  4. Hey @melquize, thanks for checking out my little pen. Not sure what the question is completely, but this sheet should be open to the public for editing and viewing... it also shouldn't require any google log-in. However, if you wanted to you could easily lock down a sheet or only grant certain individuals permission to access and edit while still giving public read permissions to allow your web app to properly get the data through an API call.

  5. I love this! Super cool idea...and pretty fun seeing all the other active users (there were 13 of us when I was testing this out) on the google doc. Nice work Adam.

  6. @creativeocean Thank you! It's fun to pop in there and see what tom-foolery people are up to:)

  7. This is genuinely fantastic, really great work! In the distant past, I've tried linking input from Google Forms/Sheets API into a "statically generated" site to have a live-updating online auction where I could get rid of my junk. This implementation is much smoother and even more approachable for the end user (i.e., the restaurant owner) to manage by themselves.

    Do you happen to have any other project that utilizes Sheets API in such clever ways?

  8. This is a great solution and I see how this could be used in a number of ways for people who might need a small solution for content. Great job!

  9. @rdhar Thank you for the kind words! I have not used sheets for any other projects but depending on the use case, I may use the method again!

  10. Sharing the link to edit the original spreadsheet... bold move. I like your style!

  11. @mdixondesigns I was a smidge worried at what the internets would do but this community is awesome and didn't have to moderate at all really! Thanks for checking out my work:)

  12. @quinlo Great solution for small restaurants. Gets me wondering what other kind of projects this would be ideal for.

Leave a Comment Markdown supported. Click @usernames to add to comment.

You must be logged in to comment.
Loading...
Loading...