Icon

read_​google_​spreadsheet_​2

OAuth Connector setup a) Select Googleb) Enter Client ID and Secret Key of an OAuth 2.0 Client you created in your Google Cloud Projectc) Supply an API Key of the project via the variable project_api_key in the Variable Creator node output: sheet names and ids of the spreadsheet output: data from an entire sheet (can be easilyset to get data from a specific range) output: data from a specific range - no need ofPython (can be easily set to get data from anentire sheet) Node 2071Node 2077Node 2078GET sheetcontentNode 2080GET sheet namesfilter columnsGET data froma sheetNode 2088 OAuth Connector[BETA] Variable Creator Column Expressions Column Filter GET Request JSON to Table Python Script JSON Path Python Script Ungroup OAuth Connector setup a) Select Googleb) Enter Client ID and Secret Key of an OAuth 2.0 Client you created in your Google Cloud Projectc) Supply an API Key of the project via the variable project_api_key in the Variable Creator node output: sheet names and ids of the spreadsheet output: data from an entire sheet (can be easilyset to get data from a specific range) output: data from a specific range - no need ofPython (can be easily set to get data from anentire sheet) Node 2071Node 2077Node 2078GET sheetcontentNode 2080GET sheet namesfilter columnsGET data froma sheetNode 2088 OAuth Connector[BETA] Variable Creator Column Expressions Column Filter GET Request JSON to Table Python Script JSON Path Python Script Ungroup

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: dustb
Created at: 2022-04-02
On NodePit since: 2022-04-03
Last update: 2024-04-25
Created with KNIME version: v4.5.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!