Steegle.One Intranet for Google Workspace
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
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)
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.
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.
Please let us know if this article helped or if you know of of any improvements.
Join the Sites Update Group on the Google Sites Classic Comparison to get email notifications about New Google Sites updates.
Subscribe to our newsletter for emails about all things Steegle.com