Sync Form Submissions with Google Sheets Integration

Our Sheets integration stopped working for a day. I re-authorized and re-connected it. It prompted me to resend current submissions, but I did not want to send the thousands of submissions again. I do want to sync just the few that came through today. How do I sync just those, or re-sync if a change is made to an earlier submission? Thanks.

Hi Amber,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

Regarding your Google Sheets integration, when you re-authorized and re-connected it, the option to resend current submissions sends all existing submissions, which can be overwhelming if you have thousands. Unfortunately, there isn't a built-in feature to selectively sync only the new submissions that came through after re-authorization or to re-sync specific earlier submissions individually.

Here’s what you can do:

1. For new submissions going forward: Once the integration is reconnected, new submissions will automatically sync to your Google Sheets.
2. For submissions that came through today: You would need to manually export those specific submissions from Jotform and then import them into your Google Sheets separately, as the integration does not support selective resending.
3. For re-syncing changes to earlier submissions: Edits made directly in Jotform Tables or via entry editing do not automatically update Google Sheets. You would need to manually update the spreadsheet or redo the integration to resend all submissions.

To avoid resending thousands of submissions, consider exporting only the needed submissions as a CSV or Excel file from Jotform and then import that file into your Google Sheets manually.

If you want to see or manage your integration settings, you can access the integration options in your form's Settings > Integrations > Google Sheets, where you can view logs, disable, or delete the integration.

Give it a try and let us know how it goes.

When I download the entries to import into Sheets, it downloads different columns than what syncs; there are some missing columns and the First and last name (separate in submissions and Sheets) downloads as one merged entry.

Hi Amber,

When you download entries from Jotform to import into Google Sheets, the downloaded file may have differences in columns compared to what the Google Sheets integration syncs. This happens because:

• The Google Sheets integration automatically sends all form fields as separate columns, including fields like First Name and Last Name as separate columns if they are separate fields in your form.
• When downloading submissions as CSV or Excel, some fields might be merged or formatted differently, such as First and Last Name appearing as one combined entry if they were submitted as a single full name field or if the download format merges them.
• Some columns might be missing in the download if they are not included in the selected fields or due to the export format limitations.

To align the downloaded data with your Google Sheets integration columns, you can:

1. Check your form fields: Ensure First Name and Last Name are separate fields in your form if you want them separated in downloads.
2. Review export options: When downloading, select the appropriate format (CSV or Excel) and check if there are options to customize which fields to include.
3. Manually adjust downloaded file: After downloading, you may need to split merged columns (e.g., split full name into first and last) or add missing columns manually before importing into Google Sheets.

Note that renaming columns or applying filters in Google Sheets after integration may break the sync or stop updates, so keep the column headers consistent with your form fields.

Give it a try and let us know how it goes.