Google Sheets Connection
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.
- Type: Google API The Google API connection that will be used.
- Type: Google Sheets A connection that can be used to access Google Sheets
KNIME Labs > Google API Connectors (Labs) > Google Sheets Connectors
Make sure to have this extension installed: