• Resolved mstr3kyoto

    (@mstr3kyoto)


    I am trying to integrate Ninja Forms with Google Sheets, but I am encountering an authentication error. Below is the error log.

    Log created at: 2025-04-25 04:44:11
    PHP Version: 8.2.21
    Error Message:

    njfgsc_googlesheet::gsheet_get_google_account Error in fetching user info:
    {
      "error": {
        "code": 401,
        "message": "Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.",
        "errors": [
          {
            "message": "Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.",
            "domain": "global",
            "reason": "unauthorized"
          }
        ],
       ENTICATED"
      }
    }

    I would appreciate any advice on how to resolve this error. I have tried re-obtaining the authentication code and reconfiguring the plugin, but the issue persists.

    Thank you.

    • This topic was modified 7 months, 1 week ago by mstr3kyoto.
    • This topic was modified 7 months, 1 week ago by mstr3kyoto.
    • This topic was modified 7 months, 1 week ago by mstr3kyoto.
Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author Abdullah Kaludi

    (@abdullah17)

    Hello @mstr3kyoto
    Thanks for reaching out and sharing the error details — happy to help.

    This issue usually occurs if the necessary permissions weren’t granted during the initial authentication process. Here’s what you can do to resolve it:

    1. Check App Permissions in Your Google Account:
      Go to https://myaccount.google.com, navigate to Data & Privacy → Apps and Services, and look for the GSheetConnector app.
      Confirm that it has access to both Google Sheets and Google Drive.
    2. Remove and Re-Authenticate:
      If the permissions don’t appear correctly, or just to be safe, you can remove the app from that list. Then, head back to your plugin settings and re-authenticate with your Google account — making sure to grant all requested permissions.
    3. Save the Auth Code:
      After successful authentication, be sure to save the auth code in the plugin settings.
    4. Clear Old Logs:
      To make troubleshooting easier, clear the existing debug log and then try submitting the form again to see if a fresh log is generated without the same error.

    That should resolve the issue — but if it persists, feel free to send us a fresh debug log and we’ll be glad to take another look.

    Looking forward to your update!

    Best regards,
    Abdullah

    Thread Starter mstr3kyoto

    (@mstr3kyoto)

    Hello Abdullah17,

    I am using Google Workspace. In the admin console, I can navigate to API Controls > App Access Control > GSheetConnector for WC, but I cannot delete it. However, I can change the status. I have tried granting the highest level of access, “Trusted,” but the error persists. It was working fine until it suddenly stopped, so it might be due to a change in Google Workspace’s specifications. The error log shows “No errors found.” However, the message “Something wrong! Your Auth code may be wrong or expired. Please Deactivate and Do Re-Auth Code” appears. There are no specific errors on the Google Workspace side. Is there any other information you need?

    I had the same error. Plugin was working beautifully until I updated to the most recent version. Then it just stopped working. I checked the dashboard, and saw this error;

    “There has been a critical error on this website.”

    I tried re-authenticating, but when it prompts me to “Click here to Save Authentication Code”, it fails and gives this error:

    “Something wrong! Your Auth code may be wrong or expired. Please Deactivate and Do Re-Auth Code”

    I tried several times, making sure I had the right credentials loaded, and I got the same error every time.

    Then I downgraded to the previous version of the plugin (1.2.21) and everything started working again without any issues.

    This note in the changelog might give a clue. Maybe the credentials are not getting saved to databases on some setups?

    “1.2.22
    (22/04/2025)

    • Added: Moved saving of credentials to database for Auto API Integration.”

    I have same problem… is there any solution?

    As suggested I simply de and reactivated the plugin. Then it works!

    Ahmed P

    (@ahmedpothiawala)

    @ballroomdev1
    @mstr3kyoto
    Yes, I’ve noticed this issue as well. In my case, deactivating the plugin once and then reactivating it resolved the problem.

    Could you please try deactivating the plugin, then reactivating it, and proceed with the integration?

    • This reply was modified 7 months, 1 week ago by Ahmed P.
    • This reply was modified 7 months, 1 week ago by Ahmed P.
    Thread Starter mstr3kyoto

    (@mstr3kyoto)

    @ahmedpothiawala

    Oh! It indeed started working after reactivating it! Thank you!

    @ahmedpothiawala

    Yes, I can confirm here. Using the latest version of the plugin, it begins working again after I deactivate and then reactivate. I’m glad there’s a simple solution. Thank you for helping troubleshoot!

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Ninja Forms Google Sheets Integration Error: Missing Authentication Credential’ is closed to new replies.