Hi, I have a Zap which triggers every time there's a new order on Magento and then creates a new row on Google Sheets. While this is better than nothing, this is not the desired outcome.
The desired outcome would be that a new row on Google Sheets is created only if the status of the new order is "Paid". The problem is that when a new order is created the status is initially "Processing" and that's the status which Magento sends to Zapier. And later on, as the status of the order is updated to e.g. "Paid" or "Cancelled", the updated status won't be sent from Magento to Zapier since it's not a new order anymore.
Does anyone have a solution to this problem?