Google Sheets Connector

Creates a connection to Google Sheets, given a Google API connection.

When using the Google Authentication (API Key) node to provide the Google API connection, spreadsheets have to be shared with the service account, before they can be accessed.

For details on service accounts see: developers.google.com/identity/protocols/OAuth2ServiceAccount .

Input ports

1. Type: org.knime.credentials.base.CredentialPortObject
   Google API Connection
   The Google API connection that will be used.

Output ports

1. Type: Google Sheets
   Google Sheets Connection
   A connection that can be used to access Google Sheets