Jump to content

Setting up a Google Sheets database

Recommended Posts

Hello,

 

I am trying to set up a simple database to store some information for my site. This data will just be numbers. I will need to be able to read and write to it. I was thinking of using a simple Google Sheets file to do this and was wondering what I would have to do to read and write from it, and how I would get that working on Squarespace. I was hoping it would be possible to use a code injection to this and then I could write some simple javascript to use the data as required. Nothing personal/confidential will be stored on this so it doesn't have to be very secure, though I understand this is a concern.

 

Would anyone be able able to help me out or point me in the right direction to some resources that cover how a google sheets file could be used in conjunction with Squarespace like this.

 

Thanks!

Link to comment
3 hours ago, ej3718 said:

Hello,

 

I am trying to set up a simple database to store some information for my site. This data will just be numbers. I will need to be able to read and write to it. I was thinking of using a simple Google Sheets file to do this and was wondering what I would have to do to read and write from it, and how I would get that working on Squarespace. I was hoping it would be possible to use a code injection to this and then I could write some simple javascript to use the data as required. Nothing personal/confidential will be stored on this so it doesn't have to be very secure, though I understand this is a concern.

 

Would anyone be able able to help me out or point me in the right direction to some resources that cover how a google sheets file could be used in conjunction with Squarespace like this.

 

Thanks!

You can publish the spreadsheet content into csv or html and parse the data.

Eg: on this page I used a spreadsheet to extract orders data (from Squarespace API) and on front page I use javascript to parse the content of the published spreadsheet in html format display the total sale tally info.

https://undiscoveredsf.squarespace.com/culture-crawl-merch

Edited by bangank36

Greeting, it's BeyondSpace, I am Squarespace dev focus on provide solutions to enhance feature that squarespace.com can't provide.
Feel free to check my current Squarespace Plugins Developement: Enable Pinch/Zoom on lightbox, Delivery Date Picker, Keyword Highlighter
If you find my answer fit your need, let's leave a like or upvote so others with the same issue can find their solution. Thank you

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

×
×
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.