Your Google Form keeps collecting answers, but the linked Google Sheet stopped getting new rows. This guide is for that exact situation.
The short answer: in almost every case the responses are still stored in the form itself. Check the response count in the form first. If the form has the answers and the sheet does not, the cause is one of five things: the form was unlinked, you are looking at a different file or tab, the sheet was deleted, the form has too many responses, or you lack access to the sheet. You can fix all of them without losing a single response.
Step 1: confirm the responses reached the form
- Open the form in Google Forms and click Responses at the top
- If the Summary tab shows a response count and a list of respondents, the answers are saved in the form
- If the count is not growing, the problem is not the sheet. The form has stopped accepting responses: check whether "Accepting responses" is turned off, or whether you set a close date or a response limit
Google's help page explains that you can turn off "Accepting responses" or set a close date or response limit, and that a form that is not published cannot accept responses (View & manage form responses). A forgotten response limit is one of the most common reasons answers stop at a round number.
The form has the answers but the sheet doesn't: 5 causes
Cause | How to tell | Fix |
|---|---|---|
1. The form was unlinked from the sheet | In Responses, the Sheets button offers to create a spreadsheet instead of opening one | Use "Select destination for responses" and pick the same spreadsheet again |
2. You are looking at a different file or tab | The file that opens from the form's Sheets button is not the one you usually check | The file opened from the form is the real destination. Point your reports at it |
3. The response spreadsheet was deleted | The file is in the Google Drive trash | Restore it, or create a new spreadsheet from the form |
4. Too many responses | The form has more than 100,000 responses | Download the responses as CSV and clean up (see below) |
5. No access to the sheet | You can edit the form but the sheet won't open, or is view-only | Ask the sheet owner for access |
If the form was unlinked, link it to the same file again
According to Google, when you unlink a form, new responses are no longer sent to the spreadsheet, but the existing data stays (Choose where to store form responses). To reconnect:
- Open the form and click Responses, then Summary
- At the top right, click More (three dots), then Select destination for responses
- Choose Select existing spreadsheet, pick the original file and click Select
After relinking, responses may land in a new tab rather than the tab you are used to, so scroll through the sheet tabs at the bottom. Any answers submitted while the form was unlinked are still in the form; you can export them with More, then Download responses (.csv).
Deleting the sheet does not delete the form
Storing responses in a spreadsheet creates a separate file in Google Drive. Google states that you can delete the spreadsheet without deleting the form, and delete the form without deleting the spreadsheet. So even if the sheet is gone, the responses are still in the form. If you can't restore the file from the trash, create a new spreadsheet from "Select destination for responses" and the form's responses will be written into it.
Over 100,000 responses, syncing can stop
Google's help page says that if your form's responses aren't synced with Sheets, it can be because your form has more than 100,000 responses. Since September 2026, each form is also limited to 500,000 responses and 1 GB of total storage (files uploaded by respondents don't count). To keep accepting responses past the limit, the owner has to download and then delete existing responses. Google recommends stopping new responses first, so you don't accidentally delete answers that arrive after your download.
Collaborators need access to both the form and the sheet
When you create a new response spreadsheet, form collaborators automatically get access to it. But later changes to the form's permissions don't sync to the sheet. That is why a new team member can edit the form yet can't open the responses. Update permissions on the form and on the linked sheet separately.
If you keep relinking, the setup may have outgrown Forms
When you add formulas and summary columns next to the response sheet, every relink or new tab shifts references, and "rows not appearing" or "totals don't match" keeps coming back. If you are approaching tens of thousands of responses, or several people manage permissions, it is time to rethink the form-plus-sheet setup itself.
At Mihata we help teams turn intake and application workflows that run on Forms and Sheets into a simple internal app with a proper input screen and list view. If that sounds useful, we would be glad if you took a look.
Summary
- Check the response count in the form first. If it isn't growing, look at "Accepting responses", close dates and response limits
- If the form has answers the sheet lacks: unlinked form, wrong file or tab, deleted sheet, over 100,000 responses, or missing access
- Relink with "Select destination for responses". Existing data is kept
- Deleting the sheet keeps the responses in the form. Manage form and sheet permissions separately
FAQ
Google Form responses are not showing in my Google Sheet. Are they lost?
Usually not. Check the response count in the form's Responses tab. If you unlink a form from its spreadsheet, new responses simply stop being sent to the sheet; the responses in the form and the existing data in the sheet stay.
How do I relink a Google Form to its response spreadsheet?
Open the form, click Responses, then Summary, click More at the top right and choose Select destination for responses. Pick Select existing spreadsheet and choose the original file. Responses may go into a new tab, so check the sheet tabs at the bottom.
Can too many responses stop syncing to Sheets?
Yes. Google's help says responses may not sync with Sheets when a form has more than 100,000 responses. Since September 2026, each form is also limited to 500,000 responses and 1 GB of total storage.
I deleted the response spreadsheet. What now?
Deleting the spreadsheet does not delete the form or its responses. Restore the file from the Google Drive trash, or create a new spreadsheet from Select destination for responses in the form.