You open the spreadsheet that collects your Google Form submissions, and the newest rows are missing. Maybe the sheet stopped updating days ago, maybe the 'Form Responses 1' tab has vanished, or a colleague swears they submitted the form and you can't find their answer anywhere. The form itself looks fine.
The good news is that a Google Form keeps its own record of every response, separate from the spreadsheet. A spreadsheet that stops updating almost never means the data is gone. It nearly always comes down to one of four things: the form was unlinked, it now sends responses to a different spreadsheet or tab, the form is so big that syncing has stopped, or the form never received the response because it was closed. Each one has a different fix.
Tell which case you're in
Start in the form, not the spreadsheet. Open the form in Google Forms and click Responses at the top. The response count there is the one that matters. Google notes that the Summary tab only appears once the form has at least one response.
- The form shows the missing responses but the sheet doesn't, and the form offers 'Link to Sheets' instead of a link to an existing spreadsheet: the form has been unlinked.
- The form shows the responses and is linked, but not to the file you're looking at: the form sends to a different spreadsheet, or to a tab you haven't checked.
- The form has more than 100,000 responses: Google says responses may stop syncing with Sheets past that point.
- The form doesn't show the missing responses either: the response never arrived. Check whether the form is closed, unpublished, or has hit a response limit or close date.
- Someone renamed, deleted, or edited the response tab in the spreadsheet: treat the form as the master copy and rebuild the sheet from it (see the recovery section below).
Case 1: the spreadsheet was unlinked
Google's help centre describes exactly what happens: 'New responses won't be sent to the spreadsheet, but your current data remains intact.' So the old rows stay where they are, and everything after the unlink exists only in the form.
To connect a spreadsheet again, Google's steps are:
- Open the form in Google Forms.
- Click Responses, then Summary.
- At the top right, click More, then Select destination for responses.
- Choose Create a new spreadsheet, or Select existing spreadsheet to pick one you already have.
- Click Create or Select.
Relinking only covers you from now on
Google's help page for this option doesn't say whether responses from the unlinked period get copied into the spreadsheet you reconnect. Don't assume they will. Once you've relinked, compare the row count in the sheet with the response count in the form. If they don't match, fill the gap with the CSV download described below.
Also check every tab in the spreadsheet, not just the first one. Google's form help notes that when you create a form from Google Sheets (Tools, then Create a new form), 'the responses will be saved in a new sheet.' Responses can end up in a new tab next to your old one, so a tab you are not looking at may be the one filling up.
Case 2: the form is linked to a different spreadsheet
This one is common when a form has been copied, or when several people manage it. The form is working, but its responses go to a file you aren't looking at. Open the form, click Responses, and use the Sheets link at the top right to open whichever spreadsheet is linked right now. If it isn't the file you expected, either use that file from now on or point the form back at your original with More, then Select destination for responses, then Select existing spreadsheet.
If you can't open the linked spreadsheet, it's probably a permissions problem. Google says that when you create a new response spreadsheet, form collaborators automatically get access to it, but 'further changes to the permissions of the form won't synchronize automatically.' Anyone added to the form later may have no access to the sheet, and you have to update permissions on the form and the linked sheet separately. You can find the spreadsheet on the Google Sheets home screen or in Google Drive.
Case 3: the form or the sheet is too big
Large forms run into limits that Google documents in its help centre. These are the figures at the time of writing:
- Sheets sync: 'If your form's responses aren't synced with Sheets, it can be because your form has more than 100,000 responses.'
- Form size: starting in September 2026, each form has a limit of 1 GB total storage and 500,000 responses.
- Spreadsheet size: up to 20 million cells or 100 MB for spreadsheets created in or converted to Google Sheets.
- Other views: Google says the response summary may not appear above 50,000 responses, and the question and individual views may not appear above 10,000.
What to do about the limits
For a form at or near the cap, Google says form owners can download and delete existing responses to keep accepting new ones, and recommends closing the form to new responses first. Download the CSV, check it opens and contains everything, and only then delete. Google warns that deleting responses in a form can't be undone, and that deleting responses doesn't delete attached files.
Case 4: the form never received the response
If the form's own response count is also missing the submission, the spreadsheet isn't the problem. Google's help centre says unpublished forms can't accept responses, and an owner can turn off Accepting responses, or set a close date or response limit (under Accepting responses, click Set close date or response limit). Check those settings. If a cap or date has passed, remove it or raise it, then ask the person to submit again. To hear about new submissions straight away, open Responses, click More, and turn on Get email notifications for new responses.
Get every missing response back with a CSV download
Whatever went wrong with the spreadsheet, the form is still your source of truth. Google's documented export is:
- Open the form in Google Forms.
- At the top of the form, click Responses.
- Click More, then Download responses (.csv).
- Import the file into Google Sheets. Google notes that 'downloaded responses are not sorted by timestamp; you can sort them in Google Sheets after a CSV import.'
- Compare it with your existing sheet and copy across only the rows that are missing.
If the response tab was renamed, deleted, or edited
Google's help pages don't say what happens to the form's link if someone renames or deletes the response tab, or edits responses inside it. What they do say is that the spreadsheet is a separate file in Google Drive: you can delete the spreadsheet without deleting the form, and the form without deleting the spreadsheet. So if the tab is damaged, the responses in the form are still safe.
The safest rebuild is to link a fresh spreadsheet (More, then Select destination for responses, then Create a new spreadsheet), check its row count against the form, and fill any gap from the CSV. To stop this happening again, leave the response tab untouched. Do your sorting, formulas, and edits in a separate tab that references it, so the form's own data stays in the shape it arrived in.
If you're the person who filled in the form
You can't see the owner's spreadsheet, but you can help them. If the form collected your email and the owner turned on response receipts, check your inbox and spam folder for a copy of your answers. Google says spam filters may block these. Send the owner the time you submitted, so they can find your response in the form's Responses tab, where it will be even if it's missing from their sheet. If the form showed a 'closed' message, your answer was never recorded, and you'll need to ask the owner to reopen the form.
A simpler option for small business forms
If you mainly use Google Forms to take bookings, sign-ups, or orders from customers, OneSol offers forms that don't make people sign in, on a free page that also holds one link for all your profiles. If you also want to take payments, connecting your own Stripe, PayPal, Razorpay, or Square account comes with the paid Pro plan.