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

    why isn't Google Spreadsheet integration working?

    Asked by jrittenhouse on October 03, 2013 at 09:04 AM

    I have my form integrated with Google Spreadsheet... It sent all of the submissions at the time I enabled the integration but the spreadsheet is not getting any new submissions.

     

    form: Power Up Your Marketing

    spreadsheet:

     https://docs.google.com/spreadsheet/ccc?key=0Atga8KEoqVvxdDJaWmtPVmV0a2hfRF9MVW1kaVQtZVE&usp=sharing

     

    thanks.

    Submissions style size font
  • Profile Image

    Answered by jedcadorna on October 03, 2013 at 09:40 AM

    Hi,

    We apologized for the inconvenience. Please try reintegrating google spreadsheet and let us know if this resolves the issue. I have tested the integration on my and works fine and updates my spreadsheet with the new submission. 

    Thanks,

  • Profile Image

    Answered by jrittenhouse on October 03, 2013 at 09:53 AM

    did anything change? I've already tried that twice and both times it only uploaded the submissions that were already present.

  • Profile Image

    Answered by EliezerN on October 03, 2013 at 11:04 AM

    Thanks for contacting us.

    In order to avoid this issue, make sure to not edit any row or column of the spreadsheet, otherwise that will break the integration.

    I also made a test with one of my forms, but I wasn't able to reproduce the issue:

    My form:http://www.jotform.com/form/32754156720958

    Spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AiqEPKFwsdaPdGVZTEtJTVMyZllPcVM5T0hNaDF4bVE&usp=sharing

    I also cloned your form, made the integration and sent some submissions, but I had no problems, the spreadsheet updates automatically:

    My cloned form: http://www.jotform.com/form/32753955377972

    Spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AiqEPKFwsdaPdHVYZkl0VnNCWVpMVVBHNm9aTUhtLVE&usp=sharing

    I would recommend you to clone your form and try to make the integration. Please refer this guide to know how to clone your form: http://www.jotform.com/help/42-How-to-clone-an-existing-form-from-a-URL

    If the issue still persists, don't hesitate to contact us.

    Thanks

  • Profile Image

    Answered by jrittenhouse on October 03, 2013 at 11:08 AM

    The only thing I'm changing with the spreadsheet is in the security settings to make it public to anyone who has the link. Would that effect anything with the integration?

  • Profile Image

    Answered by EliezerN on October 03, 2013 at 11:11 AM

    No, that doesn't affect the integration. Please try cloning the form and make the integration. I would also suggest you to clear your forms caches, that might help. Use this guide to learn how to do it: How to clear your form cache

    Thanks