For more complex things Zapier falls flat IMO. I've been using Make.com (formerly Integromat) and it offers way more flexibility and it's easier to configure for more complex automations.
1 Month (billed Monthly):
---Zapier $29
---(5 triggers / 750 events)
---Make $11
---(unlimited triggers/10,000 events)