I have just tried configuring a Google Sheets Reader node using flow variables to specify the spreadsheet name and sheet name as shown:
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 )
Thanks
Steve