Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Google Input Tool as part of a batch macro

OscarHL
5 - Atom

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.

3 REPLIES 3
apathetichell
19 - Altair

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.

OscarHL
5 - Atom

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.

apathetichell
19 - Altair

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.

Labels
Top Solution Authors