Steegle logo

Visitor Comments - Google Form and Sheet

One of the most frequently asked questions about new Google Sites is "How can we add viewer comments to our site?". This article demonstrates how to use a Google Form to capture the comments and a Google Sheet to display them.

A better approach is to use Disqus to add visitor comments - see full instructions at Insert Disqus - New Google Sites

Instructions

  • On the form add the fields you want, e.g. Name, Comment and anything else you want. You can make fields required, if necessary and change the form colour.

  • On the Responses tab choose to Create spreadsheet, name the spreadsheet as required and use the Create button

Create Google Form - Comments - New Google Sites

Add a Second Sheet to sort the Comments

  • The form adds the data to the sheet at the next available row of the spreadsheet (furthest down the spreadsheet).

  • If you want to display the newest comment first make a new sheet and add the headings from the original sheet, then in the next row use the SORT() function to display the columns in descending date order. In this example we used this formula:

=Sort('Form responses 1'!A2:C,1,FALSE)

Second sheet for sorting - Comments - New Google Sites

Embed the Google Form in the Site

  • Go to the page where you would like the form to appear and use the Insert panel on the right and choose Forms.

  • From the list of forms (your most recently edited form should appear first) choose the correct form.

Embed Google Form - Comments - New Google Sites

Embed the Google Sheet in the Site

  • At the same page embed the Google Sheet in your preferred location, use the Insert panel and then Sheets.

  • If you added a sheet to sort the comments to newest first then open the embedded sheet's settings (use the button that looks like a cog/gear) and choose your sorted sheet as the default sheet to display.

Embed Google Sheet - Comments - New Google Sites

You're done!

Test the form and you should see the comment you made. There can be a delay for the form data to arrive in the sheet and then a further delay for Google to update the published sheet for the public.

Feedback

Please let us know if this article helped or if you know of of any improvements.

Keep up-to-date

Join the Sites Update Group on the Google Sites Classic Comparison to get email notifications about New Google Sites updates.

Newsletter

Subscribe to our newsletter for emails about all things Steegle.com

Springboard Intranet
for Google Workspace

We provide a well-designed and well-structured intranet to enable your employees to: start work with the right tools; find people with appropriate skills; collaborate with the their teams; access authorized resources; thank and recognize heroic colleagues and coworkers.

Steegle People for Google Workspace Logo

Steegle People
for Google Workspace

Searchable staff directory for Google Workspace, with real-time search results, that automatically generates org charts to show your organisation structure - Steegle People.
Steegle Share for Google Drive Logo

Steegle Share
for Google Drive

If the standard Google Drive Folder embed does not give you everything you need, take a look at the Steegle Share for Google Drive that offers search, sorting, download links and more...
Steegle News Gadget for Google Sites Logo

Steegle News
for Google Sites

Display headlines, snippets and metadata linked to your news articles and blog pages on your Google Site and filter by tags added to the news gadget. See the Steegle News Gadget.

Steegle Heroes
for Google Workspace

Employee recognition system: Steegle Heroes allows you to thank and recognise your colleagues, coworkers and employees spotlight a hero as an Employee of the month.