Google Form responses not showing in your sheet? How to find them

By Caner Kaya, Kayabyte

Check the form first. Open it, click Responses, and look at the response count. If the responses are there, they are safe: Google Forms keeps its own copy of every response, separate from the spreadsheet. The problem is only that they didn’t reach the sheet, or that they did and you can’t see them. You can download them all as a CSV or send them to a new response tab in a few clicks.

If the responses aren’t in the form either, they were never submitted, or someone deleted them in the form. Google says deleting responses in a form can’t be undone.

Below are the usual causes, in the order I’d check them, then how to fix it and how to stop it happening again.

Are the responses in another tab?

Look at the tabs along the bottom of the spreadsheet. If the form was ever unlinked and linked again, Google Forms usually creates a new tab, such as Form Responses 2, and sends new responses there. The old tab stays, but stops getting new rows. Stony Brook University’s IT guide gives this as the first thing to check.

A tab can also have been renamed, so look for a tab with the form icon next to its name rather than for the name “Form Responses 1”.

Is the form still linked to this spreadsheet?

Open the form and click Responses. If you see Link to Sheets, the form isn’t sending responses to any spreadsheet at the moment (Google’s guide).

Google says that after you unlink a form, “New responses won’t be sent to the spreadsheet, but your current data remains intact” (Choose where to save form responses). So a form someone unlinked last month has quietly kept collecting responses only in the form since then.

Also check that it’s linked to the file you’re looking at. A collaborator on the form can pick a different spreadsheet, and the responses then go there. A common version of this: someone made a copy of the spreadsheet and kept working in the copy. Copying a spreadsheet doesn’t move the form link, so responses keep going to the original file (doc2form).

Were rows deleted, sorted or filtered?

The response tab is an ordinary tab that anyone with edit access can change.

• Deleted rows. Deleting a row in the sheet doesn’t delete the response from the form. Google treats the form and the spreadsheet as separate files. You can get the response back from the form (see below) or from the spreadsheet’s version history.
• Sorting. A sort doesn’t remove anything, but it moves rows, so the newest response may no longer be at the bottom. Sort by the Timestamp column to put them back in order. To keep a sorted view, sort a copy on another tab (for example with =SORT('Form Responses 1'!A:Z, 1, FALSE)) and leave the response tab alone.
• Filters and hidden rows. A filter, a filter view or hidden rows can hide responses that are there. Remove the filter (Data > Remove filter) and unhide rows to check. Google now puts new form responses in a table, so also check the table’s own column filters.
• Formulas or stray content far down. If someone filled formulas down the response tab, or typed something far below the last response, new responses can land below it, far down the sheet (doc2form, Alice Keeler). Press Ctrl+Down (Cmd+Down on a Mac) in the Timestamp column to jump between filled rows, and scroll to the end of the tab.

Does the form have more than 100,000 responses?

Google’s help on viewing and managing responses says: “If your form’s responses aren’t synced with Sheets, it can be because your form has more than 100,000 responses.” The same article says forms can now take up to 500,000 responses and 1 GB of storage, with these new limits from September 2026.

Is the spreadsheet full?

A Google Sheets file can hold up to 20 million cells (Google’s file limits). Google doubled this from 10 million in September 2026 (Workspace Updates), with a gradual rollout.

The limit counts every cell in every tab, including empty ones, so a file with many large tabs can fill up faster than you’d expect. Google doesn’t document what a linked form does when the file is full, but a full spreadsheet can’t take new rows. If you’re close, delete unused empty rows and columns, or move old data to another file.

Do you have access to the form’s responses?

If someone else owns the form, you may be able to see the spreadsheet but not the form’s own responses, or the other way around. Google says form permission changes made after the response sheet is created don’t sync to the spreadsheet automatically. Ask the form owner to check the form’s Responses tab.

How do I get the missing responses back?

Download them as a CSV. In the form, click Responses, then More (the three dots) and Download responses (.csv) (Google’s guide). Google notes the CSV may not be sorted by time, so sort it in Sheets after you import it. You can then paste the missing rows into your response tab or a separate tab.

Send them to a new response tab or file. In the form, go to Responses, click More and choose Select destination for responses, then pick Create a new spreadsheet or Select existing spreadsheet (Google’s guide). Google’s article doesn’t say what the new tab contains, but community answers and third-party guides report that relinking adds a new tab, such as Form Responses 2, with every response the form still holds (Docs Editors Community, doc2form). Check the row count against the form before you rely on it. If the form is already linked, unlink it first (Responses > More > Unlink form), then select the destination again.

Before you relink, keep in mind:

• Formulas, charts and other tabs that point at the old response tab won’t follow the new tab. Update them, or copy the missing rows into the old tab by hand instead.
• Anything you typed into extra columns of the old response tab (notes, statuses) isn’t in the new tab.
• If relinking fails, a suggestion from the community is to make a copy of the spreadsheet and link the form to the copy.

How do I stop this happening again?

• Don’t work in the response tab. Treat it as raw data. Do your sorting, notes and formulas on another tab that reads from it, for example with =SORT(...), =FILTER(...) or =QUERY(...).
• Protect the response tab so only you can edit it (Data > Protect sheets and ranges; Google’s guide). A warning-only protection is a gentle middle ground for a team.
• Turn on form notifications. In the spreadsheet, Tools > Notification settings > Edit notifications, then A user submits a form (Google’s guide). If you get the email but no new row, you know at once.
• Compare counts now and then. The number on the form’s Responses tab should match the number of response rows in the sheet.
• Download a CSV from the form before big clean-ups, and keep an eye on large forms near 100,000 responses.

Where the built-in options stop

• No warning. Nothing tells you when the form is unlinked, the response tab is renamed or deleted, or responses stop arriving.
• No automatic comparison between the form and the sheet. You have to count by hand.
• Relinking creates a new tab, so anything built on the old tab needs updating.
• Deleted form responses are gone for good, and a deleted row in the sheet only comes back if you go looking for it.

An add-on that backs up responses and checks for gaps

Full disclosure: I built Kayabyte Sheet Guard partly for this. For each Google Form linked to the spreadsheet, it copies every response to a separate backup tab as it arrives, so rows deleted or sorted in the response tab don’t matter. A regular check (daily on the free plan, hourly on Pro) asks Google Forms for its responses, read-only, compares them with the backup, and tells you when responses never reached the sheet, when a form was unlinked, when the response tab was renamed or deleted, when a new “Form Responses 2” tab took over, or when the header row was edited. On Pro, it recovers the missing responses into the backup tab, labelled with the form’s question titles, and emails you.

What it doesn’t do: it only covers responses from the time it starts guarding a form, so it can’t find responses that went missing before you turned it on (use the CSV download for those). It doesn’t relink the form or edit the form; you fix the link yourself. Recovery depends on the Google Forms API and on the person who turned it on having access to the form. The free plan covers one form and shows problems in the sidebar; recovery and email alerts are on Pro.

It’s on the Google Workspace™ Marketplace. The guide is at kayabyte.dev/workspace/sheet-guard.

FAQ

Why are my Google Form responses not updating in the sheet? Most often the form was unlinked, or relinked into a new tab such as Form Responses 2. Check the form’s Responses tab to see where it’s linked, and look for other response tabs in the spreadsheet.

If I delete a row from the response sheet, is the response gone? No. The response is still in the form. Download it as a CSV from the form’s Responses tab, or find the row in the spreadsheet’s version history.

Can I recover responses deleted from the form itself? No. Google says deleting responses in a form can’t be undone. If the sheet still has them, keep that copy.

Can I rename the Form Responses tab? Google doesn’t document this. Third-party guides rename the tab as a normal step, and I haven’t found a report of a rename breaking the link. Formulas that use the old name need updating, though. Submit a test response after renaming to be sure.

Last checked: 22 October 2026

Questions or corrections: support@kayabyte.dev. Google Forms, Google Sheets and Google Workspace are trademarks of Google LLC. Kayabyte is an independent developer and is not affiliated with Google.