Jump to content

How to embed content in a blog post from a google sheet?

Recommended Posts

I am creating a website to act as a 'Yelp' or 'Rate My Professor' for online fitness coaches. I have a form people can fill out to rate a coach they have worked with. 

Currently, this form emails me the submission and populates a google sheet. When a form is submitted, is there a way to automatically add the review to the page as content within the blog? For example, could I embed content from a google sheet? Or at least use the data to populate the ratings chart at the top of the page? 

 

Similarly, I have a page where individuals can submit a form to add a page for a coach. Is there a way to create a new blog post from a template when a form is submitted? Using the fields from the form submission?

 

Screen Shot 2023-02-13 at 2.03.03 PM.png

Link to comment

I don't know of any way to create and publish a new blog based on a submission (probably a bad idea, you would undoubtedly want to vet information before publishing).

Adding a table based on the ratings and pushing that directly to your website can be achieved with this plugin:
https://www.squarewebsites.org/squarespace-plugins/custom-table-block
You could even set it up to update an average score as well.

Hope that helps!

Please like and upvote if my comments were helpful to you. Cheers!

Zygmunt Spray
Squarespace Website Designer
Contact me: 
https://squarefortytwo.com 

  Did I help? Buy me a coffee?

🔌 Ghost Squarespace Plugins (Referral link)
📈 SEO Space (Referral link)
 SquareWebsites Plugins (Referral link)
 🔲 SQSP Themes (Referral link) 
Spark Plugin (Referral link) 

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.