Google Sheets integration: Submissions not syncing properly

Dear Jotform Support Team,

I hope this message finds you well. I am reaching out to report a recurring issue with the integration between Jotform and Google Sheets. I’ve noticed that form submissions are frequently not syncing properly—some responses go missing and are not reflected in the connected Google Sheet.

The only way I’ve been able to recover the missing data is by redoing the integration manually, which is both time-consuming and inconvenient, especially considering how often this problem occurs.

Could you please help me find a permanent solution to this issue, or let me know if there’s a fix or update available that can stabilize the integration?

Links:
https://form.jotform.com/251105444158653

https://form.jotform.com/251105223074645

Thank you very much for your support. I look forward to your response.

Best regards,

Hi Francisco,

Thanks for reaching out to Jotform Support. In most cases, disconnecting and reconnecting the Google Sheets integration resolves this issue. 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:

1. While in Google Sheet Integration settings, click on the Add New Action button.
2. Now, select an action and click on Next.
3. Then, click on Add Action and customize settings as you want.
4. 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.

When reconnecting, ensure you do not rename column headings or add filters in the Google Sheets spreadsheet, as these changes can break the integration. Also, avoid inline edits in Jotform Tables expecting them to update Google Sheets, as this is not supported. After reconnecting, make a test submission to verify that new data is properly syncing to your Google Sheets.

Can you give it a try and let us know how it goes? If you continue to experience issues, check the integration’s action logs available in the integration settings to see successful and failed runs, which can help troubleshoot further.

Once we hear back from you, we'll be able to move forward with solution.