Read ZIP files and xlsx Files from google Drive and Collate Them

[DataPirate26]

Hi all,

I have a requirement in which I have to read multiple .Zip files and multiple xlsx file from google drive together and combine them to get the entire dataset. Both of them have the similar structure. Can anyone give me an example how this can be achieved ? 

[Felipe_Ribeir0]

Hi @DataPirate26 

alteryx has a google drive connector that can be installed, but  the only supported file formats for it are XLSX, CSV, and YXDB.

Google Drive Tools - Alteryx Community

If you really need to go on with the zip files, you gonna need to follow google drive documentation and build the code with python.

Google Drive for Developers  |  Google Developers

[DataPirate26]

@Felipe_Ribeir0 I am able to connect to google drive. But unable to read and extract multiple files. 

If possible Can you share an example which will allow me to Extract Multiple Zip files and each of the Zip has only again 1 file in it (CSV or xlsx) having the same structure and the files has only 1 sheet (Sheet name is : Report) and then we will combine them to get the entire dataset. 

No need to connect to google drive. I am able connect to the Google Drive. 

The name of ZIP File and the file inside it will be as as shown in the example below:

Example: 1) Test_Jan 2022.ZIP contains the file ( Test_Jan 2022.CSV)

                2) Test_Feb 2022.ZIP Contains the file (Test_Feb 2022.xlsx)

                3) Test_March 2022.ZIP contains the file (Test_March 2022..CSV)

                4) Consolidated Data Dump_ April 2022.ZIP contains the file (Consolidated Data Dump_ April 2022.xlsx) 

The goal is to collate all the files together. Each file has same structure and only 1 sheet in them. 

Can you help me with an example for this?