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
  • Replies 1
  • Views 1.4k
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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

BeyondSpace - Squarespace Website Developer

🖼️ Lightbox Studio (Enable Pinch/Zoom on lightbox)
🗓️ Delivery Date Picker (Squarespace Date picker form field)
💫 Gallery block 7.1 workaround
🥳 Sparkplugin Customisations Browsers (Browse +100 Spark plugin customisations)
🥳 Elfsight Template Browsers (Browse +1000 Elfsight widget Templates)

If you find my answer useful, 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.