Google Spreadsheets integration stopped syncing

  • Profile Image
    iondjp
    Asked on March 16, 2018 at 11:22 AM

    I had set-up google integration to send form data to spreadsheet. It was working fine. Yesterday I noticed new entries were not appearing in Google Sheets.

    This Google spreadsheet has additional sheets with filter views and AutoCrat PDF scripts setup. So, I REALLY do not want to hear that I have to delete the connection and set this up again.

    I didn't want to go into the JotForm Google integration for fear of 'breaking' the link.

    Is there a way to know whether this is due to Google end or JotForm end?

    Is it possible that I have not given enough time to see the updated test entry I created today?

  • Profile Image
    Adrian
    Answered on March 16, 2018 at 12:54 PM

    Is this the form that you are talking about? https://form.jotform.com/70871013832249

    Confirm this and we will try to resync the sheet.

    Please note that making changes to your form such as changing the text of the questions or adding/removing a question will most likely break the integration.

    Making changes to the integrated spreadsheet directly will break the integration as well.

  • Profile Image
    iondjp
    Answered on March 16, 2018 at 02:57 PM

    Yes that is the form.

    That would explain it. I believe I have made changes before on JotForm end, but I did not have a problem.

    I recently deleted some columns that were unrelated to jotform fields (they were added by AutoCrat). I suspect that may have been the cause.

    I have more work to do on the form. Maybe it would be better if I waited before I got you to re-sync? Or, should we do it now?

  • Profile Image
    Welvin
    Answered on March 16, 2018 at 04:06 PM

    I would suggest making the changes, then re-integrate Google Spreadsheet. You will be given a new sheet after re-integration. Re-syncing won't permanently fix the problem, so I would suggest doing that.

    Also, if you plan to process the data to Google Spreadsheet, please use an ImportRange function to do it in another spreadsheet file.

    https://support.google.com/docs/answer/3093340?hl=en