Hi Filli,
Welcome to the Community!
As for Zapier, I think that’s how it works. You can try Integromat, an alternative to Zapier. (You can do way more complex setups in Integromat) Btw, Integromat changed their name to Make.
This tutorial should also help you: