Generate a weekly business health report from Google Sheets with Claude

Description

Overview
Stop spending Monday mornings manually pulling numbers and building reports. This workflow reads your last 7 days of business data from Google Sheets, asks Claude AI to compare it to the week before, spot trends, flag problems and highlight wins — then emails a plain-English health report to your inbox before your team standup.

How it works

Fires every Monday at 7AM automatically
Pulls this week's and last week's data from your Google Sheet
Formats both datasets into a clean comparison table
Claude AI analyses the numbers and writes a structured health report covering wins, concerns, and top 3 actions
Report is emailed to your team via Gmail
Every run is logged to a second sheet tab for historical tracking

Setup steps

Google Sheets — Connect your Google account in Fetch This Week Data and Fetch Last Week Data nodes and select your data sheet. Each row should be one day, columns should be your key metrics
Configure node — Open Configure Report Settings and set your business name, report email, and a plain-English description of what your columns mean
Claude AI — Add your Anthropic API key to the Claude Sonnet sub-node from console.anthropic.com
Gmail — Connect your Gmail account in Send Weekly Report
Log sheet — Create a second tab called Report Log with columns: Date, Week Covered, Business, Status, Summary. Connect it in Log Report Run
Activate — runs automatically every Monday at 7AM