Hey Dylan!
It looks like you might be able to achieve this workflow with a Slack app or automation. I found a thread in Stack Overflow mentioning a similar workflow with some options here.
From Zapier, you can post messages in public or private channels, but those are visible to anyone on those channels. Currently, the integration doesn’t support ephemeral messages because Slack’s API does not support retrieving these messages due to it’s temporary nature
Hey there @Dylan C 👋 Did Marge’s reply help to point you in the right direction?
Let us know if you still need help, or have any more questions! 🙂