Spec an automation to build Prompt

Spec out an automation for [Zapier / Make / n8n].

What I want to happen: [trigger and desired outcome in plain English]
Tools involved: [all apps that need to connect]
Data moving between tools: [what information transfers?]
Edge cases: [what if X is missing or Y fails?]
Frequency: [real-time / scheduled]

Please produce:
1. Plain-English workflow spec (trigger → conditions → actions → errors)
2. Specific steps to build in [tool] with module names
3. Fields to map between tools
4. How to test before enabling
5. What to monitor to know it's working