Zap not triggering when row is updated or changed

Hi @clairehunter 

Good question.

The issue is likely due to how your are replacing/updating the Excel file.

Hello @Troy Tessalone 

I am just uploading the new file into the folder with the preexisting file under the same exact name. Then it says “a file with this name already exists would you like to replace” So I click replace.

@clairehunter 

Yeah that likely won’t work with the Zap you have configured.

Replacing a file that already has rows of existing data, means those are probably not treated as “new rows” or “updated rows”.

@Troy Tessalone 

Oh okay. How would you recommend proceeding in order to make this work? Thanks!

@clairehunter 

We would need more context about the Excel files you are using.

Why are you replacing those files?

What is the format of the data within the files?

Are those CSV files?

@Troy Tessalone 

I apologize, I tried to submit a response and it doesn’t appear to have posted? I will retype it.

Why are you replacing those files?

We are exporting all of our open orders from our POS system to be imported into an order management software we created through Airtable. It is exported under the same name every time and replaces the old file. The new file will have most of the old rows and a few new rows.

What is the format of the data within the files?

It is a very simple Excel file with no formulas or anything. 30 columns and avg 130 rows. Information consists of Customer Name, Item #, QTY, Unit of Measure, Invoice Number, etc. These are the columns we will be mapping.

Are those CSV files?

They are all .xlsx files.

@clairehunter 

Perhaps just use the CSV Import Extension in Airtable?

https://support.airtable.com/docs/csv-import-extension

@Troy Tessalone 

My apologies. We are trying to eliminate the manual steps as we will be importing probably a minimum of 30 times a day.

@clairehunter 

Which POS app are you using?

Does it have a Zap app?

For your use case, there may not be a simple Zap to configure due to the deduplication logic.

Zap steps could look something like this…

(if using CSV files)

1. Trigger: GDrive - New File in Folder
2. Action: Formatter - Utilities > Import CSV File
3. Action: Looping - Create Loop from Line Items
4. Action: GSheets - Find/Create Row
5. Action: GSheets - Update Row

NOTE: This approach may be VERY task intensive and become expensive.

@Troy Tessalone 

Hey Troy,

Thanks for the help. The reason we are using Zapier is because our POS system is cloud based and does not API with anything whatsoever. It is called Decor Fusion.

Are you storing these files in OneDrive or Google Drive? Both apps have a “New File” trigger that might help

Would it be possible to add a new worksheet to the existing Excel sheet instead of completely replacing the file? If so, the New Worksheet trigger might work