Weekly business report with Claude

Claude turns weekly sheet figures into an emailed report. This n8n template runs every Monday at 7 AM, fetches this week's business figures from Google Sheets, and passes them to a Claude Sonnet sub-node. Claude analyses the numbers and writes a plain-English health report covering wins, concerns and three actions. The report is emailed through Gmail, and every run is logged to a Report Log tab with date, week covered, business, status and summary. Claude compares the week with the week before.

n8nRead on 2026-11-166 steps

Steps

  1. Trigger: Fires every Monday at 7AM
  2. Pulls this week's and last week's dataGoogle Sheets
  3. Formats a clean comparison table
  4. Claude AI writes a health reportAnthropic Claude
    Wins, concerns and top 3 actions.
  5. Output: Report emailed to your team via GmailGmail
  6. Output: Run logged to a second sheet tabGoogle Sheets

Limits

  • The page names Claude Sonnet but no model version.
  • You create the Report Log tab yourself before the first run.

What it does well

  • Every run is logged with date, week covered, business, status and summary.

Before you import

Setup: connect Google Sheets in the two fetch nodes, set the business name, report email and column descriptions in the Configure node, add an Anthropic API key to the Claude Sonnet sub-node, connect Gmail and create the Report Log tab.

Similar templates