Invalid authentication with Google Sheet

  • Deb Rouse
    Asked on February 19, 2021 at 10:29 PM

    I have a form that will not integrate with google sheets.

    The error message I am receiving is Invalid authentication when adding my email address.

    Please assist.

    Thank you,

    Deb

  • Richie JotForm Support
    Replied on February 20, 2021 at 9:21 AM

    For testing purposes, can you please try another Google account to use to integrate with Google Sheet?

    You may also clear your browser's cache and login back to your account to edit your form.

    I have cleared your form cache.

    Let us know how it goes.

  • Deb Rouse
    Replied on February 20, 2021 at 2:11 PM
    I have used this feature before with the legacy google sheets.
    When I click use other account and select my account - it still says
    invalid authentication.
    ...
  • VincentJay
    Replied on February 20, 2021 at 8:44 PM

    Hi,

    Please share the form link so we can check it further. Is the form still integrated into the Old Google Spreadsheet?

    We'll wait for your response.

  • Deb Rouse
    Replied on February 20, 2021 at 9:11 PM
    I removed the old integration.
    Here is the link https://form.jotform.com/92303850262148
    ...
  • Mike_G JotForm Support
    Replied on February 21, 2021 at 4:56 AM

    We would like to apologize for any inconvenience.

    May I suggest that you try logging out of your JotForm account and log back in again before you set up the Google Sheets integration of the form you linked, please? You may also try setting up the integration using a different device and/or browser. The issue you are having could be a result of you not being logged-in correctly to your JotForm account.

    Please give it a try and let us know if you need any further assistance.

  • Deb Rouse
    Replied on February 21, 2021 at 9:22 PM
    I logged on and off.
    When I try to integrate - there is a different account in the dropdown list
    so I click on use another account and then I get invalid authentication.
    Authentication
    Select your Google Sheets account to create an integration.
    Select a Google Sheets account
    + Use another account
    ...
  • Richie JotForm Support
    Replied on February 22, 2021 at 2:42 AM

    It could be that your Google account password or email is incorrect.

    I have tested on my sample form and the Google sheet integration works after I selected/used another account.

    1613979700 60336034eaba9 2 Screenshot 10

    Please double check your Google Credentials and let us know how it goes.

  • Deb Rouse
    Replied on February 22, 2021 at 9:11 AM
    I have logged off from my email account and it does not work.
    There is an issue with this form. Can you try to link an account with this
    form and let me know if it works?
    ...
  • Deb Rouse
    Replied on February 22, 2021 at 9:22 AM
    I also created a brand new form and it does not work.
    ...
  • Deb Rouse
    Replied on February 22, 2021 at 9:22 AM
    I got it to work - thanks!
    ...