I would love to get an answer to this question as well. I keep comings back to Zapier and the likes hoping I will find a useful use case but can’t. It seems that all it does is add stuff from email marketing forms to Google spreadsheets.
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.