Google Sheets integration stopped syncing submissions

https://www.jotform.com/build/202171514887457

The Excel form suddenly stopped syncing after September 16 at 7:50.

Hi SIS,

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

Regarding your issue with the Excel form suddenly stopping syncing after September 16 at 7:50, let me help you with that:

There could be several reasons why your form submissions are not reflecting in Excel as expected. Here are some steps you can take to troubleshoot the issue:

1. Check Integration Status: Verify if the integration between your Jotform and Excel is still active and connected properly.
2. Review Zapier or Automation Settings: If you are using Zapier or any other automation tool to sync data, ensure that the automation is enabled and running without errors.
3. Inspect Form Submissions: Confirm that new submissions are being received in your Jotform account and that there are no submission limits or restrictions.
4. Reauthorize Connection: Sometimes, reauthorizing or reconnecting the integration can resolve syncing issues.
5. Check Excel File Permissions: Make sure the Excel file is accessible and not locked or moved, which could disrupt syncing.

If these steps do not resolve the issue, please provide more details about how your form is connected to Excel (e.g., direct integration, Zapier, other tools) so we can assist you further.

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

Hi wwong206,

When this happens, the quickest fix is to remove the integration and then add it back. Doing this usually re-establishes the sync and gets everything back on track. 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.

Reach out again if you need any more help.