Google Sheets Reader is not working

Detail information:


(Error message)


(But Google sheets writer is fine)

Did anybody faced same problem and how can I fix this problem? Thank you very much.

Hi @Noah01

Welcome to the KNIME community forum!

That is strange! It works like a charm for me here.

  • Did you have any spreadsheet available to read in the connected account?
  • Did you try again after the Google sheets writer node finishes writing?

Best,
Temesgen

Hi @temesgen-dadi
Thank you for reply.
Yes, I have serval available spreadsheets in my connected account. I has been rerun sheets reader after writer node finishes writing.
I have a concern. If writer node working fine,Is it assume i have full authority to connect to my google sheets(don’t need to ativate the google drive API).
Thank you.

Hi

Yes, as you can see in the Google Authentication node dialog the write permission implies read access too.

Can you reset the Google Authentication node and try again? It could be that your session expired. B

Best,
Temesgen

1 Like