Jump to content

Pulling Data From Google Docs

Recommended Posts

My site is still being developed, but as I am coming close to completion and going live with it I am running into a slight issue.  The issue is I have a contact type form on my site which collects ratings (based on 3 or 4 questions, 1-5 scale), pretty standard. This is being populated into google sheets per square space set-up.  My issue is I can't find a way to pull back the ratings and create a report on my site based on those ratings.  My question is. Does Squarespace offer such a solution to query google docs and bring back those ratings?  If this can be done on the fly that would be great, less human interaction the better.

Thoughts?

Thanks!

AWL

Link to comment
  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

This plugin allows you to pull tables and data into Squarespace, I'm not exactly sure what you're wanting to pull on to your website, but you can also embed a Google sheet directly by publishing it.

https://www.squarewebsites.org/squarespace-plugins/custom-table-block

If you can share a few more details I can probably help further.

Please like and upvote if my comments were useful to you. Thanks!

Zygmunt Spray
Squarespace Website Designer
Contact me: https://squarefortytwo.com/ 
🔌Ghost Squarespace Plugins (Referral link)
Buy me a coffee

Link to comment

Ziggy-

Thanks for your reply and I will check out that plug-in.  This is what I am trying to do. I have a form on my site that will be a "review this program"...  So my results may look like this:
Think of this has 3 different submissions, stored in a Google Sheets app. The user reviews the program and submits to my google sheet (this is working).

Three user reviews may look like this (the comma represents a cell in Google sheets, couldn't see how to build a table):
User A, Program A, 5, 4, 3, 5
User B, Program B, 5, 5, 4, 5
User C, Program A, 5, 3, 5, 5

So with this data I want to report back to my site data like this:
Program A, 5, 3.5, 4, 5
Program B, 5, 5, 4, 5

Basically query the data into 'results' of the survey by program, without the need to do anything else just set-up and let it update on the fly.

AWL
 

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.