Google Integration did not bring over existing submissions

I just did the Google integration to the form and had checked Send existing submissions to the sheet but when I bring up the Google sheet there are no submissions. I have tried multiple times and I can never get the submissions to come over.

Hi Discovery,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

Regarding your Google Sheets integration issue where existing submissions are not appearing, here’s a quick solution:

1. Go to Settings in your Form Builder.
2. Select Integrations and find the Google Sheets integration.
3. Remove the current integration by clicking Remove Integration and confirming.
4. Reconnect the integration following the guide on how to integrate forms with Google Sheets.
5. Make a test submission to check if new data appears in your Google Sheet.

Note that editing or renaming columns in the Google Sheet may break the integration, so avoid changes there. Also, the option to send existing submissions only works at the time of integration setup.

Give this a try and let us know if you need any more help.

Reach out again if you need any other help.

Hi Discovery,

The Send existing submissions option should populate your sheet at the time of integration setup, but sometimes it doesn't push through correctly. To resolve this, you can remove the current Google Sheets integration from your form and reconnect it. When reconnecting, make sure the Send existing submissions box is checked again. After reconnecting, test with a new submission to confirm that new entries are syncing correctly. It's easy to re-integrate the Google Sheet integration. First, we’ll remove the existing Action. Let me show you how to do it:

1.  In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2.  In the menu on the left, click on Integrations and select the Google Sheets integration.
3.  Then, hover over the Action section and click on the Three Dots icon.
4.  In the dropdown menu, select Delete Action, and in the window that opens, click on Yes, Discard. Now, let's connect the Google Sheets Integration again:
5. While in Google Sheet Integration settings, click on the Add New Action button.
6.  Now, select an action and click on Next.
7.  Then, click on Add Action and customize settings as you want.
8.  Once you finish customizing, click on the Save button at the bottom right of the settings.

If you select Create new spreadsheet, a new spreadsheet will be created in your Google account, where submissions will be collected. If you select Use existing spreadsheet, submissions will be collected in the spreadsheet you choose, which is already connected to your Google account. We also have a guide about How to Integrate Forms With Google Sheets that you can check out. If the existing submissions still don’t appear after reintegration, you can download your submission data as Excel/CSV from your Jotform Tables and manually import it into the Google Sheet to backfill those responses. From that point forward, all new submissions should flow in automatically.

You can easily download your data from Jotform Tables as a CSV, Excel, or PDF file. Let me show you how:

1.  On your My Tables page, hover over the form whose data you want to download, and click on View Table.
2. On the upper-right side of the page, click the Download All button. 
3.  Now, select Download as CSV, Excel, or PDF to download your data.

You can also check out our How to Download Form Submissions as Excel, CSV, or PDF guide for more information.

Give it a try and let us know if you have any other questions.

I have reintegrated the form three times now and it still does not bring over the data.

It is now magically working.