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

    Unable to complete Google Sheet integration

    Asked by kasimmon on February 20, 2016 at 11:53 PM

    Hello,

    I've been unable to successfully connect a google spreadsheet to my JotForm.  Whenever I try, the integration appears to go through, however the URL given for the new spreadsheet is the one below:

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

    Clicking the link takes me to the general Google sheets page.

    I've tried this with two Google accounts, one using two factor authentication and another one with single factor.  

    Please advise.

     

    google google sheets google spreadsheet google integration cannot authenticate
  • Profile Image
    JotForm Support

    Answered by Jan on February 21, 2016 at 09:15 AM

    We don't have any issues integrating JotForm to Google Spreadsheet as of right now. I was able to integrate one of my form to a Spreadsheet.

    I was able to authenticate properly.

    Once authenticated, it shows the folder name and title name of the Spreadsheet.

    Once you hit the "Complete Integration" button, it will show the URL of the Google Spreadsheet.

     

    It is possible that you are currently logged in to a Google account when you tried to integrate the form. After that, you probably want to integrate with another Google account. Maybe it got mixed up. Please try the steps below:

    1. Remove the Google Spreadsheet integration. If it is integrated.
    2. Please try to logout all of you Google Accounts and JotForm as well.
    3. Log back in to JotForm.
    4. Go to your form and try to re-integrate it again. Please make sure you are entering the correct credentials.

    If it is still the same, I would advise you to check if it will work on another browser. I will clear your form cache so that your forms will be refreshed from our servers. 

    Let us know if you're still having issues. Thank you.

  • Profile Image

    Answered by kasimmon on February 24, 2016 at 04:58 PM

    This worked, thank you!  It must have either been an account mix up on my end of an issue with the server form cache.