Controlling Google Sheets reader by flow variable

I have just tried configuring a Google Sheets Reader node using flow variables to specify the spreadsheet name and sheet name as shown:

image

However, after quite a bit of puzzling I realised that no amount of changing these two flow variables will change the spreadsheet actually read - for that I would need to use the spreadsheetId. I tried list files (in case that showed me the IDs) on a connection to the relevant folder on my google drive, but sadly not, and there is no way that I can see to get from a set of known, user-friendly and systematic names to the spreadsheet ID…

Am I missing something? (If not - this is a feature request :slightly_smiling_face: )

Thanks

Steve

1 Like