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 doc integration - can't create spreadsheet, no key is created

    Asked by eileenjst on March 12, 2015 at 01:36 PM

    I have been struggling to get my form integrated with google doc. So, I made a new form with only a name field to see if I could integrate a very basic form.

    I get an error when integrating, but then when returning, I get that it is integrated.

    When I use the link in the integration, it goes to my google spreadsheets area, but the spreadsheet or folder is not there.

    I noted that the link seems to be missing something -- It is in this format but the key= doesn't have anything after the '='

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

    What am I missing?

     

    This is my test form:

     

    http://form.jotformpro.com/form/50705350360950

     

    I can send my real form privately if that helps.

    find integrated doc new form name format test form
  • Profile Image
    JotForm Support

    Answered by david on March 12, 2015 at 03:09 PM

    Hi,

    If you are getting an error while setting up the integration, it may not be completing.  May I ask what the error is and at what point does it occur in the integration process?  At the end of the integration it will provide you with a direct link to the sheet:

    I am guessing that the authentication may be failing.  In any case, here is our guide on integrating your form with a Google Spreadsheet:

    https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    If you have something blocking the popup for the authentication, that may also be causing the error.

    I checked my test form to make sure it was still working and as far as I can tell, it indeed is working as expected.

    Try the integration once again, make sure each step in the process completes and let us know where it fails if it does.

  • Profile Image

    Answered by eileenjst on March 12, 2015 at 03:24 PM

    The integration is showing as integrated, but the link to view the integration and the actual file in google docs is not formed.

     

    Here is the link I am getting:

     

  • Profile Image
    JotForm Support

    Answered by Welvin on March 12, 2015 at 04:36 PM

    In that case, you should re-integrate the form to Google Spreadsheet.

    Click "Remove Integration" button to remove the integration then do the steps from this guide to re-integrate:

    http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet 

    Thanks

  • Profile Image

    Answered by eileenjst on March 12, 2015 at 04:53 PM

    I have removed and reintegrated this and one other form I have probably about 10 times, with the same result.

  • Profile Image
    JotForm Support

    Answered by Welvin on March 12, 2015 at 05:21 PM

    We can submit this thread to our developers, but can you try it again in the current form? Let's see if the integration fails again. So far, I cannot replicate it here. I've tried it to the clone version of your form:

    Form: http://form.jotformpro.com/form/50706828204958? 

    Spreadsheet: https://docs.google.com/spreadsheets/d/1jhjib8fo9NPekHLd2jx3eAUYSIsSJNhXOcjOEhWK66k/edit?usp=sharing 

    Thanks

  • Profile Image

    Answered by Eileen on March 13, 2015 at 10:05 AM

    Tried again, one last time. Still showing that the integration is ready, but link is not taking me to a excel sheet.  Folder and sheet are not in google drive.

  • Profile Image

    Answered by ekandetzki on March 13, 2015 at 10:22 AM

    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:32 PM

    @Eileen

    I checked your form and I can see that the spreadsheet link is broken indeed. 


    I cloned your form and I too was not able to replicate this issue. 

    Here is my test form:
    http://form.jotformpro.com/form/50715276356963 

    Here is my Google Sheet:
    https://docs.google.com/spreadsheet/ccc?key=1lZ7S9VfRhsNcCDoOakiJvBt6bQVdT2gw7OtPAVmcBbA 

    It was observed that Google might have had some issue which must have interfered with the integration earlier. Can you try this once more to see if the outcome is the same. We will await your response.

    @ekandetzki
    I had your post transferred to a different thread where it will be addressed separately. You can view it here: https://www.jotform.com/answers/532686 

    Regards

  • Profile Image

    Answered by eileenjst on March 13, 2015 at 12:58 PM

    Tried it once more -- still getting the broken link  and no form in my google drive.

     

  • Profile Image
    JotForm Support

    Answered by david on March 13, 2015 at 02:09 PM

    Though we are unable to reproduce the issue, I have forwarded this to our development team to have a look.  Our apologies for having you try to re-integrate your form with Drive several times, we just wanted to make sure that there wasn't something we were missing. 

    We will let you know here as soon as we have any further information regarding this, thank you very much for your patience.

  • Profile Image

    Answered by linfoxt on March 13, 2015 at 10:04 PM
  • Profile Image
    JotForm Support

    Answered by Jan on March 14, 2015 at 03:26 AM

    Hi linfoxt, 

    Your message is blank. Please create your own thread so that we can assist you properly. 

    Thank you for understanding.

  • Profile Image

    Answered by linfoxt on March 14, 2015 at 04:27 AM

    Sorry mate,

    But I didn't post it.

     

  • Profile Image

    Answered by eileenjst on March 14, 2015 at 08:56 AM

    Someone posted that the problem may be that I am on Google Apps. Yes, I am on GoogleApps.

    I will have our administrator enable GoogleDrive API and let you know what happens.

  • Profile Image

    Answered by raul on March 14, 2015 at 03:20 PM

    Thank you for letting us know.

    Please, let us know how it goes.
    Thank you.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on March 14, 2015 at 03:39 PM

    Hello,

    This is most true, Google has recently updated its user policy and now Drive API must be enabled for all Google App accounts to be able to use Google Drive and Spreadsheet integrations.

    We will be working on handling those changes.

    Kind regards,

    Alp

  • Profile Image

    Answered by eileenjst on March 18, 2015 at 10:56 AM

    Yes, our google admin used this document:

    https://support.google.com/a/answer/4530135

     

    and made the changes.  The integration now works!

  • Profile Image
    JotForm Support

    Answered by david on March 18, 2015 at 12:02 PM

    Thank you for providing that information.  This should help other users who run into the same problem and save them from the same frustration you had.  Let us know if there is anything else we can help you with and we will be happy to do so.