I need help to improve a zap that is for updating product prices from Woocommerce to Google Sheets. That is, I have a spreadsheet in Google Sheets with all my products listed with the respective prices in columns. One column has the regular price of the product, another the sale price, and others the wholesale prices for some products. The problem is that the trigger for this zap is the product update and triggers near 1000 times a day, so it burns all the zaps of the starter account in one day.
On the other hand, wholesale prices, being assigned by an external plugin, are saved in the product metadata and zapier does not export this meta data in separated values, only in one big text with a lot more information.
I’m looking for and expert to help me with this two problems in my zap.
Thanks in advance,