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?
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?