Google sheets input tool - Connected to show sheets but the next button doesnt do/change

Hello,

I am using the google sheets input tool and I am able to connect and preview all the sheets in my google drive, however when selecting a sheet and clicking the next button, it doesn't do/change anything however the below error appears.

Hope somebody can help.

Thanks

Google Sheets Input (1) Google API: Retrieve Access Token (138): Google API: HTTP/1.1 400 Bad Request ¶Cache-Control: no-cache, no-store, max-age=0, must-revalidate ¶Expires: Mon, 01 Jan 1990 00:00:00 GMT ¶Date: Wed, 12 May 2021 11:43:13 GMT ¶Pragma: no-cache
Google Sheets Input (1) Google API: Retrieve Access Token (138): Tool #14: Parse Error at char(1): Unknown variable "token_type" (Expression #1)

API

Accepted answers

TheOC

hey @Lucyxbite

I'm not massively familiar with google sheets, but as far as I understand of the tool, you have two login options, user login and Developer.

If you are using User-Login, I believe the token expires after 60 minutes. You may need to logout, and logback in to that tool (in the bottom left of the configuration window). If you are using Developer, then ensure the google sheets is enabled here:
https://console.cloud.google.com/marketplace/product/google/sheets.googleapis.com?q=search&referrer=search&project=chromelocking

Let me know if this helps 😀!
TheOC

All comments

TheOC

Shifty

Hey @Lucyxbite,

Did you manage to get this sorted?

Shifty

Lucyxbite

Brilliant! It did everything I needed! Thanks @TheOC

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703