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

    Not all data synchronizing with Google Spreadsheet

    Asked by NAUScreative on March 16, 2014 at 09:33 PM

    I have integrated my form with Google Spreadsheet, however a large chunk of data is missing.

    All submissions between Jan 13, 2014 and March 13, 2014 (329 entries) do not appear.

    Any ideas?

    all Submissions integrated all submissions
  • Profile Image
    JotForm Support

    Answered by ashwin_d on March 17, 2014 at 05:13 AM

    Hello NAUScreative,

    I'm sorry for the trouble caused to you.

    Have you manually done any changes in your integrated google spreadsheet? The integration should not break until the columns of the google spreadsheets are changed.

    I would suggest you to please remove the current integration and add it again. That should add all the missing submissions in the new google spreadsheet. Do get back to us if the new submissions records are not getting saved to the google spreadsheet and we will take a look.

    Thank you!

  • Profile Image

    Answered by NAUScreative on March 19, 2014 at 06:53 PM

    I have removed all integrations and set it up again from scratch however I keep getting the same problem. All submissions numberd from NA14_2031 to NA14_2394 (363 entries) are missing.

    I have followed this process multiple times and keep gettng the same result.

    When I export data as a report from Jotform, all of it comes through.

  • Profile Image
    JotForm Support

    Answered by EltonCris on March 19, 2014 at 11:25 PM

    @NAUScreative

    Thanks and apologies for any inconveniences caused.

    Is it possible if you could share to us the current integrated spreadsheet with view permission? Would you mind if we could test your form by integrating it to spreadsheet here to find out if it does happen on our side? Once we replicate this, we'd be happy to forward this to our developers.

    It should suppose to pass all the existing submissions data to Google Spreadsheet, I wonder if there's limit imposed here since 300+ is a bit huge but hopefully this is something we can resolved here.

    We'll await your reply.

    Regards!