Can't authorise Google Sheets

When I try to authorise Google Sheets I get this error. Google sheets connects successfully with other apps. On Google’s side it all looks fine.

Hey @julian - Seems like your org might be blocking access. Could you try the following please:

  1. Sign in to the Google Admin console (admin.google.com) as an administrator Link.
  2. Navigate to Security > API Controls Link.
  3. Review the “Block All Third-Party API Access” setting. If it’s enabled, this could be blocking the app Link.
  4. Click on “Manage Third-Party App Access” to view a list of apps with access to Google Workspace data1.
  5. Look for Gumloop in the list. Note its status (trusted, limited, or blocked) Link.
  6. If it is not listed or is blocked, hover over the app name and select “Change Access” Link.
  7. Choose the appropriate access level.
  8. If necessary, review individual user access to Gumloop:
  • Go to the list of users in the Admin console
  • Click on a user’s name
  • Check the “Security” section for “Connected Applications” Link
  1. Ensure that the necessary Google Workspace APIs are enabled for your app in the Google Cloud Console

I don’t have an org: it’s a personal account :thinking:

Interesting. Looping @rahul-gumloop here ^

Hey @julian can you try going to this page and linking the Sheets and Drive credentials from there?

https://gumloop.com/credentials

Ok did all that and now I get a different error.

Can you try deleting the node and re-adding it again?

That’s what I did.

Can you send a link to your automation?

This topic was automatically closed 4 days after the last reply. New replies are no longer allowed.