0 ×

Google Sheets Interactive Service Provider

DeprecatedKNIME Google API Nodes version 4.3.0.v202011261638 by KNIME AG, Zurich, Switzerland

This node creates a Google Sheets connection using interactive authentication, via pop-up.

Authentication happens in the configuration window. By default, credentials are stored in the node. Custom credentials can be set in the configuration window. A custom credential location is useful for sharing the credentials via a KNIME server or for exposing the user credentials.

After choosing the credential location, one must authenticate using the (Re-)Authentication button. A pop-up will appear that asks the user to grant access to Google Sheets and Google Drive. If you have already authenticated, the (Re-)Authentication will test the stored credentials in the selected location. When choosing and confirming the custom credentials, the default credentials will be deleted. They can be manually deleted by clicking on the "Forget Default Credentials" button.

Access can be revoked at any time by visiting myaccount.google.com/permissions

For details see: developers.google.com/analytics/resources/concepts/gaConceptsAccounts.


Credential Location
This option determines where the credentials received during authentication will be stored.

Credentials will be stored in the node instance.
Forget Default Credentials
This button removes the credentials that are stored as part of the node instance.


User ID
The user ID under which the tokens should be saved. Multiple users' credentials can be stored in the same location.
Select Directory
The directory to which the credentials should be saved.

Clicking on this button will open a dialog for authenticating with Google Services. If you are already authenticated, it will verify the stored credentials in the selected location.

Output Ports

A connection that can be used to access Google Sheets.

Best Friends (Incoming)

Best Friends (Outgoing)



To use this node in KNIME, install KNIME Google Cloud Storage Connection from the following update site:


A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.