Google doc integration - can't create spreadsheet, no key is created

  • Profile Image
    eileenjst
    Asked 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.

  • Profile Image
    david
    Answered 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
    eileenjst
    Answered 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
    Welvin
    Answered 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
    eileenjst
    Answered 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
    Welvin
    Answered 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
    Eileen
    Answered 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
    ekandetzki
    Answered 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
    Sean
    Answered 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
    eileenjst
    Answered 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
    david
    Answered 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
    linfoxt
    Answered on March 13, 2015 at 10:04 PM
  • Profile Image
    Jan
    Answered 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
    linfoxt
    Answered on March 14, 2015 at 04:27 AM

    Sorry mate,

    But I didn't post it.

     

  • Profile Image
    eileenjst
    Answered 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
    raul
    Answered 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
    alp_deniz
    Answered 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
    eileenjst
    Answered 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
    david
    Answered 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.