Try the example, then check the result.
Download the fictional material and work through the exact steps below. App screens in the video are English illustrative diagrams, not a recording of the product interface. Controls can vary by version.
Use the answer check before applying the method to your own data. How we review guides ↗
Watch the complete lesson.
Synthetic narration · English illustrative diagrams · English captions. Product menus may differ in your account.
Linking a Google Form to a Sheet makes responses easier to filter and analyze. It also creates a separate file with separate access settings. This guide uses a two-question fictional workshop form and exactly one invented response. The expected finish is one row in the linked Sheet with the chosen tutorial, the suggestion, and a generated timestamp. Before inviting real people, check both the form's respondent summary setting and the Sheet's Share panel. Restricted link access does not remove access held by named collaborators.
Download the form blueprint and response and privacy checks. No live form, real participant response, or private contact information is supplied.
Prerequisites
- A Google account that can create Forms and Sheets in a desktop browser.
- A disposable form named Workshop Feedback — Practice.
- Fictional practice text only. Do not enter a real email address, participant answer, or customer data.
| Question | Type | Required | Choices or sample answer |
|---|---|---|---|
| Which tutorial should we improve? | Multiple choice | Yes | Spreadsheet cleanup; Gmail filters; Meeting notes |
| What would make it clearer? | Paragraph | Yes | Label the workbook download more clearly. |
Swipe or scroll sideways to see every table column →
Create, link, and submit
- Open Google Forms and create a blank form with the two questions above. Use the exact capitalization in the blueprint so the answer check is easy.
- Open Settings → Presentation and make sure View results summary is off. Google states that when this setting is enabled, people who can respond may see summary results, including full-text answers. For this exercise, leave email collection off as well; it is not needed.
- Google's current help requires Publish before responders can use the form. Review who can respond and choose a test audience you control. Personal and Workspace accounts may show different sharing options. Do not distribute the test link to real participants.
- Open the form's Responses tab. Use Link to Sheets or the response-destination menu to create a new spreadsheet. The spreadsheet is a distinct Drive file. If a Sheet was already selected, verify that you opened the intended one.
- Open the responder preview or test link. Submit one entry: choose
Spreadsheet cleanup; in the paragraph field typeLabel the workbook download more clearly. - Return to the linked Sheet. Expect one response data row containing those two exact answers and a timestamp generated at submission. The displayed time depends on your account and Sheet settings; there is no fixed expected time.
Check who can read the answers
- Reopen the form's Settings → Presentation and confirm View results summary remains off. Review the form's collaborator and responder lists separately. Remove any collaborator who should not be able to see answers.
- Open Share on the linked Sheet. Under General access, select Restricted and save. Then inspect the named people and remove anyone who should not read the answers. Google says form collaborators can gain access to a newly linked response Sheet, and later changes to form permissions do not automatically update Sheet access. Change permissions on both files separately.
- Pass check: respondent results summary is off; the Sheet's general access says Restricted; and both the form and Sheet list only intended collaborators. Named collaborators may still see the answers. If a shared parent folder grants access you cannot remove on this file, move the Sheet to a dedicated restricted folder before collecting real responses.
| Checkpoint | Expected in this practice | If it differs |
|---|---|---|
| Form Responses tab | One submitted response | Check publication, responder access, and whether Submit completed. |
| Linked Sheet | One data row plus a timestamp | Open the destination from this form's Responses tab; check for a second submission. |
| Responder results summary | Off | Turn it off before inviting people. |
| Sheet Share panel | General access: Restricted; only intended named people | Review named and inherited access separately. |
Swipe or scroll sideways to see every table column →
Turning off respondent summaries does not remove collaborator or Sheet access. Likewise, changing Sheet access does not by itself change who can respond to the form.
If the expected row is missing
- Confirm the form was published and that the fictional answer was actually submitted.
- Confirm you opened the Sheet connected to this form, not a different spreadsheet.
- In Forms, open Responses and verify a response appears there. If the form has a response but the Sheet does not, inspect the selected destination.
- If there are two rows, the practice answer was probably submitted twice; use a new disposable form or account for a clean one-row exercise. Avoid deleting real submissions.
FAQ
Can the responses go to an existing Sheet? Yes. Google supports a new or an existing spreadsheet. This practice uses a new file so its permissions are easier to inspect.
Is the timestamp always the same format? No. The display can vary with locale and time zone. Match the two answer fields rather than a fixed timestamp string.
Does publishing make the response Sheet public? Publishing controls responder access to the form. The linked Sheet has its own Drive sharing settings, which must be checked separately.
Sources and visual note
Google's current instructions: Publish and share a form, choose where to save responses, view and manage responses, and restrict or remove file access. Reviewed 9 October 2026. The companion video's Forms and Sheets panels are illustrative diagrams, not recordings of a live account. The one-response submission and permission panels have not been verified in this account. Recheck current UI labels and run the one-response test before relying on the result.
Practice downloads.
The exercise files contain invented information. Save a local copy before editing.