What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Google Spreadsheet: integration not working.

    Asked by splintor 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
    JotForm Support

    Answered by BDAVID 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

    Answered by splintor 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
    JotForm Support

    Answered by BDAVID 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

    Answered by splintor on February 23, 2017 at 10:43 PM

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

  • Profile Image
    JotForm Support

    Answered by ashwin_d 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

    Answered by splintor on February 25, 2017 at 06:07 PM

    It seems to be working fine now.

    Thanks,

    splintor

  • Profile Image

    Answered by splintor 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

    Answered by Ian 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.