Why Google spreadsheet integration is not working?

  • mattaja18
    Asked on June 30, 2017 at 9:03 AM

    Hello,

    I tried to implement Google Docs integration on this form but it doesn't seem to work? When I click on the link, I get an error from Google Drive.

    Thanks,

     

    Matt

    Jotform Thread 1188345 Screenshot
  • Nik_C
    Replied on June 30, 2017 at 11:35 AM

    I checked your Google Spreadsheet integration and the link there doesn't look good:

    Why Google spreadsheet integration is not working? Image 1 Screenshot 30

    The key is missing and it should look like this:

    Why Google spreadsheet integration is not working? Image 2 Screenshot 41

    Did you try to re-integrate your form?

    Please be mindful that new sheet will be created. I'm not sure if this was new integration or the existing one?

    We'll wait for your response.

    Thank you!

  • mattaja18
    Replied on June 30, 2017 at 11:40 AM

    Hi Nik,

    I removed the integration and then tried it again - it didn't work. I'm happy for a new sheet to be created.

    Could you test the integration from your side?

    Thanks,

    Matt

  • Nik_C
    Replied on June 30, 2017 at 12:54 PM

    I tested on my end and it worked. The above link I showed is from the newly created integration.

    Let's try this please:

    1) Open your JotForm account in Incognito mode in Browser or in some other Browser and Edit your form,

    Why Google spreadsheet integration is not working? Image 1 Screenshot 20

    2) Remove the integration if exists and integrate again. It should ask you to login to your Google account, do that and finish the integration.

    This guide might help as well: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    If it doesn't work, please let us know.

    Thank you!

  • mattaja18
    Replied on July 3, 2017 at 8:38 AM

    Hi,

    Unfortunately, this didn't work either.

    I followed the integration process in the link you sent. It's the final step that doesn't work: there is no key generated after ccc?key=

    Matt

  • Kiran Support Team Lead
    Replied on July 3, 2017 at 11:02 AM

    I see that the form is associated with a different account 'PearsonUK-forms' and it seems that you are a sub-account user of this account. I'm not sure if it is causing the issue. Please try switching the Datacenter option in the Data section of your account and then try integrating Google spreadsheet to the form in the shared account.

    Could you try integrating Google Spreadsheet on one of the forms in your account to see if that works? Please get back to us with the results so that we can assist you further.

  • Kiran Support Team Lead
    Replied on July 3, 2017 at 11:03 AM

    You may switch the Datacenter option from the following URL.

    https://www.jotform.com/myaccount/data

    This is due to that your account and the shared account should be using the same server to work properly.