Skip to main content
Question

How do I create a Zap that reads an Excel file from Google Drive and creates a Flokzu instance based on the data?


Hello, I need to build a zap that detects when I upload a file to a specific drive folder, read all the rows of this document (Excel) and based on that data create an instance in Flokzu. I’m able to detect a new file and I’m able to create a Flokzu’s instance but I’m not able to connect both

Thanks in advance

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @MetaModelo 

Which drive app are you using for the trigger step?

 

For us to have full context, post screenshots with how the steps are outlined and configured.


Hi, we are using app Google Drive, event “New file in folder”. The file we need to read is an Excel spreadsheet loaded into drive

 


Troy Tessalone
Forum|alt.badge.img+14

@SoporteMetaModelo 

If the GSheet is in a CSV format, then you can use Files by Zapier actions to get the rows:

https://zapier.com/apps/files-by-zapier/integrations#triggers-and-actions

 

If you need to process each row, then use the Looping app: https://zapier.com/apps/looping/help