Possible to maintain Google Sheets authentication indefinitely?

[dbhans]

I’d like to export the results of a scheduled workflow deployment to Google Sheets; however, the Google Authenticator seems to time out after a short time. Is there a way for the credentials to remain valid for many runs scheduled well in advance?

Note that I’ve authenticated using a “service account” specified through a json file uploaded to our KNIME Community Hub.

[mwiegand]

Hi @dbhans,

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

Google Cloud Platform

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:

Google Authenticator API Key json format/layout/requirements

Hi @ebarr, did you really generate the JOSN in the Google Dev Console by creating a project? That process, because of the UI from Google, is rather confusing. Once you have created a project, you need to create a service account from within you can create a key as a p12 or JSON file. [image] Best Mike

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