Google Spreadsheet Integration: submissions not updated in spreadsheet.

  • Profile Image
    nuparadygm
    Asked on February 23, 2017 at 04:29 AM

    Same problem happened again, please check and rectify asap. We need a permanent solution for this, we can't keep de-integrate and re-integrate with google every time.

    Submissions not updated in Google Sheets (Private)

    Asked by nuparadygm on January 13, 2017 at 02:06 AM

    I've two almost identical forms (Sign In and Sign Out), both are integrated with Google Sheets. Sign In form is not able to update the submission to its google sheets, no problem to the Sign Out form. I tried reintegrate the Sign In form and submissions updated correctly but the subsequent submissions still not able to update.

    I tried using the same Sign In form and integrate with another google account, same problem (no update).

    And then i tried duplicate the Sign In form, Clone of Sign In form and integrate with my original google account. It worked.

    Look like the Sign In form might have problem.

    Please advise.

     

  • Profile Image
    Welvin
    Answered on February 23, 2017 at 07:32 AM

    I have just manually forwarded the submissions to the integrated sheet. The success message appears which means that the integration is still working. Please monitor the form and the sheet and let us know if the issue persists. We can submit this to our developers if it's doing the same problem.

    Please note that sometimes, it's not a problem to our end but to Google Spreadsheet API itself. They are constantly making updates which are causing our integration to fail in some cases. Our developers can fix it, but sometimes, re-integration is also required. We will let you know, just in case.

    Note that if you want to use the same sheet when re-integrating, you can do this through Zapier. Zapier is free to use. You'll only need to upgrade if you want additional limits.

    https://zapier.com/zapbook/zaps/1924/add-new-jotform-submissions-to-a-google-sheets-spreadsheet/ 

  • Profile Image
    nuparadygm
    Answered on February 23, 2017 at 08:06 AM

    The issue still persists after i re-integrated the form with google sheet.

  • Profile Image
    Welvin
    Answered on February 23, 2017 at 09:17 AM

    Actually, I'm not suggesting you to redo the integration. But thank you for doing that. Would you mind sharing us the spreadsheet URL? You can just make it as a read only for us. We need to have the sheet so our developers can do their own test, to verify that the integration is no longer working.

  • Profile Image
    splintor
    Answered on February 23, 2017 at 02:52 PM

    We encounter the same problem. Sheets integration used to work, and stopped recently - new submissions are no longer added to our sheet.
  • Profile Image
    splintor
    Answered on February 23, 2017 at 02:54 PM

    (also, the support form won't let us send a question. When submitting, it says:
    Error Message

    Spam check has failed..

     

    )

  • Profile Image
    BDAVID
    Answered on February 23, 2017 at 05:10 PM

    @splintor, your question will be addressed on the following thread: https://www.jotform.com/answers/1074758 

  • Profile Image
    nuparadygm
    Answered on February 23, 2017 at 06:26 PM
  • Profile Image
    nuparadygm
    Answered on February 23, 2017 at 06:31 PM

    I have another similar form which working fine, https://form.jotform.me/53100701860442

    And its spreadsheet url is https://docs.google.com/spreadsheets/d/1rfVj_NIbLo54kJrb40KPVX3ZPr18INzELWEipBAQBKg/edit?usp=sharing

     

    You may take a look.

  • Profile Image
    BDAVID
    Answered on February 23, 2017 at 08:55 PM

    Thanks for sharing, I have cloned your form, but the issue did not reproduced, it updated the new entry intermediately to my integrated spreadsheet. I have forward this to our back-end team to get further help. You will be notified via this thread about any updates. 

  • Profile Image
    Denis
    Answered on February 24, 2017 at 03:33 AM

    Hello,

    Sorry for the trouble caused to you. Problem should be fixed now. I've sent missing data into your spreadsheet. Please test it and let us know if issue still persists. 

     

    Regards.

  • Profile Image
    nuparadygm
    Answered on February 24, 2017 at 07:05 AM

    It is working now. Can Jotform provides a permanent solution for this issue? This issue occurred three times already. Thanks

  • Profile Image
    Welvin
    Answered on February 24, 2017 at 09:00 AM

    Our backend team are doing their best to fix the problem permanently. However, as I've mentioned, it is sometimes not to our end but to Google Spreadsheet itself. If the problem happens again, make sure to let us know and please don't re-integrate until we advise you to do so.