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.
Steps
- Trigger: Fires every Monday at 7AM
- Pulls this week's and last week's dataGoogle Sheets
- Formats a clean comparison table
- Claude AI writes a health reportAnthropic Claude
Wins, concerns and top 3 actions. - Output: Report emailed to your team via GmailGmail
- 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
Zoom meetings for new Zoho CRM leads
Also for scheduling and ops, 9 steps.
Patient follow-up emails with Claude
Also for scheduling and ops, 7 steps.
Daily Postgres briefing to Telegram
Also for scheduling and ops, 5 steps.
Gmail and Google Sheets: 22 templates compared
Same two apps, different steps.
Anthropic Claude and Gmail: 6 templates compared
Same two apps, different steps.
Anthropic Claude and Google Sheets: 4 templates compared
Same two apps, different steps.
Send a recurring summary
Other templates that do this task.