How to Use Google Sheets as a Simple CMS

Coding in Public • September 5, 2023

Coding in Public

About

👋 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!

How to Use Google Sheets as a Simple CMS

Coding in Public

About

Latest Posts

Ultimate Content Collections Overview

Micro-interactions still matter

How View Transitions actually work

Eloquent JavaScript: Chapter 4 (part 1)

You May Also Like

Streamline Work with These Google Sheets Must-Haves

TP-Link Tapo 3K 5MP Pan/Tilt Security WiFi Camera, Baby &amp; Pet Camera, 360° Motion Tracking, 2-Way Audio, 40Ft. Night Vision, Cloud &amp; Local Storage (Up to 512 GB), Works w/Alexa &amp; 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 &amp; 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 &amp; LED Lights, 44.6&quot;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 &amp; 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&quot; with LED Lights &amp; Power Outlets, Reversible L Shaped Gaming Desk with Monitor Stand, Office Desk with Storage, Writing Desk with USB Port &amp; 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

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)

(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&quot; 4K UHD WLED LCD Monitor - 16:9 - Black, Silver EPEAT

Dell UltraSharp U2725QE 27&#x27; 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 &amp; 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)

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

Loading...

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)

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

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

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