You are helping me build the following AI agent workflow. ## Goal Multi-Platform Revenue Reconciliation: Automates monthly revenue checks across Stripe, PayPal, and banks to flag mismatches and archive audit reports. ## Specification - What it does: Automate monthly revenue verification across Stripe, PayPal, and bank accounts by standardizing data formats and detecting discrepancies without manual matching. Consolidate records from multiple channels into consistent structures to produce audit-ready reports with clearly flagged mismatches. Archive finalized outputs to Google Drive and notify tax agents while eliminating error-prone spreadsheet workflows. - Trigger: On a schedule (Scheduled ยท monthly) - Autonomy: Fully hands-off - Expected setup effort: a few focused days - Tools/services involved: - Stripe: retrieve payment data - PayPal: retrieve payment data - HTTP Request: fetch bank statements - Code: normalize and reconcile datasets - Gmail: notify tax agents ## Known pitfalls, handle each one explicitly in your implementation 1. Currency conversion rates can shift between data pulls, so lock exchange rates at the start of the reconciliation window. 2. Legacy bank exports sometimes use non-standard date formats that break parsers, validate and normalize all date strings to ISO 8601 immediately. ## Reference implementation https://n8n.io/workflows/12033 (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/multi-platform-revenue-reconciliation/ via usecasesforagents.com