Gsheet Input Tool Authentication Failure on Server

emilyforeman — Fri, 24 Sep 2021 13:54:03 GMT

Hi all,

I am trying to run a workflow in my gallery that uses the native GSheet input connector.. However when I run the workflow in gallery it looks like it is unable to authenticate-- I have tried both the O2Auth and User Credentials method.

Anyone experience this or have suggestions to alleviate this blocker? Hopefully I'm missing something simple. I'm looking into the CData ODBC connector as a alternate solution; however it would be great if the native Alteryx tool would work on gallery.

Re: Gsheet Input Tool Authentication Failure on Server

fmvizcaino — Thu, 07 Oct 2021 16:34:08 GMT

Hey @emilyforeman ,

When authenticating, I think the google sheets tool create a file with the logging information and that is not sent with the workflow together, one workaround is for you to publish the workflow using the alteryx designer inside the server machine.

Best,

Fernando Vizcaino

topic Gsheet Input Tool Authentication Failure on Server in Alteryx Server Discussions

Gsheet Input Tool Authentication Failure on Server

Re: Gsheet Input Tool Authentication Failure on Server