Creates a connection to Google Sheets, given a Google API connection.
\n 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 .
\n \t\t\n \n ","shortDescription":"This node creates a connection to the Google Sheets API.","keywords":["Spreadsheet"],"deprecated":false,"streamable":false,"tags":["IO","Connectors","Google"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABmJLR0QAAAAAAAD5Q7t/AAAACXBIWXMAAQNxAAEDcQFbh0NIAAAAB3RJTUUH4QgVDxMsHhDkpwAABBtJREFUOBEBEATv+wEEmFD/AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAPxosAEAAAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAD7Z68AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABZlRAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAFmVEAAAAAAPtnrwAFmVEAAAAAAAAAAAAAAAAA+2evAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAA+2evAAAAAAAAAAAA+2evAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAWZUQAAAAAA+2evAAWZUQAAAAAAAAAAAAAAAAD7Z68AAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA/GiwAAAAAAAAAAAAAAAAAAAEmFD/BJhQ/////////////////////////////////////////////////wAAAP8AAAD/BJhQ/wAAAAAAAAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAQEAAAAAAAAAAAAAAAAAAAAAAAAAAP8CAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQEBAAAAAAAAAAAAAAAAAPxosAAAAAD/AAAAAAQAAAAAAAAAAAWZUQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAASYUAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD/AAAA/wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAVFVM6kHifF0AAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.credentials.base.CredentialPortObject","color":"4386f7","dataType":"org.knime.credentials.base.CredentialPortObject","optional":false,"name":"Google API Connection","description":"The Google API connection that will be used."}],"outPorts":[{"objectClass":"org.knime.google.api.sheets.data.GoogleSheetsConnectionPortObject","color":"16a965","dataType":"Google Sheets","optional":false,"name":"Google Sheets Connection","description":"A connection that can be used to access Google Sheets"}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.4.3.v202503031608","bundleName":"KNIME Google API Nodes","bundleSymbolicName":"org.knime.google.api","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.google.api","featureName":"KNIME Google Connectors","featureVersion":"5.12.0.v202605041104","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*9KacbeCTeoRZrjhi"},"frequentSuccessors":[{"id":"*poHAFve1qUYVbcyD","factoryName":"org.knime.google.api.sheets.nodes.reader.GoogleSheetsReaderFactory","probability":0.34782608695652173},{"id":"*ffENCUEtNwhhpuNg","factoryName":"org.knime.google.api.sheets.nodes.sheetupdater.GoogleSheetUpdaterFactory","probability":0.30434782608695654},{"id":"*tORN7j1aLrofPiJ1","factoryName":"org.knime.google.api.sheets.nodes.spreadsheetwriter.GoogleSpreadsheetWriterFactory","probability":0.2391304347826087},{"id":"*dClw0vmaM4zoM5sa","factoryName":"org.knime.google.api.sheets.nodes.sheetappender.GoogleSheetAppenderFactory","probability":0.10869565217391304}]}