What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Google Sheet integrations stop working

    Asked by villewiik on October 31, 2016 at 04: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.

    integrations sheet stop submission data
  • Profile Image
    JotForm Support

    Answered by Boris on October 31, 2016 at 07: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:

    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.