Reading GSheets from Google Drive

Hi all,

I am trying to read 200 google sheet files from Google Drive.

I am able to connect and read only by selecting the file and tab if I do this one by one.

Things I still couldn’t figure out;
1- Each file name should be an item as a column (Filename becoming a dimension)
2- Each file has 2 tabs in the google sheet. 2 tabs should be read
3- Each file should be picked up automatically without me selecting 200 of them

Thank you!


here is another post which covers some of your questions:

Does this helps? There is also an example workflow which shows how to extract file names and feed into the reader using flow variables.


1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.