Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.
3/24/2023: We are aware of the missing content issue and are currently looking into the matter. We appreciate your patience as we get this resolved.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Google Sheets Connector V3.0 401 Unauthorized authentication error



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


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. 


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).

5 - Atom

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

5 - Atom

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.

8 - Asteroid

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