Publishing workflow with Google sheet input from designer on Gallery throws an error

Question

Hi There

I am trying to publish a workflow from designer on my local machine to gallery but it throws the following error: The job Google sheets input test 6 did not complete successfully and resulted in the following errors:

* Google API: Retrieve Access Token (138): Google API: HTTP/1.1 401 Unauthorized Pragma: no-cache Date: Thu, 20 Jan 2022 13:00:12 GMT Cache-Control: no-cache, no-store, max-age=0, must-revalidate Expires: Mon, 01 Jan 1990 00:00:00 GMT (Tool Id: 1)
* Google API: Retrieve Access Token (138): Tool #14: Parse Error at char(1): Unknown variable "token_type" (Expression #1) (Tool Id: 1)

I am using developer login for accessing google sheets and the workflow runs fine on my local machine. I also tried to run it on the designer on server machine with my developer credentials it runs fine but issue comes when publishing this flow to gallery from my local machine .

thanks

WalzbergD · Answer

Hey there,

I'm also looking to solve this issue.

dcraft · Answer

Any solutions out there? I am running into this in my org as well.

fillip-andreasen · Answer

Hi,

Was this solved somehow? I am running into this error on all workflows connecting to a google sheet...