Google Sheets Input Error Message

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

Developer

Developer Tools

Error Message

Accepted answers

Rhys_Cooper

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.

All comments

Rhys_Cooper

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703