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:


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: )




Hi @s.roughley -

Sorry for the frustration. This is one we have a ticket for already (AP-17528) and I’ve added another +1 on it from you.

1 Like

Thanks Scott - I thought I might be going to have to write it myself :smiley:


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