Google Sheets Connector V3.0 401 Unauthorized authentication error

[miteshnarottam]

Issue

Google Sheets v.3.0 is failing with a 401 Unauthorized error when uploading the workflow to the gallery or running the same workflow on another machine. The issue is related to encrypted values in the XML. 

Google API: Retrieve Access Token (138): Google API: HTTP/1.1 401 Unauthorized Date: Tue, 28 Sep 2021 11:51:07 GMT Pragma: No-cache Expires: Mon, 01 Jane 1990 00:00:00 GMT Cache-Control: no-cache, no-store, max-age=0, must-revalidate

Google API: Retrieve Access Token (138): Tool#14: Parse at char(1): Unknown variable "token_type" (Expression#1)

Environment Details

• Alteryx Designer, Server
  • Version(s) 2021.2 +
• Google Sheets
  • Version v3.0.0

Cause

This is a defect (TPM-463) This is likely due to the type of encryption used by the tool which is not carried over when running workflows on another machine. 

Resolution

This defect is still under review by our development team, in the meanwhile the workaround is to download and install the previous version of Google Sheets Tools v.2.2.0 (this can be downloaded from Community Gallery).

[PeteZeel]

@miteshnarottam has there been any progress on this.  It is creating major issues and effort related to some server migrations for us.

[Emil_Martensson]

This is laughable. It's been a year and still not resolved. Found this issue after half an hour of debugging.

So glad I'm migrating away from this product to dbt and more scalable analytics solutions. But it was a nice starting point for a noob like me.

[wildflower]

This error persists on Server 2021.3.2. The Community Gallery should be updated to link this defect so users don't implement the new tool and this line should be revised under the current tool

[niharikadiwakar]

Is there any update on the resolution? Its difficult to manage workflows with Google Sheets as we are not able to publish from dev server to prod.