Hello everyone,
I have a problem that i need to read in all google sheets tables of one google sheets file. I didn’t find any solution so far.
Is there an easy way to do it?
Hello @aw15281,
I found a video detailing what I believe you want to do. It is a bit involved though and covers how to read multiple sheets in from google.
https://www.youtube.com/watch?v=d6574OMzHcE
Although if you are referring to reading in like all the different tabs of a google sheet into knime, I do not think the google sheets reader is able to do that right now out of the box. It can only read in one specific tab from a google sheet and there isn’t a node such as ‘Read Excel Sheet Names’ which can help create flow variables that you can pass into the excel reader.
A workaround I can think of is to convert them to excel sheets and work with the excel nodes.
I will leave this in feedback & ideas as this is a legitmate request for the node to be updated to support multiple tabs within a file or maybe add a new node maybe called “Read Google Sheet Names” and this can be used to automate the sheet reading.
Hope this helps,
TL
1 Like
Hello Thor,
I found a workaround with this google sheets reader/updater. But its not perfect…
We wrote manually the table names and used them as row to variable then we controlled the google sheets updater by these variable and it works.
Would be amazing if we could have the node as you mentioned 
4 Likes
Great to hear, I was looking for a work around also, but got stuck on figuring out how to get variables in.
TL
1 Like