How to Use Google Sheets as a Database with React and SSR

2 years ago thenewstack.io

Summary: This is a summary of an article originally published by The New Stack. Read the full original article here →

In this tutorial I’ll be explaining how to use Google Sheets as a database, to store the results of a user poll. Screenshots of Gatsby and Next.js example User Poll apps with bar chart results. Data is sent from the browser to a Serverless Function that securely posts to a Google Sheet, which stores the data.

You’ll configure this project so that it contains access to the Google Sheets API, via a Service Account user/email address, and use it to generate the required API keys needed to “post” data to the Google Sheet.

To create the necessary credentials for the Google Sheets API, click the CREATE CREDENTIALS button.

DevOps Articles