Google Sheets Node not working

Google Sheets Reader not working. Giving error “Could not retrieve spreadsheets. Check connection”
Earlier the Google Authentication used to work, now it show error " Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In."
Currently using API Key. First two nodes “Google Authentication (API Key)” and “Google Sheet Connection” runs well, the “Google Sheets Reader” throws above error. Scope added are “https://www.googleapis.com/auth/spreadsheets” and “https://www.googleapis.com/auth/drive

1 Like

Hi there @ranjit1024,

welcome to KNIME Community!

Check these topics for more info:



Br,
Ivan

1 Like

Hello, hope i can help. I don’t see any mention of “service account” and access.

Did you give the service account access to the spreadsheet as a reader/viewer/etc’s?

Best,
T

PS. you will want to build out the API KEY tool and build the service account as an access point, this will offer you means of utilizing the google sheets tools again. Once completed, you will be able to use your knime app again

1 Like