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 error

    Asked by NAUScreative on December 03, 2013 at 08:52 PM

    I have been attempting to integrate my for with Google spreadsheet for the past few days however I keep getting the same message - 'An error occurred during integration' after it ticks over for about a minute.

    Strangely enough, the form does go to google, however the data does not update.

    I have followed all of the steps outlined on the forum for similar problems - eg. Remove integration, log out, clear cache, start over...etc.... to no avail.

    I have also tried using multiple browsers on both PC and Mac.

    Please help!

  • Profile Image
    JotForm Support

    Answered by ashwin_d on December 04, 2013 at 07:30 AM

    Hello NAUScreative,

    I'm sorry for the trouble caused to you.

    I cloned your form in my account and I was able to integrate it with google spreadsheet successfully. I sent few test submissions and it was saved to the integrated google spreadsheet almost instantly.

    This is the cloned version of your form:  http://form.jotformpro.com/form/33372588525967?

    This is the integrated google spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0Ap67emeXZNrndDRxZlVlYUgzMExBbnRFWWh2Wm41YlE&usp=sharing

    Have you edited any of the header columns of your google spreadsheet? Please be informed that editing the header columns will break the integration. 

    I would suggest you to please delete the current google spreadsheet integration from your form, clear your browser cache and re-integrate with google spreadsheet. This guide should help you clear your browser cache:  http://www.wikihow.com/Clear-Your-Browser's-Cache

    Feel free to clone this form and see if you are able to integrate it with google spreadsheet and submission data is synced correctly. This guide should help you in form cloning:  http://www.jotform.com/help/42-How-to-clone-an-existing-form-from-a-URL

    Do get back to is if the issue persists.

    Thank you!

  • Profile Image

    Answered by NAUScreative on December 04, 2013 at 06:58 PM

    Thanks, this now seems to be working.

    Will the integration still work if I 'hide' any columns?

  • Profile Image
    JotForm Founder

    Answered by aytekin on December 05, 2013 at 05:00 AM

    Yes, the integrations will not be affected by hidden fields.