Google Forms sends responses directly to a Google Sheet when you link them during setup
When you create a Google Form, you can set it to automatically save every response into a Google Sheet. This happens without any manual work on your part — each time someone fills out your form, their answers appear as a new row in the sheet. You do this by choosing to create a linked sheet when you first set up the form, or by connecting an existing sheet afterward.
The connection is one-way: the form pushes data into the sheet, but changes you make in the sheet do not change the form. This is useful for collecting survey answers, sign-up information, event registrations, or feedback without having to copy and paste responses by hand.
Key Takeaways
- You can create a new Google Sheet during form setup, or link to an existing sheet you already own.
- Each form response becomes one row in the sheet, with each question answer in its own column.
- The sheet updates automatically whenever someone submits the form — no refresh or manual sync needed.
- You can edit the form questions after linking, and new responses will still flow into the same columns.
- Only you (or people you share the sheet with) can see the responses — the form respondents cannot.
Creating a new sheet when you set up the form
Open Google Forms and start a new form. Fill in the title and description, then add your questions. Before you share the form with anyone, look for the three-dot menu icon in the top right corner and click Responses. You will see a green spreadsheet icon next to the word "Responses" at the top of the panel that opens.
Click that spreadsheet icon. Google Forms will ask whether you want to create a new sheet or use an existing one. Choose Create a new spreadsheet. Google will create a new sheet in your Google Drive with a name like "Form Responses 1" and link it to your form. From that moment on, every response goes into that sheet automatically.
The new sheet appears in your Google Drive in the same folder as your form. You can rename it, move it to a different folder, or share it with others — the link to the form stays active.
Linking to a sheet you already have
If you already created a Google Sheet and want to connect a form to it, open the form and go to the Responses tab the same way. Click the spreadsheet icon and choose Select existing spreadsheet. Google will show you a list of sheets you own. Find the one you want and click it.
When you link to an existing sheet, Google adds a new tab (sheet) within that file called "Form Responses 1" (or the next available number if you have already linked forms to this file before). Your form responses go into this new tab, not into the tabs that were already there. This means you can keep other data in the same file without mixing it with form responses.
If the sheet you want to link to is in a shared folder or owned by someone else, you will not be able to link it — you must own the sheet. Ask the owner to share it with you as an editor, or create your own copy.
How the data appears in the sheet
The first row of the linked sheet contains column headers. The first column is always a timestamp showing when the response was submitted. The remaining columns are labeled with your form questions, in the same order they appear in the form.
Each time someone submits the form, a new row appears at the bottom of the sheet. If the form has a multiple-choice question, the sheet shows the answer the person selected. If it is a short-answer question, the sheet shows the text they typed. For questions that allow multiple selections, the sheet lists all chosen options separated by commas.
If you add a new question to the form after responses have already come in, the new question creates a new column in the sheet. Responses submitted before you added the question will have an empty cell in that column.
Editing the form after linking
You can change your form questions, add new ones, delete old ones, or reorder them — the link to the sheet stays active. If you edit a question's text, the column header in the sheet updates to match. If you delete a question, that column remains in the sheet but stops receiving new data.
If you change the type of a question (for example, from short answer to multiple choice), the sheet column header updates but old responses in that column do not change. Only new responses after the change will use the new format.
You can also change the form's title without affecting the sheet. The sheet name and the form name are separate — changing one does not change the other.
Sharing responses with others
To let someone see the form responses, share the Google Sheet with them. You do not need to share the form itself — they only need access to the sheet. Open the sheet, click the Share button in the top right, enter their email address, and choose whether they can view, comment, or edit.
If you want someone to fill out the form but not see the responses, share only the form link with them, not the sheet. You can get the form link by clicking the Send button (paper airplane icon) in the top right of the form editor.
If you want to let people see only some responses (for example, only the ones from their own region), you will need to create a separate sheet or use Google Sheets' filter and view features. The linked sheet itself shows all responses to everyone you share it with.
Unlinking a form from a sheet
If you want to stop sending responses to a sheet, open the form, go to the Responses tab, click the three-dot menu, and select Unlink form. The sheet you created or linked stays in your Google Drive with all the responses it collected so far, but new form submissions will no longer appear there.
You can link the form to a different sheet afterward by clicking the spreadsheet icon again and choosing a new sheet. The old sheet keeps its data and does not change.
If you delete the Google Sheet, the form is automatically unlinked. New responses will still be collected by the form, but they will not go anywhere until you link a new sheet.
Frequently Asked Questions
Can I link one form to multiple sheets?
No. A form can only send responses to one sheet at a time. If you need responses in multiple places, you can copy the data from the linked sheet to other sheets manually, or use a tool like Zapier to send form responses to multiple destinations.
What happens if I move the linked sheet to a different folder?
The link stays active. Moving the sheet in Google Drive does not break the connection to the form. Responses continue to appear in the sheet no matter where it is stored.
Can someone who fills out the form see the responses?
No. Form respondents see only the form itself. They cannot see the linked sheet or any other responses unless you specifically share the sheet with them by email.
If I delete a row from the sheet, does it delete the response?
Yes. Deleting a row removes that response from the sheet permanently. The form itself does not keep a separate copy — the sheet is where all responses are stored. If you need to keep responses, do not delete rows, or make a backup copy of the sheet first.
Can I edit responses after they are in the sheet?
Yes. You can edit any cell in the sheet, including response data. However, the form itself does not update — if you change a response in the sheet, the person who submitted it will not see the change if they view their own submission. Edit responses only if you are correcting data entry errors or removing sensitive information.