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

2 Likes

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:

Steve

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