Connect form responses to Google Sheets and check the results
Set up a managed response tab, understand its columns and file links, and check pending deliveries when a Google Sheets sync stalls.
Colleagues who work outside the form dashboard can read submissions in a Google spreadsheet. ThunderForms can create one or add a managed response tab to a spreadsheet the team already uses. Check the first rows before building a report around them.
Connect Google and choose a destination
Save your form and open its Google Sheets integration to connect the Google account that also serves Forms import and Drive uploads. Check the displayed account name and email, especially if you use separate personal and work accounts.
Choose an existing spreadsheet or create a new one through the setup panel. The connection adds a fresh response tab and leaves your other tabs available for reports. Use that Google account for future connections.
Inspect a test row
Submit through the published form. Builder preview does not send responses. The first columns are Submission ID and Submitted At, followed by questions in form order. The timestamp uses an ISO date and time with a UTC offset of zero, so account for your local time when grouping submissions by day.
Choice answers use stored option values, so a label such as "Customer Support" might arrive as "customer_support". Booleans appear as Yes or No. Unanswered fields stay blank. For uploads, open a synced Drive link with a reviewer's account and confirm that their permissions allow them to view the submitted file.
A typical row has this shape: a submission ID, a timestamp, then one column for each question in the form. If a choice label says "Customer Support", the stored answer may be an internal option value such ascustomer_support. Build any report from the stored values you see in the test row, not from a guessed label. This matters when a formula compares answers against a text string.
Keep calculations in another tab
ThunderForms manages the response columns. New questions append columns, removed questions retain their historical columns, and saving a renamed question updates the header in an active Sheets connection. Direct header edits can be overwritten.
Leave the managed columns in their original positions. Put formulas, custom headings, and combined reports in a separate tab that reads from the response tab. Add a new question when its meaning changes. For example, changing "Department" into "Office location" would otherwise leave earlier department names mixed with office addresses under the same header.
When a row is missing
Confirm the submission exists in ThunderForms Responses. Then inspect the Sheets integration's last sync time, pending and failed counts, and any displayed error. Delivery can lag. A missing sheet row does not by itself mean the form lost the response.
Reconnect using the same Google account when authorization is required, and remember that disconnecting it also pauses Sheets sync and affects Forms import and Drive uploads. Check the destination status. Use Resume sync if it is paused, then submit a test response and confirm its submission ID reaches the expected tab.
Give the response tab a safe reporting layer
Keep the managed response tab intact and make a second tab for reports. Reference the managed tab by name and build totals or filters from the incoming rows. For example, a coordinator might count registrations by event session in the report tab while leaving the original answers untouched. This separation makes it easier to tell which values came from respondents and which calculations the team added.
Before relying on a formula, submit two test answers with different choices and one unanswered optional field. Confirm that the formula counts the stored choice values you expect and does not treat a blank as a response. If a question is renamed or removed later, inspect the managed headers and update report references deliberately.
Check sharing before you send the sheet
A person who can open the spreadsheet may still be unable to open an uploaded file linked from a response. Test both permissions with a reviewer account. Give the reviewer only the access needed to read submissions and attachments, and avoid publishing a response sheet with personal information through a public link.
Frequently asked questions
Short answers to the questions every reader asks next.
To try the setup on a separate form, open the builder and add a few questions before connecting the test spreadsheet.