Get a Google Sheet File ID or URL?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Carluccio555
9 - Comet
‎12-13-2023
10:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Labels:
- Labels:
- Input
1 REPLY 1
‎12-13-2023
12:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?