Google Spreadsheet: integration not working.

  • Profile Image
    splintor
    Asked on February 23, 2017 at 05:06 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
    BDAVID
    Answered on February 23, 2017 at 05:13 PM

    What is the form where the Google Spreadsheet integration stopped working? Please try removing the integration, and integrating back again. Let us know if you need more help.

  • Profile Image
    splintor
    Answered on February 23, 2017 at 06:09 PM

    It simply doesn't add new lines when users submit. It is added to the submissions list, but not to the Google sheets.

    I tryed removing the integration and re-adding it. It created a new sheet with all existing submissions, but still, new submissions are not added.

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

    So, you have already tried removing and integrating back again, and still new submissions are not forwarded to the spreadsheet, then please let us know what the form is, so we can forward this to our back-end team.

  • Profile Image
    splintor
    Answered on February 23, 2017 at 10:43 PM

    The form is https://form.jotform.me/70252655878466

  • Profile Image
    ashwin_d
    Answered on February 24, 2017 at 03:26 AM

    Hello splintor,

    I'm sorry for the trouble caused to you. 

    I have manually tried to push submissions to your integrated google spreadsheet from backend. Can you please check your google spreadsheet and see if the missing submissions are added there?

    Did you make any changes in the header column of your integrated google spreadsheet? Please note that editing column header will cause the integrated to break. I would suggest you to please re-integrate your form again with google spreadsheet and see if that solves your problem.

    Thank you!

  • Profile Image
    splintor
    Answered on February 25, 2017 at 06:07 PM

    It seems to be working fine now.

    Thanks,

    splintor

  • Profile Image
    splintor
    Answered on February 28, 2017 at 05:20 PM

    Well, the problem happened again last night. For about 12 hours, new submissions were not updates in our Google sheet, and then, at 11AM, they started to be added again.

    Can you check?

    The form is https://www.jotform.com/build/70252655878466

    What can I do now? How do I add the missing lines to the sheet?

  • Profile Image
    Ian
    Answered on February 28, 2017 at 10:03 PM

    The issue should be resolved now and it was related to Amazon S3 outage, which not only affected us, but lots of others online services.

    The issue has been resolved.

    To add the missing data, please try reintegrating the google sheet again.

     

    Let us know if you still face any issue.