{"product_id":"daily-revenue-ops-brief-n8n-google-sheets-claude-email","title":"Daily Revenue Ops Brief n8n: Google Sheets, Claude \u0026 Email","description":"\u003ch3\u003eSend a daily Revenue Operations Brief—automatically\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eDaily Revenue Ops Brief n8n: Google Sheets, Claude \u0026amp; Email\u003c\/strong\u003e workflow reads each client’s \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e revenue data, calculates week-over-week performance and transaction status, generates a clear plain-English summary using \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e, then emails the brief via \u003cstrong\u003eSMTP\u003c\/strong\u003e—all while logging results in \u003cstrong\u003eSupabase\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 07:00\u003c\/strong\u003e on a schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches all active clients\u003c\/strong\u003e from \u003cstrong\u003eSupabase\u003c\/strong\u003e and processes them one-by-one.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads the Google Sheets “Revenue” tab\u003c\/strong\u003e and computes:\n    \u003cul\u003e\n      \u003cli\u003eTotals for the \u003cstrong\u003elast seven complete days\u003c\/strong\u003e vs the \u003cstrong\u003eprior seven days\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eCounts for \u003cstrong\u003eoverdue\/failed\/unpaid transactions\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eCategory breakdowns\u003c\/strong\u003e and detected metrics\/anomalies\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates an ops brief with Anthropic Claude\u003c\/strong\u003e using the computed metrics and anomalies.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the brief by email\u003c\/strong\u003e using \u003cstrong\u003eSMTP\u003c\/strong\u003e, including a \u003cstrong\u003edashboard link\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs brief text and supporting metrics\u003c\/strong\u003e into a Supabase brief history table, then moves to the next client (skipping clients where sheet reads or Claude calls fail).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIncludes a webhook onboarding flow\u003c\/strong\u003e (header-authenticated) that validates business details and a Google Sheets URL, creates the client in Supabase, returns a dashboard URL, and sends a welcome email via SMTP.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRevenue Ops or agency teams sending \u003cstrong\u003econsistent daily client reporting\u003c\/strong\u003e without manual spreadsheet review\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who want \u003cstrong\u003eautomated week-over-week insights\u003c\/strong\u003e with a human-readable narrative\u003c\/li\u003e\n  \u003cli\u003eMulti-client setups where onboarding new accounts must be \u003cstrong\u003efast and standardized\u003c\/strong\u003e via webhook\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/integrations:\u003c\/strong\u003e code, no op, webhook, Supabase, Google Sheets OAuth2, Email Send (SMTP), Anthropic (HTTP header auth via \u003ccode\u003ex-api-key\u003c\/code\u003e), sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eModel configuration:\u003c\/strong\u003e update the \u003cstrong\u003eClaude model ID\u003c\/strong\u003e used in the Anthropic request\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling:\u003c\/strong\u003e daily trigger at \u003cstrong\u003e07:00\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46086662029491,"sku":"N8N-19902","price":20.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/DNV2GFaR0GyK4jH4rJkDH_TQcEhm1O.png?v=1790327494","url":"https:\/\/buyflowscripts.com\/products\/daily-revenue-ops-brief-n8n-google-sheets-claude-email","provider":"N8N Commerce","version":"1.0","type":"link"}