Send form data to a Google Sheet

A form can write its submissions to a Google Sheet as they come in. Each submission adds the responses people gave, the time they submitted, and the name, link, and size of each uploaded file to a spreadsheet you can sort, filter, and share without opening EZ File Drop. This is available on the Business and Premium plans.

It does not matter where the form's files are delivered. A form that delivers files to Dropbox can still write its form data to a Google Sheet. What you need is a Google account connected under Cloud Connections. Until one is, the setting is dimmed and shows "Connect a Google account in your Cloud Connections to use this feature." To connect one, see Connect Google Drive.

This is set up per form. Connecting a Google account does not start any syncing on its own.

Turn on the Google Sheet

1. On the Upload Forms page, open your form.
2. In the Build tab, open Form Setup.
3. Scroll to the bottom and find Save form data to a Google Sheet. Turn it on.

Two buttons appear: Create a new Google Sheet and Select an existing Google Sheet.

Create a new Google Sheet

This is the shorter path, and it makes a Sheet that is guaranteed to be in the right state.

1. Click Create a new Google Sheet.
2. The Sheet name field is prefilled with your form's name followed by the word Submissions. Change it or keep it.
3. Click Choose folder in Google Drive and pick where the Sheet should live. Google's own folder picker opens, with tabs for Folders and Shared drives.
4. If the form already has submissions, decide whether to include them. See Add the submissions you already have, below.
5. Click Create Sheet.

EZ File Drop creates the Sheet in your Drive, adds the column headings, and links it to the form in one step.

Link a Google Sheet you already have

You can point the form at any Google Sheet in your Drive. EZ File Drop always writes to the Sheet's first tab, and linking a Sheet whose first tab has content erases that tab.

1. Click Select an existing Google Sheet.
2. Click Choose a Google Sheet. Google's spreadsheet picker opens, with tabs for Spreadsheets and Shared drives.
3. Pick the Sheet. EZ File Drop checks it for a moment and shows "Checking sheet…".
4. If the Sheet's first tab is blank, it links with no warning.
5. If the first tab has content, a warning explains that linking will erase everything on that tab and names it, for example "Responses". Other tabs in the Sheet are not touched. Click Erase and link to go ahead.

If EZ File Drop cannot check the Sheet, it shows the same warning. Nothing is erased without one.

After the Sheet is linked, you can rename the tab or move it within the Sheet and syncing keeps working. EZ File Drop tracks the exact tab, not its name.

Add the submissions you already have

If the form already has submissions, both the create and link steps include a checkbox, ticked by default, that reads Add the 12 existing submissions to this sheet with your form's own count in place of 12. With a single submission it says "submission."

Leave it ticked to fill the Sheet with every existing submission right away. Untick it to write only submissions that come in after the Sheet is linked. EZ File Drop remembers that choice, so older submissions are never added later, even when you rebuild the Sheet. Forms with no submissions don't show the checkbox.

If you use Change sheet to switch Sheets, you're asked again, and your new answer replaces the old one.

The Google Sheet setting once a Sheet is linked

With a Sheet linked, the setting shows:

• "Selected sheet": the Sheet's name, in a read-only field. The icon at the right end of the field opens the Sheet in Google Sheets in a new tab.
• Sheet options: the three dots to the right of the field. It has two choices, Change sheet and Rebuild sheet.
• Change sheet: switches the form to a different Sheet, new or existing.
• Rebuild sheet: clears the Sheet and rewrites it with your current settings. See Rebuild the Sheet, below.
• "Sheet columns": a summary such as "10 of 14 columns are written to the sheet", with a Choose columns button.
• "Rows for multi-file submissions": the row layout, with three options.

Choose which columns are written

By default every form field is written to a column in the Google Sheet. The Sheet starts with Upload Timestamp, then one column for each of the form's fields in the order they appear on the form, File Upload fields included, then three columns for the file: Download Link, View Link, and File Size. A Name field set to collect a first and last name separately gets two columns rather than one.

Upload Timestamp shows when each submission was made, in the time zone set on your Google Sheet. You can check or change it in Google Sheets under File > Settings. On US Sheets it reads like 10/19/2026 3:20 PM. Sheets set to another locale use Google's standard date and time format for that locale. Rows written before October 19, 2026 show UTC time until you rebuild the Sheet.

Click Choose columns to change this. In the box that opens you can:

• Turn each column on or off with its toggle.
• Drag a column by its handle to change its order in the Sheet.
• Click Reset to default to put every column back to the default.

Click Save to apply your changes, or Cancel to close the box without changing anything. If the Sheet already has rows, saving a change asks you to rebuild the Sheet. See Rebuild the Sheet, below.

New form fields are added to the end of the Sheet automatically. If the Sheet already has rows when you add a field, you're asked to rebuild it so the existing rows line up with the new column.

Choose how multi-file submissions are laid out

"Rows for multi-file submissions" controls what happens when someone uploads more than one file in a single submission:

• Every row (the default): each file gets its own row, and the form responses are repeated on every row.
• First row only: each file gets its own row, but the form responses and submission time appear only on the first row.
• One row: the whole submission goes in a single row, and all the files are listed together in one cell.

With Every row and First row only, counting rows counts files rather than submissions. Keep that in mind before you build a formula or a pivot over the Sheet. With One row, each row is one submission.

The link columns hold clickable links whose text is the file's name. For files delivered to Google Drive you get a download link and a view link. For other destinations both columns hold the same link. In One row layout, a single file's link is clickable, but several files appear as plain web addresses.

A submission with no files still writes one row, with the file cells left blank.

Rebuild the Sheet

Rebuilding clears the Sheet's tab and rewrites every submission using your current settings.

You can rebuild at any time. Click the three dots next to "Selected sheet" and choose Rebuild sheet. A box asks you to confirm, then the rebuild starts. This is useful for bringing older rows up to date, for example to show timestamps from before October 19, 2026 in your local time.

You're also asked to rebuild when a settings change needs it. Every row in the Sheet always uses the same layout, so if the Sheet already has rows and you change the columns or the row option, a box asks you to confirm:

• Rebuild sheet keeps your new setting, clears the tab, and rewrites every submission in the new layout. Any manual edits or extra columns you added to that tab are lost.
• Undo change puts your previous setting back and leaves the Sheet untouched. Pressing Escape or clicking outside the box does the same.

If you chose not to add existing submissions when you linked the Sheet, a rebuild only rewrites the submissions that came in after that. The confirm box says so.

While a rebuild runs, the "Selected sheet" field shows a spinning icon and "Rebuilding…". The Sheet options menu choices, Choose columns, and the row options are dimmed until it finishes. The open icon in the "Selected sheet" field still works, so you can watch the rows fill in. A confirmation appears when it's done. Small forms take a few seconds, and large ones take longer.

To keep a copy of a Sheet you've edited by hand, use Change sheet in the Sheet options menu to start a new Sheet instead of rebuilding. The old Sheet stays in your Drive as it is.

When syncing stops

If rows stop being written, the setting shows why, and the form owner gets an alert email. The form keeps working and files keep being delivered either way.

• If the tab was deleted, the setting shows "The tab this form writes to was deleted from the Google Sheet. Use Change sheet in the Sheet options menu to pick a sheet." EZ File Drop won't start writing to a different tab on its own. Use Create a new Google Sheet or Select an existing Google Sheet in the error box to pick one.
• If Google access was lost, for example because access was removed or the connection expired, the setting shows an error asking you to reconnect your Google account on the Cloud Connections page.

Once the problem is fixed, a Rebuild button appears on the setting. Click it to rewrite the Sheet from scratch, including submissions that arrived while syncing was stopped.

Turn off the Google Sheet

Turning Save form data to a Google Sheet off disconnects the Sheet. It is not a pause. The form stops writing rows, and the link between the form and that Sheet is removed. The Sheet itself and every row already written to it stay in your Google Drive untouched.

Behavior notes

• Save form data to a Google Sheet is available on the Business and Premium plans.
• The setting needs a connected Google account, not a Google Drive upload destination. The form's files can be delivered anywhere.
• Nothing is written until a Sheet has been created or linked. Turning the setting on is not enough on its own.
• EZ File Drop writes to the Sheet's first tab. Linking a Sheet whose first tab has content erases that tab after a warning. Other tabs are never touched.
• Renaming or moving the tab doesn't break syncing. Deleting it does.
• Use a Sheet that's only for this form, and don't type into the rows EZ File Drop manages. A rebuild replaces them.
• You can rebuild the Sheet at any time from the Sheet options menu. If you chose not to add existing submissions when you linked the Sheet, a rebuild keeps to that.
• Upload Timestamp uses the time zone set on your Google Sheet.
• A row is written once a submission finishes delivering to your upload destination, not at the moment someone clicks submit. Submissions that fail, or that arrive without their files, are never written.
• New form fields are added to the end of the Sheet automatically. If the Sheet already has rows, you're asked to rebuild it so they line up.
• Every row is the default layout. A submission with several files produces several rows carrying the same responses.
• Changing the columns or row layout on a Sheet that has rows rebuilds the whole Sheet. Undo change cancels without touching it.
• Sync problems show on the setting and trigger an alert email to the form owner. Rebuild rewrites the Sheet once the problem is fixed.
• The Sheet carries form data. Uploaded files are still delivered to the form's upload destination, not to the Sheet.
• Changes are saved automatically, but a Live form keeps using its last published setup until you click Publish changes.