Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Issue with Google Sheets Authentication from Gallery

csh8428
11 - Bolide

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?

1 REPLY 1
fpinchon
8 - Asteroid

How about using 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...

 

Cheers,

Frederic