0 ×

Google Sheets Interactive Service Provider

DeprecatedKNIME Google API Nodes version 4.0.0.v201905311239 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.

Options

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

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.

Custom

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.

(Re-)Authentication
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)

Workflows

Installation

To use this node in KNIME, install KNIME Twitter & Google Connectors from the following update site:

KNIME 4.0
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.

Developers

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.