Google Sheets Connection

Manipulator

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: Google API The Google API connection that will be used.

Output Ports

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

Find here

KNIME Labs > Google API Connectors (Labs) > Google Sheets Connectors

Make sure to have this extension installed: