Possible to maintain Google Sheets authentication indefinitely?

Hi @dbhans,

instead of OAuth, I like to would suggest you use the Google Developer Console:

  1. Create a project
  2. Create a service account within that project
  3. Create an access key as P12 or JSON
  4. Enable the Google API

A rough how to with screenshots can be found in this post:

Best, Mike
CTO @ DataNautics GmbH - Your KNIME-Experts
Contact: info@datanautics.gmbh // datanautics.gmbh // +49(0)170-325 713 9 // Linkedin
Daten Automatisierung für Finanz-, Produktion-, IT- und Marketing-Prozesse mit KNIME