Using Google Sheets as a CMS

 Google Sheets logo

Google Sheets logo

By Chris Dilworth
Date: 2022-01-09T00:00
Summary: As part of an experiment I used Google Sheets as a CMS (Content Management System) thinking that it would be simple for a client to enter their content in a spreadsheet format. I got it to work, but realised that it is not a viable client solution.

The Google Sheets API

The first step in setting up this node project was to install the Google API (Application Program Interface) library as a project dependency. The next step is going through the tedious process of setting up a project in the Google Cloud console, enabling the Google Sheets API and creating/downloading the necessary credentials for a service account. In the process a cryptic email address is created with which you share your Google Sheet to give the node project the authority to read and write to the sheet.

Welcome Previous Next

Send me your thoughts

© 2022 M3tə Communications