Using Google Sheets as a CMS
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.
Send me your thoughts
© 2022 M3tə Communications