Google Input Tool as part of a batch macro
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I have built batch macros in the past but not using the Google tools. Has anyone been able to use this tool (Google Drive Input) as part of a macro to open files from a directory list? My macro seems to iterate over the same file.
Thanks in advance.
- Labels:
- Batch Macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I explained this in a previous post - https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Changing-parameters-in-Google-... see the part marked solved. This is not easy and you will need to use multiple action tools and either feed in multiple values or use regex to extract them from the same value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks, as you explained in that post, not the best solution in terms of loading time. Have asked a question in the same trail about converting a list of files to another format. Hopefully I can get an answer soon. Thanks again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think what you're seeing is kind of the limits of the Alteryx implementation of the Gdrive/Gsheets api. If you want to do something like - take a gdrive/read in a list of files/convert the files to another format. Alteryx isn't the best tool for it. You can also ask Claude to write up some python with the Drive Python SDK to do some of this stuff and plug it into the Python tool.
