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 Sheet Integration: Unable to locate folder and spreadsheet after successful integration

    Asked by ekandetzki on March 13, 2015 at 12:22 PM
    I am having this same problem. It says the form is integrated with Google Sheets, but I can't find the spreadsheet. I've tried it a million times over and over and it is not working.
  • Profile Image

    Answered by Sean on March 13, 2015 at 12:37 PM

    Can you state which of the forms you are having this issue with so that we can do some checks?

    You should also try to re-integrating the form with Google Sheet now to see if the issue remains. It was noted that Google had some issues error which code have cause this problem. Do let us know how it goes.

    Regards

  • Profile Image

    Answered by ekandetzki on March 13, 2015 at 12:44 PM

    Darn, it's just still not working. I saw that Google was having some trouble earlier, but I just tried to integrate again and it says it's integrated, but the spreadsheet is not there and neither is the folder.  It's a cloned form; I wonder if that has anything to do with it?

  • Profile Image

    Answered by Sean on March 13, 2015 at 03:25 PM

    Is it this form http://www.jotform.us/form/50705575012145 you are having the issue with?

    I can see that the spreadsheet URL was not broken:


    I was trying to access the spreadsheet but I can see that it is not open to the public.

    https://docs.google.com/spreadsheet/ccc?key=1LuVSTQair7GpAaijgPGhY5bTJ5iZt0PTbHsZR5Du714 

    Can you click the link above and tell me if you receive an error message or could you indicate what happens after clicking the link. 

    Using a cloned form shouldn't cause this issue. I tested the integration with a cloned version of your form and I am still not able to replicate the issue.

    Here is my cloned version of the form:
    http://form.jotformpro.com/form/50715974777975 

    Here is my sheet:
    https://docs.google.com/spreadsheet/ccc?key=1g8SBc0Mo0rgmrQcq1_6AUpQnhGb5bYlLYYljLskrtuw 

    Is the above mentioned form the only one with the issue? I will pass this information on to our development team so that they can do some checks. Please let us know if anything changes.

  • Profile Image

    Answered by ekandetzki on March 13, 2015 at 03:31 PM

    I can get to the spreadsheet using your link. I tried integrating it again, and I can get to it with the link. It just isn't showing up in my Google Drive. 

     

    I am renaming the spreadsheet and the folder it goes into. I don't know if that's the problem. I also tried it without renaming the folder and that didn't work either.

  • Profile Image

    Answered by Sean on March 13, 2015 at 04:57 PM

    I checked my Google Docs account and I was able to locate both the folder and file for my integrated sheet.

    I am not sure why this is happening in your account but I have passed this information on to our higher ups so that they can look into it. As soon as an update is available you will be notified via this thread.



  • Profile Image
    JotForm Support

    Answered by alp_deniz on March 14, 2015 at 05:37 PM

    Hello,

    Are you using a Google apps account for integration? If this is not the case, a recent correction may have fixed the issue. Otherwise, you may need to contact your Google App administrator to enable Drive API for your account.

    Kind regards