Automate Google Sheets Input/Output Workflow on Alteryx Server Failed

Question

Good afternoon,

I created a workflow in Alteryx which load Google Sheets from G Suite into SQL Server. I used Google Sheets Input/Out Tool which can be found here: https://help.alteryx.com/current/designer/google-sheets-input-tool .I downloaded the newest version which is v2.2.0

The Alteryx workflow works perfectly on my local machine. However when I scheduled it on Alteryx Server (Alteryx Gallery) it said: Tool #7: Google API: Retrieve Access Token (138): Tool #10: Error transferring data: SSL connect error

I guess the possible reason is that Alteryx Server failed to login to my working Google account. Is there way to get this fixed? For example, developer tool? Thank you.

Va28 · Answer

Is there a resolution of the above issue?

PhilomathJ · Answer

Thanks for the fast reply. I have published my workflow to Alteryx Server 2020.1.6 into my own private gallery. From the web interface, I see my workflow in my gallery then click Run.

I get the error attached. Tool #10 & #20 are my Google Sheets Output.

Alteryx G Sheet Error 1.png

Sethmb · Answer

Hello,

When you say it is failing from the server, are you running it in gallery/scheduler? or are you running in Designer on the server? You may want to check and see if you can run it locally on the server if not. Also if you can provide a screenshot of the error that would be helpful.

Thanks!