Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Google Sheets Connector V3.0 401 Unauthorized authentication error

miteshnarottam
Alteryx
Alteryx
Created

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

No ratings