Guest Posted October 1, 2021 Share Posted October 1, 2021 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
Beyondspace Posted October 1, 2021 Share Posted October 1, 2021 (edited) 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 October 1, 2021 by bangank36 BeyondSpace - Squarespace Website Developer 🖼️ Lightbox Studio (Enable Pinch/Zoom on lightbox) 🗓️ Delivery Date Picker (Squarespace Date format) 💫 Animated Buttons (Referral URL) 🥳 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
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment