Google Forms · Updated September 2026 · 9 min read

Link a Google Form to Google Sheets, and fix it when it stops updating

To link a Google Form to Google Sheets takes four clicks. Keeping the link healthy is the harder part: a renamed tab, an inserted column or a formula typed in the wrong place is behind most "Google Form not updating sheet" threads. This guide covers the setup, then the fixes, then how to build formulas and scripts that survive new responses.

By Raj Kumar, Founder, Zunoform

A paper ribbon feeding into a grid of sage and cream tiles, with one tile lifted out of line

The short answer

Open the form, go to Responses, click the More menu next to the Summary view and choose "Select destination for responses". Pick "Create a new spreadsheet" or "Select existing spreadsheet" and confirm. New responses then arrive as rows in a Form Responses tab; unlink from the same More menu, and your existing data stays in the sheet.

Treat the response tab as read-only. Do your formulas, sorting and notes on a separate tab.
New questions get new columns in the response tab, which may not match the form's order.
Google stops syncing to Sheets past 100,000 responses.
Unlinking and relinking writes a fresh tab from the responses stored in the form.

How do you link a Google Form to Google Sheets?

Steps from Google's "Choose where to save form responses" help page, checked 28 September 2026.

Open the form's Responses tab

Open the form in Google Forms and click Responses, then Summary.

Choose a destination

Click More (the three dots) and select "Select destination for responses". Newer layouts also show a green "Link to Sheets" button that opens the same choice.

New or existing spreadsheet

"Create a new spreadsheet" makes a fresh file. "Select existing spreadsheet" adds a new response tab to a file you already use, which is handy when a dashboard tab should sit in the same file.

Confirm and check access

Click Create or Select. Google notes that form collaborators get access to a newly created sheet, but later permission changes on the form don't carry over, so remove people from the form and the sheet separately.

Submit a test response

Open the live form in a private window, submit once and confirm the row appears. Then delete the test row with right-click, Delete row, rather than clearing the cells.

What happens in the sheet when you edit the form?

The link maps questions to columns, not column positions to questions, which explains most of the surprises. The behaviour below is widely reported by Google Forms users and add-on vendors; Google's help pages don't document it in detail, so check it on a copy of your form before a big edit.

Adding a question

A new question gets a new column, typically at the right-hand end of the response tab, even if you inserted the question at the top of the form. Old rows have that cell empty. If column order matters for a report, build the report on a separate tab and pick columns by header name there, not by position.

Renaming, moving or deleting a question

Rewording a question renames its column header, and the old answers stay underneath. Moving a question in the form does not move its column. Deleting a question leaves its column and its past answers in the sheet; new rows simply leave it blank. That is usually what you want: the history survives.

Editing the response tab directly

This is where things break. Inserting a column inside the response range can shift later answers under the wrong headers. Merging cells or sorting a single column scrambles rows. Stray text, spaces or formatting far below the data can make new rows land hundreds of rows down. Renaming the tab is reported to keep new rows arriving; normal formula references follow the rename, but a tab name typed inside a text string, as in INDIRECT, does not.

Google Form not updating the sheet? Causes and fixes

Work down the list. Most fixes take a minute; relinking is the safe last resort because the form keeps its own copy of every response.

Symptom	Likely cause	Fix
No new rows at all	Form was unlinked, or you are looking at a copy of the spreadsheet	Check Responses → More: if it offers a destination, relink. File → Make a copy never carries the link.
Rows appear in a new tab	You relinked, or chose an existing spreadsheet	Use the newest Form Responses tab; point formulas at it
Rows land far below the data	Stray values or formatting in empty rows	Delete (not clear) the unused rows under the data
Answers under the wrong header	A column was inserted or cells merged inside the response range	Remove the inserted column, or unlink and relink to get a clean tab
Formula column misses new rows	Formula typed per row next to the responses	Move it to a separate tab with one ARRAYFORMULA or QUERY
Deleted response still in the sheet	Deleting in Forms doesn't delete the sheet row	Delete the row in the sheet too
Sync stopped on a large form	More than 100,000 responses	Download responses as CSV and start a new form

Sources: Google Docs Editors Help: Choose where to save form responses · Google Docs Editors Help: View & manage form responses · Google Docs Editors Community: deleting a response doesn't remove the sheet row

How do you unlink a Google Form from a sheet, and relink it?

Open the form, go to Responses, then Summary, click More and choose "Unlink form", then confirm. Google's help page is explicit about the result: new responses stop going to the spreadsheet, and the data already there remains. The file and the tab are not deleted.

To relink, use "Select destination for responses" again. Google Forms stores every response itself, and when you link a destination the new tab is filled with the responses the form still holds, not only new ones; add-on vendors describe the same backfill, though Google's page doesn't spell it out. That makes unlink-and-relink the cleanest repair for a scrambled response tab: you get a fresh, correctly ordered tab, and the damaged one stays as an archive. Two cautions: responses you deleted in Forms won't come back, and any edits or notes you typed into the old tab won't carry over, which is one more reason to keep them on a separate tab.

Source: Google Docs Editors Help: Choose where to save form responses

How do you use formulas with a Google Form response sheet?

Don't type formulas into the response tab. Each response is written as a new row, and a formula you typed and dragged down in the neighbouring column isn't copied into it, so new rows arrive without a result. The durable pattern is a second tab that reads from the response tab with one formula in the top cell, which covers every row now and in future.

QUERY is the most flexible choice: it selects, filters and sorts by column letter and keeps the header row. ARRAYFORMULA suits a single calculated column, such as days since the response. Wrapping it with a header in curly braces keeps the header and the calculation in one cell. If your spreadsheet locale uses commas as decimal separators, swap the commas between arguments for semicolons, and the semicolon inside the braces for a backslash.

Copyable formulas for a separate "Working" tab

Cell A1 of a new tab, all responses with an answer in column C, newest first:
=QUERY('Form Responses 1'!A:F, "select A, B, C, E where C is not null order by A desc", 1)

Cell G1 of the same tab, days since each response (column A of this tab is the timestamp):
={"Days since"; ARRAYFORMULA(IF(A2:A="", "", INT(TODAY() - A2:A)))}

Cell H1, a count of responses per answer in column C:
=QUERY('Form Responses 1'!A:F, "select C, count(A) where C is not null group by C order by count(A) desc", 1)

Adjust the tab name and column letters to your sheet. If you relink the form, the new tab is usually named Form Responses 2, so update the references.

Can you run a script when a Google Form is submitted?

Yes, with Apps Script and an installable form-submit trigger. In the response spreadsheet, open Extensions, then Apps Script, paste a function, then open Triggers, click Add Trigger, choose your function, event source "From spreadsheet" and event type "On form submit". Google's documentation notes that installable triggers run under the account of the person who created them and count against Apps Script quotas.

The trigger passes an event object. From a spreadsheet trigger you get namedValues (question titles mapped to arrays of answers), values (the row in sheet order) and range (the cells just written). A trigger on the form itself gives you response and source instead. Keep the script's output off the response tab: appending to a separate tab avoids every column problem above.

Source: Apps Script: Event objects

Source: Apps Script: Installable triggers

Starter script: copy each new response into a review queue

function onFormSubmitToQueue(e) {
  var v = e.namedValues;
  var email = (v['Email'] || [''])[0];
  var topic = (v['Topic'] || [''])[0];
  var queue = SpreadsheetApp.getActive().getSheetByName('Queue');
  queue.appendRow([new Date(), email, topic, 'New', e.range.getRow()]);
}

Create a tab named Queue first, and change 'Email' and 'Topic' to your exact question titles. Then add an installable trigger: From spreadsheet, On form submit. The last column records which response row it came from.

Where Zunoform fits (and where it doesn't)

Zunoform's Google Sheets integration is free on every plan. Connecting it signs you in with Google and creates a new spreadsheet named after the form, with a Responses tab. Each submission adds a row with Timestamp, Response ID, one column per answer (multi-part answers such as contact details get one column per part), Location and User Agent, then one column per hidden field, headed with the parameter name. Values are written as plain text, and anything starting with =, +, - or @ is escaped so a respondent can't inject a formula.

The trade-offs, honestly: the integration writes new responses from the moment you connect and doesn't copy earlier ones, so export CSV for those. When you change the form, Zunoform rewrites the header row to match the current questions but leaves earlier rows where they were written, so after reordering or inserting questions, older rows can sit under new headings. The same separate-tab advice applies. Google Forms' own link is free with unlimited responses; Zunoform Free is capped at 500 a month. You'd switch for hidden fields, logic, payments or layouts, not for the sheet itself. Details are on /integrations/google-sheets, and our importer can rebuild an existing Google Form.

Questions people ask

Why is my Google Form not updating the Google Sheet?

Check that the form is still linked (Responses, More, Select destination), that you are looking at the right file rather than a copy, and at the newest Form Responses tab. Then look for inserted columns, merged cells or stray values below the data. If the tab is scrambled, unlink and relink to write a clean one.

Can I link a Google Form to an existing spreadsheet?

Yes. Choose "Select existing spreadsheet" when you pick the response destination. Google adds a new response tab to that file rather than writing into a tab you already have, so point your dashboard formulas at the new tab by name.

If I unlink a Google Form, do I lose the responses?

No. Google says new responses stop going to the spreadsheet and the current data remains. The form also keeps its own copy of every response, so relinking later writes them into a new tab. Only responses you deleted inside Forms are gone for good.

Why do new questions appear at the end of the sheet?

The link maps each question to its own column and typically appends a column for a new question rather than inserting one in the middle, so existing columns don't shift. If you need form order, build a separate tab that selects the columns you want in the order you want.

Can I add formulas to a Google Form response sheet?

Put them on a separate tab. Each response arrives as a new row, so a formula dragged down next to the responses doesn't reach it. One QUERY or ARRAYFORMULA in the top cell of another tab covers every current and future row.

Does deleting a response in Google Forms delete it from the sheet?

No. The linked sheet keeps the row, which Google Forms users regularly report in Google's community forum. Delete the row in the sheet as well, using Delete row rather than clearing the cells, so later responses don't land below a gap.

Can two Google Forms send responses to the same spreadsheet?

Yes. Link each form to the same file with "Select existing spreadsheet" and each gets its own response tab. To see them together, combine the tabs on a separate summary tab with QUERY, rather than merging them by hand.

About the author

Raj Kumar · Founder, Zunoform

Raj Kumar is the founder of Zunoform, the form builder made by Symphonic Grow. He builds the product and writes these guides, checking every competitor price and feature claim against the vendor's own pages before publishing.

Raj Kumar on LinkedIn

Start free — 500 responses/mo Browse templates