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 Sheets integration not creating spreadsheet

    Asked by cocharlotte on January 09, 2017 at 02:37 PM

    I am attempting to perform a Google Sheets integration, but no spreadsheet is generated despite receiving a message that the integration is successful. I have tried integrating this form with two different Google accounts  but I get the same result.

    Thank you.

    Page URL:
    https://form.jotform.com/63394004811955

    Screenshot
  • Profile Image
    JotForm Support

    Answered by BJoanna on January 09, 2017 at 05:10 PM

    I have checked mentioned form on your account and I was able to see that form is integrated with Spreadsheet and the key is missing. 

    However I was not able to replicate same issue on my cloned form. I have successfully integrated my cloned form with Google Spreadsheet.

     

    Please try to reintegrate your form again. 

    1. Removed the integration in your form.

    2. Clear the Form cache.

    3. Log out from JotForm.

    4. Close and reopen the browser.

    5. Log in to JotForm.

    6. Reintegrate the Google Spreadsheet.

    You can also try to use some other browser.

    Hope this will help. Let us know if you need further assistance. 

  • Profile Image

    Answered by cocharlotte on January 10, 2017 at 09:39 AM

    Thank you, unfortunately still no luck.  I did everything you said and tried from two different browsers, Chrome and IE.  Any other suggestions?

  • Profile Image
    JotForm Support

    Answered by Kiran on January 10, 2017 at 11:39 AM

    I have also tried integrating Google spreadsheet with one of my test forms and was able to integrate without any issue. I have tried integrating Spreadsheet using v4 builder to see if I can replicate the issue, but I was not able to. 

    I have checked your JotForm and seems that the Google spreadhseet integration is removed. Could you try logging out from all the Google accounts that are already signed in on your browser and then try integrating Google spreadsheet from JotForm. You should be prompted to signin to Google account during the integration.

     

    Let us know how it goes. We will be happy to assist you further. 

  • Profile Image

    Answered by cocharlotte on January 10, 2017 at 12:07 PM

    Still unsuccessful. I did exactly as you said and still no spreadsheet key is generated. It says the authentication is successful in each case, but then doesn't generate a spreadsheet.  I tried with multiple Google accounts.

    It also seems that this issue is not unique to this particular form.  I just attempted a Google spreadsheet integration with another form and got the exact same result.

  • Profile Image
    JotForm Support

    Answered by Mike on January 10, 2017 at 01:34 PM

    Could you please try to change main and sub folder names during the integration to see if that makes any difference?

    Please also confirm if you use https://www.jotform.com/ or some other domain to access the JotForm builder.

  • Profile Image

    Answered by cocharlotte on January 11, 2017 at 08:36 AM

    Not sure if it was one or both, but after changing the folder and spreadsheet name it worked.

    Once the spreadsheet is made, can I move it within my Drive without affecting its functionality, or does it have to remain in the folder in which it was originally created?

  • Profile Image
    JotForm Support

    Answered by Kevin_G on January 11, 2017 at 10:44 AM

    Yes, you can indeed move the spreadsheet to a different folder and it will still receive the submissions. I have also tested this on my end, moving the spreadsheet from a folder to the main one and it worked fine.