Skip to main content

Hi, looking for some help please.

I am creating invoices in Xero based on what has been put in a Google Sheet row, but only want to include line items where they have a quantity greater than 0.

I only have 6 products so I am passing all products in to the zap along with the quantity.

Can you please help me with how I can only carry forward line items with a quantity that is greater than 0.

Example Output from my utilities step:

Thanks so much

Hi @Kiki1806 

Try using the Looping app to handle the line items followed by a Filter step.

Looping: https://zapier.com/apps/looping/help

Filter: https://zapier.com/apps/filter/help