Icon

read_​google_​spreadsheet_​1

do somethingwith sheet'sdata here The workflow1) Gets spreadsheet's metadata2) Sends sheet names to the loop3) Reads sheets one by one read the sheetNode 2059Node 2064Node 2065GET spreadsheetmetadataOutput sheet namesIn each row:name and id of one sheetNode 2068 Google SheetsReader Google SheetsConnection GoogleAuthentication Variable Creator Python Source Table Row ToVariable Loop Start Loop End do somethingwith sheet'sdata here The workflow1) Gets spreadsheet's metadata2) Sends sheet names to the loop3) Reads sheets one by one read the sheetNode 2059Node 2064Node 2065GET spreadsheetmetadataOutput sheet namesIn each row:name and id of one sheetNode 2068Google SheetsReader Google SheetsConnection GoogleAuthentication Variable Creator Python Source Table Row ToVariable Loop Start Loop End

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-05-01
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!