Google Spreadsheets integration stopped syncing

  • Profile Image
    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
    Answered on March 16, 2018 at 12:54 PM

    Is this the form that you are talking about?

    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
    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
    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.