Google Sheets Input Error Message

[oasare]

My workflows involving Google Sheet input are now all failing.  I get the following error message below.  On all Google Sheets, I have edit access. I've log out, signed back in and received a new connection token but still receive the same error. 

Error: Google Sheets Input (1): Google Sheets Input: HTTP/1.1 401 Unauthorized
WWW-Authenticate: Bearer realm="https://accounts.google.com/", error="invalid_token"
Vary: Origin
Vary: X-Origin
Vary: Referer

[Rhys_Cooper · Accepted solution]

Hi @oasare. One thing I would check is the field type of the one that contains access token has its size set large enough such that the token isnt being truncated.

[apathetichell]

how are you authing to google sheets --- this is a pretty straight forward google api response --- your token is expired and you need to go back through oauth. Assuming you are using user oauth ---> create a new canvas ---> drag a new google sheets/google drive tool onto canvas. go back through google oauth. confirm it works. return to original workflow.

If this does not work it points to issues which may be personal or enterprise relating to google workspace security policies.

[oasare]

@Rhys_Cooper

Had to access the Google Sheet Input macro (GoogleAPI.Retrieve_Access_Token.yxmc) found in the GoogleSheetsInput.yxmc macro for the Google Sheets Input tool. Once there, updated the size of the Authorization field. Workflow(s) run perfectly now. Thank you pointing me in this direction.

[jelrod1]

I began experiencing this same issue this morning. Can you help with guiding me to where the "Authorization field" is within the Access token macro? 

[oasare]

Good morning,

These are the steps I took to resolve my issue.

In the Google API: Retrieve Access Token, click on the formula tool and update the V_WString size to 2147483647.

Run the macro. If you get an error, disregard and save.

Close the macro.

You'll get the following pop-up in the GoogleSheetsInput.yxmc macro.

Click OK.

Close the macro.

This should update for all workflows with a Google Sheet Input tool.

If you're having the same issue with the Google Sheet Output tool, you will need to repeat the exercise for that tool.

Hope this works out for you.