AI Executive Report Generator

1. Identify the Google Sheets containing your data sources (revenue, KPIs, project status, etc.). Note each Sheet ID and the specific ranges to pull. 2. Create a new workflow triggered on a schedule (e.g., every Monday at 8 AM) or via manual webhook. 3. Add multiple Google Sheets "Read Rows" nodes — one per data source. Configure each with the appropriate Sheet ID and range. 4. Add a Code/Function node that aggregates all sheet data into a single structured JSON object with sections (e.g., { revenue: [...], kpis: [...], projects: [...] }). 5. Add an HTTP Request node to call Claude API (POST https://api.anthropic.com/v1/messages). Set headers: x-api-key: {{YOUR_ANTHROPIC_API_KEY}}, anthropic-version: 2023-06-01. In the body, use model "claude-sonnet-4-20250514", max_tokens: 4096. Craft your prompt: "You are an executive report writer. Analyze the following business data and generate a report with: 1) Executive Summary (3 sentences), 2) Key Metrics & Trends, 3) Anomalies & Concerns, 4) Recommendations. Data: [aggregated JSON]" 6. Add a Code node to parse Claude's response and format it as HTML for the email and plain text for Slack. 7. Add a Gmail node to send the HTML report to your stakeholder distribution list. Add a Slack node to post the executive summary and top 3 highlights to your #leadership channel. 8. Test with last week's data first. Iterate on the prompt until the report quality matches your expectations — add examples of good reports to the prompt for better output.