Using Google Sheets As A Backend Database [closed]

Question

I volunteer at nonprofit, and we currently run our website through Squarespace. We have hundreds of web pages set up to sponsor our children. Every few months when we want to update their personal information, we have to go into each web page and retype all the information. We keep all our information in a google excel sheet.

My question is: Am I able to link cells from the Google Sheet to specific values on each child's webpage? That way, when the excel sheet is updated (favorite activity, favorite color, grade, age...etc.), it can all be updated through the Google Sheet instead of having to first update the Google Sheet, and then updating each individual webpage. I've been researching this for days now, and I feel like it may be possibly with JQuery, but I feel very limited with Squarespace's capabilities. Thanks!

Answer 1

The short answer is yes.

You can use a google sheet as a database for any application, update and manipulate data. I have been doing that for a long time now. Google has recently released its Google Sheet API V4 (the current) the last version.

I followed this tutorial: https://developers.google.com/sheets/guides/concepts . On the left panel, you can choose the programming language you wish to develop under Quickstart. It supports: PHP. Android. Java. Node.js. Python. Ruby. Perl. Go iOS .NET

The trick is that you need to set an ID for each record which refer to the line number. Your column should also be fixed. This is because queries in Google Sheet API refer to the column number and row number. (Known as index).