Google Sheets integration has stopped working

  • Profile Image
    gotonovy
    Asked on June 20, 2017 at 08:24 PM

    I just have an issue at the moment where the integration from my form to Google Sheets has stopped working.

    All the previous submissions have come through fine, although any new ones as of 20/06/17 have stopped coming through. I can still see the new submissions through JotForm, but they haven't appeared on the sheet.

    I have added 3 columns at the end of the spreadsheet. I'm not sure whether this has affected it? I haven't changed anything else.

    The form I'm using is https://form.jotform.co/71552646575868

    Any help on this would be appreciated

    Thanks

  • Profile Image
    EltonCris
    Answered on June 20, 2017 at 11:38 PM

    Yes, that's definitely the reason why it has stopped from working.

    When I tried to sync your submissions with your Google Spreadsheet, it prompted this error. This most likely happened when the integrated spreadsheet was edited.

    Unfortunately, we do not recommend editing the integrated spreadsheet. Chances are it would break the integration.

    If you want to add something to the spreadsheet, you can do it on a separate tab sheet.

    Thanks

  • Profile Image
    gotonovy
    Answered on June 21, 2017 at 09:12 AM

    Thanks for your reply. I have now redone the integration of the form and have not added any columns, just editing the data in a few cells, yet I am still getting this issue.

    What else is causing this problem? Are you not able to change the text in individual cells? I'm sure it worked last year when I did the same thing.

  • Profile Image
    BDAVID
    Answered on June 21, 2017 at 12:30 PM

    I just also tried to push the missing submissions manually, but an error occurred:

    Please remove the integration, and integrate back-again, this time do not do a single edit on the newly integrated spreadsheet: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    Also, if you still need to apply some edits in the spreadsheet, you can use the import range feature to pull the data from the integrated spreadsheet into a new one, in that way the integration will remain intact, and you can customize the new one.