Google Sheets Node not working

[ranjit1024]

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”

[ipazin]

Hi there @ranjit1024,

welcome to KNIME Community!

Check these topics for more info:

Need Help Connecting Google Sheets Reader Node

Hi All, I am trying to connect to Google Sheets using the Google Authentication (API Key) + Google Sheets Connection + Google Sheets Reader nodes as shown below. I have also created a service account and enabled Google Sheets API, but still get the error: “Could not retrieve spreadsheets. Check connection.” [image] I have set up the Google Authentication (API Key), and enabled the appropriate scopes: [image] I created a services account and P12 key, but no OAuth as indicated in the node…

Google Authentification Error

[Capturar] [Capturar2] Hi, When authenticating with Google Accounts I am receiving the following error. This started to happen after I upgraded my Knime version to the 4.1. Thanks in advance for any help provided

KNIME Google Authentication API Key Walkthrough

Hello, noticing there’s a few threads on KNIME community that are related to KNIME Google Authentication node leading to an 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… So i tested it and… [38%20PM] After reading a ton of community threads, I realized I needed to begin using the API Key node, and I need to be able to repeat the setup on my computer, as-well as client computers… Will admit, I g…

Br,
Ivan

[Tyler]

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