Google Sheet integrations stop working

  • villewiik
    Asked on October 31, 2016 at 4:01 AM

    When a form isn't submitted for a few weeks, integration with Google Sheets stops working. The only way I've found for fixing this is reintegration but it isn't s suitable solution for it creates a new sheet and I also have to recreate all the charts etc that I've done with the submission data.

    Is this a common issue or is there a way for me to fix this by myself?

    Thanks.
    Paula.

  • Boris
    Replied on October 31, 2016 at 7:24 AM

    When an integration between a form and Google Spreadsheets is already broken, the only way to re-create it is by refreshing the connection, which means to remove the old integration and set it up again:

    https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    The integration should not of itself break, even if you are not using it for a while. I have made a submission on one of my earlier integrated spreadsheets that was rarely used, and it is still working correctly:

    Google Sheet integrations stop working Image 1 Screenshot 20

    What usually causes the integration to break is if there is a modification performed on the integrated sheet. Modifying the spreadsheet, especially modifying its headers, or modifying the settings such as default date format and similar, can cause the integrated sheet to be re-formatted in a way that the integration can no longer update it.

    Please re-integrate your form again, and make sure you are not making any modifications on the integrated sheet so that the connection doesn't get broken.

    I hope this helps.