Get a Google Sheet File ID or URL?

[Carluccio555]

I've been playing with the Directory tool, Google Sheet and Google Drive input connectors and it seems like Alteryx is only interested in referring to Google Sheets files via a 'traditional' file path and file name.

I have some Google Apps Scripting and other Google Functions which use the unique file ID or url. This is super useful because a file can be moved or even renamed yet it will keep its file unique ID.

So my question is, does anyone know a way that Alteryx can retrieve the Google sheet ID?

[Carluccio555]

OK so when I attach an action tool to the Google Drive tool the ID is showing as a paramater:

How would I go about grabbing this for a set of files in a location, similar to directory tool?