Hi Zapier Community,
I have an online Shopify store that lists entirely other people’s products. These products are made to order and there is a cutoff time for ordering before delivery/pickup. Right now, I am having to receive the orders, group them, and then manually send out orders to the vendors, but I would like to automate this process using Zapier.
What’s the best way to set this up? Or is it even possible to do this using Zapier?
Shopify does produce a “vendor” output, so I had thought about doing something like an IF “vendor”, THEN “vendor email” condition, and then forwarding the order. Or, less ideally, I thought about having a Google Sheet with running order totals for each company, that I could use to populate emails after the order cutoff.
However, I have 100+ vendors, and we’re adding all the time. Is there a way to make that process easier than adding a new condition for every new vendor?
Best answer by Troy TessaloneView original
Consider making a dynamic Zap that uses a GSheet as a Lookup Table to store the Vendor and related email address.
Try these Zap steps...