Google Spreadsheet integration is not working.

  • tehreemb
    Asked on September 22, 2014 at 3:01 PM

    I have a form with just over 500 submissions, i am trying to link the form to a Google Spreadsheet, I go through authentication and I get a "An error integration occured" message.

  • tehreemb
    Replied on September 22, 2014 at 3:19 PM

    Screenshot below of error message:

     

    Google Spreadsheet integration is not working Screenshot 20

  • David JotForm Support Manager
    Replied on September 22, 2014 at 4:10 PM

    Thank you for reporting this, I just checked the integration, and it is working fine:

    Google Spreadsheet integration is not working Screenshot 20

    It could have been a temporary glitch, please try again, and let us know if the issue persist. Try white-listing your form's cache, and in different browser, and let us know if it happens in a specific one.

  • tehreemb
    Replied on September 22, 2014 at 4:17 PM

    Hi,

     

    i have been trying for the last 5 hours, on 2 different PC's and a Mac, using Chrome, IE and Safari.

    It still isn't working, I can cloned my form, and tried again, I'm getting the same error message.

  • tehreemb
    Replied on September 22, 2014 at 4:19 PM

    Im also getting an error with the Google Drive integration, it said it was successful, but in the URL is said there is a POST error.

     

    Screenshot below:

    Google Spreadsheet integration is not working Screenshot 20

  • tehreemb
    Replied on September 22, 2014 at 4:36 PM

    The key is also missing in the URL when i go back in the spreadsheet integration:

    Google Spreadsheet integration is not working Screenshot 20

  • David JotForm Support Manager
    Replied on September 22, 2014 at 4:44 PM

    This is quite odd, I jut cloned your form and integrated it with Google Spreadsheet and it worked:

    Google Spreadsheet integration is not working Screenshot 20

    I have cleared your form's cache. Please log out of your account, clear browser's cache, log back in and try integrating it again.

    Also try cloning my version of your form, http://form.jotformpro.com/form/42646735095967?, and integrating it with Google Spreadsheet, let's see how it goes, if it does no work, we would need to forward this to level 2. Le us know what happens.

  • tehreemb
    Replied on September 23, 2014 at 8:37 AM

    Hi, thanks for investigating... 

    It is now working, although it doesnt work with my Corporate Gmail account, but works with a personal Google account.

     

    Thanks,

  • Welvin Support Team Lead
    Replied on September 23, 2014 at 9:37 AM

    That's great to know! How about creating a simple form and integrate it with your corporate account? Just to test it.

    Thank you!