Google Sheets Interactive Service Provider

This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.
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

For details see:


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.

Input Ports

This node has no input ports

Output Ports

A connection that can be used to access Google Sheets.


This node has no views




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.