I am trying to create a Google sheet that will show our up-to-date inventory for our customers. Here’s the system I came up with. I’m an experienced Zapier user, but steps 2-4 are all buggy for me.
Does this make sense? Is there an easier way to do this???
1 It is triggered when an order is created in ShipStation.
2 The next step is to look up the current inventory on the sheet. I’m trying to do that with the “Lookup Spreadsheet Row in Google Sheets” action. It should look for the SKU of the item(s) ordered and then identify the current quantity.
3 The next step is to subtract the quantity ordered from the number found in step 2.
4 The final step would be to update that line with the new adjusted quantity.