You are helping me build the following AI agent workflow. ## Goal Event Planning & Budget Optimization: Daily or on-demand, it fuses client briefs, budgets, and vendor data to generate optimized event plans with ROI, risk scores. ## Specification - What it does: You get optimized event plans with calculated ROI and risk scores by fusing your client briefs, budgets, and vendor data into a single automated workflow. This process handles cost analysis and auto-approvals for high-value events, then delivers the final results directly to you via Slack notifications and email reports without any manual intervention. - Trigger: On a schedule (Scheduled ยท daily 7:00 or Webhook) - Autonomy: Fully hands-off - Expected setup effort: a few focused days - Tools/services involved: - n8n: Workflow orchestration platform - Google Sheets: Storing client briefs, budgets, and vendor data - Anthropic Chat Model: AI analysis of event plans and risk assessment - Slack: Sending status updates to the team - Send Email: Delivering final executive reports ## Known pitfalls, handle each one explicitly in your implementation 1. Data type mismatches between sheets can break the fusion step so ensure all currency columns are formatted as numbers before processing. 2. Slack message character limits can truncate important details so implement logic to split long summaries into multiple messages. ## Reference implementation https://n8n.io/workflows/10219 (workflow template) Fetch and inspect this before building. If it matches my stack, adapt it; if not, rebuild the pattern with my tools. ## Process requirements 1. Before building: ask me which of the listed tools I actually use and what my platform is (n8n / Make / code / other). Do not assume. 2. Adapt the pattern to my answers; do not force the reference stack. 3. Address every pitfall above; tell me how you handled each. 4. Provide a test plan I can run before letting this touch real data. 5. Ask before any step that sends messages, modifies data, or spends money. Source: https://usecasesforagents.com/use-case/automated-event-planning-budget-optimization/ via usecasesforagents.com