Question

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

  • 13 March 2024
  • 3 replies
  • 17 views

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


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

Userlevel 7
Badge +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

 

Userlevel 7
Badge +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