# Possible to maintain Google Sheets authentication indefinitely?

**URL:** <https://forum.knime.com/t/possible-to-maintain-google-sheets-authentication-indefinitely/84603>\
**Category:** KNIME Community Hub\
**Created:** [November 13, 2024, 8:26pm UTC](https://forum.knime.com/t/possible-to-maintain-google-sheets-authentication-indefinitely/84603 "2024-11-13T20:26:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dbhans](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/b5a626/32.png) [@dbhans](https://forum.knime.com/u/dbhans)\
**Post date:** [November 13, 2024, 8:26pm UTC](https://forum.knime.com/t/possible-to-maintain-google-sheets-authentication-indefinitely/84603/1 "2024-11-13T20:26:55Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![mwiegand](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mwiegand/32/66896_2.png) [@mwiegand](https://forum.knime.com/u/mwiegand)\
**Post date:** [October 20, 2025, 8:20pm UTC](https://forum.knime.com/t/possible-to-maintain-google-sheets-authentication-indefinitely/84603/2 "2025-10-20T20:20:59Z")

</div>

Hi @dbhans,

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

> **[Google Cloud Platform](https://accounts.google.com/v3/signin/identifier?continue=https%3A%2F%2Fconsole.cloud.google.com%2Fapis%2Fdashboard&dsh=S-1878248899%3A1760991233952263&followup=https%3A%2F%2Fconsole.cloud.google.com%2Fapis%2Fdashboard&ifkv=AfYwgwWURRdQGvsYfzF3xmHt88kAk5AwvY-KAWerb_MpDzuOu5zlQ2FHbXVFJhzM8ao1sLSZ_zFG&osid=1&passive=1209600&service=cloudconsole&flowName=GlifWebSignIn&flowEntry=ServiceLogin)**
>
> Google Cloud Platform lets you build, deploy, and scale applications, websites, and services on the same infrastructure as Google.

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](https://forum.knime.com/t/google-authenticator-api-key-json-format-layout-requirements/78972/2):
>
> 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. Best Mike

Best, Mike  
_CTO @ DataNautics GmbH - Your KNIME-Experts  
Contact: [info@datanautics.gmbh](mailto:info@datanautics.gmbh) // [datanautics.gmbh](https://datanautics.gmbh/) // [+49(0)170-325 713 9](https://tel:+49(0)170-325%20713%209/) // [Linkedin](https://www.linkedin.com/company/datanautics-gmbh)  
Daten Automatisierung für Finanz-, Produktion-, IT- und Marketing-Prozesse mit KNIME_