Issue with Google Sheets Authentication from Gallery

[csh8428]

DISCLAIMER: I already posted this in the Server sub, but haven't gotten any traction. So, I figured I'd try here as well.

I am an admin for both the Alteryx Gallery AND the physical server that the Gallery sits on. I can run workflows that have google sheets connectors from the Gallery because I can create and run the workflows in Designer desktop on the physical server to go through the google authentication process.

The issue we are running into is with our other non-server admins. They can create and run workflows with google sheets connectors from their local desktop Designer; however, they cannot run those workflows from the Gallery because they cannot go through the authentication process because they are not admins on the Gallery server.

I know this is not an “Alteryx” issue, but a server related one. Does anybody know of a workaround or a way to “transfer” whatever the google authentication process produces from a user’s local desktop to the server that houses the Gallery so that any user can run a workflow from the gallery that has google sheets connectors in it?

[fpinchon]

You need to use OAuth 2.0 for Server to Server Applications as described here:
https://developers.google.com/identity/protocols/oauth2/service-account 

No more browser involved...

I built a quick & dirty workflow for Google Analytics which can be easily tweaked to accommodate Google Sheet:

http://insightsthroughdata.com/connect-to-google-analytics-4-ga4-and-extract-with-alteryx/

Skip to the 'Authentication using a Service Account' part...

[apathetichell]

@fpinchonyour way uses a service account and authenticates via 2 legged oauth. This post had to do with swapping from 3 legged oauth (discussed in the link you included) to 2 legged oauth - or (ideally) how to implement 3 legged oauth on server when no service account/JWT token exists.

[fpinchon]

OK so let me rephrase: in the question asked by @csh8428 , Service Account is not acceptable, and the desired solution would still require the user to click in the browser on the Accept button?