Google Spreadsheet integration failing

  • enzomanolo
    Asked on January 6, 2017 at 5:49 PM

    When I setup integration with google spreadsheet it works for a few submissions and then stops updating the spreadsheet. I have seen in your online forum that this is recurring problem.

    If I remove the integration on the form and then add it back, yes it will work again. I have seen this behavior with several but not all our forms (all cloned from each other). I have tried one of the recommended tips to edit a field name on the form but it did not make the form resync.

    I would love for broken links to be resynced because we must format the target spreadsheet (align left, auto-wrap and narrow the column width) so removing and reintegrating is NOT our preferred choice. We do NOT change any field text. I suspected formatting the target was the root cause so I tried to recreate a CLONE of a form and test new submissions after each format change but was not able to reproduce the problem (make it stop populating the target spreadsheet). It seems random.

    Here is the link to two of our broken forms:

    https://form.jotform.com/63506728875266

    https://form.jotform.com/63506226054248

    Here is a link of the CLONE that will not break (source form of the first link above). ;-)

    https://form.jotform.com/70056301341239

    Thank you!

     

  • Kiran Support Team Lead
    Replied on January 6, 2017 at 11:13 PM

    We didn't notice any recent issues with Google spreadsheet integration and it should be working fine. Generally, the integration fails when there are any modifications made to the spreadsheet. Since you say that the integration is working fine with the cloned form, it may be a form specific issue. I have tried clearing the form caches of your account. Please try integrating Google spreadsheet again and see if that works.

    Let us know if you need any further assistance. We will be happy to assist.