How to Use Google Sheets as a Simple CMS
Coding in Public
@codinginpublicAbout
π Hi! My name is Chris Pennington π Iβm a relative beginner to development and enjoy teaching what Iβm learning to others. I mostly teach beginner to intermediate web dev on the channel through project and component builds. Coding in public gives us all the chance to learn together. Iβm a learner first and an expert never. Have a suggestion? Leave a comment! Weβre all learners and we all learn better when we code together!
Latest Posts
Video Description
Letβs raise funds for St. Jude! https://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: https://developers.google.com/apps-script/guides/web --------------------------------------- π¨ VSCode Theming - Font: Cascadia Code: https://github.com/microsoft/cascadia-code - Theme: https://marketplace.visualstudio.com/items?itemName=Equinusocio.vsc-community-material-theme - Icons: https://marketplace.visualstudio.com/items?itemName=BeardedBear.beardedicons --------------------------------------- π Connect With Me π - Website: https://codinginpublic.dev - Blog: https://chrispennington.blog - Twitter: https://twitter.com/cpenned - Patreon: https://www.patreon.com/coding_in_public - Buy Me a Coffee: https://www.buymeacoffee.com/chrispennington
You May Also Like
Streamline Work with These Google Sheets Must-Haves
AI-recommended products based on this video

TP-Link Tapo 3K 5MP Pan/Tilt Security WiFi Camera, Baby & Pet Camera, 360Β° Motion Tracking, 2-Way Audio, 40Ft. Night Vision, Cloud & Local Storage (Up to 512 GB), Works w/Alexa & Google (Tapo C230)

TP-Link Tapo 2K Pan/Tilt Indoor Security WiFi Camera, Baby & Pet Camera w/ 360Β° Motion Tracking, 2-Way Audio, Night Vision, Cloud & Local Storage (Up to 256 GB), Works w/ Alexa & Google (Tapo C210)

VersionTECH. Gaming Mouse Ergonomic Wired Computer Mouse with 7 Colors LED Backlight, 4 DPI Settings Up to 3600 DPI Compatible for Chromebook Windows 7/8/10/11 XP/Mac/Linux Gamer/Notebook/MacBook

Seventable L Shaped Computer Desk with Drawers 47.2 inch,Gaming Desk with Power Outlets & LED Lights,Reversible Office Desk with Storage Shelves,Corner Desk with Monitor Stand for Home Office White

Seventable L Shaped Computer Desk with Power Outlets & LED Lights, 44.6"Small Home Office Desk with 3 Fabric Drawers, Reversible Gaming Desk with Storage Shelves, Corner Desk with Monitor Stand, White

ODK Gaming Desk with Led Lights & Power Outlet, 48 Inch Gaming Computer Desk with Storage Shelves, PC Desk with Monitor Stand, Gamer Desk Table for Home Office, Black

Rolanstar Computer Desk L Shaped 56.7" with LED Lights & Power Outlets, Reversible L Shaped Gaming Desk with Monitor Stand, Office Desk with Storage, Writing Desk with USB Port & Hook, Black

Logitech K250 Bluetooth Keyboard with Numpad, Easy Connectivity, Compact Wireless Keyboard Made with Recycled Plastic, Spill-Resistant, Comfortable Keys - Windows/MacOS - Graphite

Logitech K400 Plus Wireless Touch TV Keyboard With Easy Media Control and Built-in Touchpad, HTPC Keyboard for PC-connected TV, Windows, Android, Chrome OS, Laptop, Tablet - Black
![[Apple MFi Certified] Lightning to HDMI Adapter for iPhone, 1080P Digital AV Adapter iPhone HDMI Adapter Video HDMI Sync Screen Connector Compatible with iPhone 14/13/12/X/8 NO Need Power Supply](https://m.media-amazon.com/images/I/41FjGWUIKnL._AC_UL960_FMwebp_QL65_.jpg)
[Apple MFi Certified] Lightning to HDMI Adapter for iPhone, 1080P Digital AV Adapter iPhone HDMI Adapter Video HDMI Sync Screen Connector Compatible with iPhone 14/13/12/X/8 NO Need Power Supply

Mcbazel Wii to HDMI Converter Output Video Audio Adapter for Wii (NTSC 480I, 480P, PAL 576I) -Support All Display Modes

ABLEWE RCA to HDMI,AV to HDMI Converter, 1080P Mini RCA Composite CVBS Video Audio Converter Adapter Supporting PAL/NTSC for TV/PC/ PS3/ STB/Xbox VHS/VCR/Blue-Ray DVD Players

Anker USB C Charger Cable (6ft 100W, 2Pack), USB 2.0 Type C Fast Charging Cable for iPhone 15 / 15Pro / 15Plus / 15ProMax MacBook Pro 2020, iPad Pro 2020, iPad Air 4, Samsung Galaxy S23+/S23 Ultra ClimatePartner certified
![Anker USB C Cable, [2-Pack, 6 ft] Type C Charger Premium Nylon USB Cable, USB A to Type C Charging Cable Fast Charge for Samsung Galaxy S10 S10+ / Note 8, LG V20 and Other USB C Charger (Black)](https://m.media-amazon.com/images/I/71N7xhCJnoL._AC_UL960_FMwebp_QL65_.jpg)
Anker USB C Cable, [2-Pack, 6 ft] Type C Charger Premium Nylon USB Cable, USB A to Type C Charging Cable Fast Charge for Samsung Galaxy S10 S10+ / Note 8, LG V20 and Other USB C Charger (Black)

Anker Nano USB C Wall Charger,45W Fast Charging Smart Display Charger,with 180Β°Foldable Plug,Smart Recognition,Built-in Care Mode,for iPhone17/16/15 (Non-Battery,One USB-C Port,No Cable Included) ClimatePartner certified

(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

Logitech M185 Wireless Mouse, 2.4GHz with USB Mini Receiver, 12-Month Battery Life, 1000 DPI Optical Tracking, Ambidextrous, Compatible with PC, Mac, Laptop - Black

Logitech G305 Lightspeed Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

Logitech K400 Plus Wireless Touch TV Keyboard With Easy Media Control and Built-in Touchpad, HTPC Keyboard for PC-connected TV, Windows, Android, Chrome OS, Laptop, Tablet - Black

Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black

Dell UltraSharp 24 Monitor - U2424H

Dell UltraSharp U2723QE 27" 4K UHD WLED LCD Monitor - 16:9 - Black, Silver EPEAT

Dell UltraSharp U2725QE 27' 4K Thunderbolt-Hub-Monitor mit Bildwiederholfrequenz Von 120Hz

for iPhone 16/15 Pro Max Charger, 20W Fast Charging USB C Charger Block Wall Power Adapter + 6FT USB-C Cable for iPhone 16 Pro Max Plus 16e, iPhone 15 Pro Max, iPad Pro 12.9/11/13 inch, Air 4/5

iPhone 16e/16/15 Pro Max Charger, 2-Pack 20W Type C Fast Wall Charger Plug Power Adapter, USB C Charger Block for iPhone 16/16e/16 Pro/16 Pro Max/15/15 Plus/15 Pro Max, iPad, with 6FT USB-C to C Cable

USBC Charger Block for iPhone 16 Charging Plug,MFI Certified Fast USB C Wall Cube 2Pack Power Adapter for iPhone 15/16 Pro/Plus/Pro Max/14/13/12/11,for iPad Air/Mini USB-C Charge Brick Box

iPhone 15 16 Charger Fast Charging 10 ft USB C to USB C Cable Long,Apple 60W Type C Cord and USBC Wall Block Power Adapter Cube Brick for iPhone 16 Pro/16 Pro Max/16 Plus/15 Pro/15 Pro Max/15 Plus

CHARM FOCUS Stereo Headset Adapter, Audio Mic Headphone Adapter for Xbox One, Xbox Series X|S and Elite Controller, Adjust Audio Balance (Game Sound & Voice Chat), Not Bluetooth Compatible

Monster Mission 200 Bluetooth Headphones, Wireless Headphones with 3 EQ Modes, Low Latency HiFi Stereo Foldable Lightweight Headset, 60H Playtime,Deep Bass for Home Office Cellphone PC Ect(White)




















