Google Input Tool as part of a batch macro

Question

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.

apathetichell · Answer

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.

OscarHL · Answer

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 · Answer

I explained this in a previous post - https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Changing-parameters-in-Google-Drive-Tools-with-Interface/td-p/1292975 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.