Google Spreadsheet: integration not working.

  • splintor
    Asked on February 23, 2017 at 5:06 PM
    We encounter the same problem. Sheets integration used to work, and stopped recently - new submissions are no longer added to our sheet.
  • David JotForm Support Manager
    Replied on February 23, 2017 at 5: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.

  • splintor
    Replied on February 23, 2017 at 6: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.

  • David JotForm Support Manager
    Replied on February 23, 2017 at 8: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.

  • splintor
    Replied on February 23, 2017 at 10:43 PM

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

  • Ashwin JotForm Support
    Replied on February 24, 2017 at 3: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!

  • splintor
    Replied on February 25, 2017 at 6:07 PM

    It seems to be working fine now.

    Thanks,

    splintor

  • splintor
    Replied on February 28, 2017 at 5: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?

  • Ian
    Replied 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.