{"product_id":"cfo-invoice-health-report-n8n-google-sheets-groq-gmail","title":"CFO Invoice Health Report n8n: Google Sheets, Groq \u0026 Gmail","description":"\u003ch3\u003eDaily CFO-ready invoice health reports from your Google Sheets—automatically\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eCFO Invoice Health Report n8n\u003c\/strong\u003e is a scheduled n8n workflow that pulls active invoice and KPI data from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, calculates operational KPIs and trends, generates an executive \u003cem\u003eCFO-style summary\u003c\/em\u003e using \u003cstrong\u003eGroq Llama 3\u003c\/strong\u003e, then logs results back to Sheets and sends either a \u003cstrong\u003eGmail report\u003c\/strong\u003e or a \u003cstrong\u003eSlack escalation\u003c\/strong\u003e based on a health score.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 9 AM\u003c\/strong\u003e using an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads active invoice rows\u003c\/strong\u003e from Google Sheets and calculates current KPIs, bottlenecks, SLA-risk invoices, and an \u003cstrong\u003eoverall finance health score\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls KPI history\u003c\/strong\u003e from Google Sheets and compares the latest snapshot to compute \u003cstrong\u003etrend percentages\u003c\/strong\u003e and direction summaries.\u003c\/li\u003e\n  \u003cli\u003eBuilds a \u003cstrong\u003ebacklog \/ SLA risk assessment\u003c\/strong\u003e from current KPIs and trends, then sends the dataset to a \u003cstrong\u003eGroq Llama 3\u003c\/strong\u003e agent to generate a \u003cstrong\u003eCFO-level JSON executive assessment\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans and parses\u003c\/strong\u003e the AI response into structured fields, and sets a \u003cstrong\u003eLooker Studio dashboard URL\u003c\/strong\u003e for reporting.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends daily KPI snapshot\u003c\/strong\u003e and updates a dashboard sheet in Google Sheets so Looker Studio stays current.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCommunicates the outcome:\u003c\/strong\u003e if health score is \u003cstrong\u003eabove 60\u003c\/strong\u003e, sends an \u003cstrong\u003eHTML email via Gmail\u003c\/strong\u003e; otherwise, posts a \u003cstrong\u003ecritical alert to Slack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS finance ops teams needing \u003cstrong\u003edaily invoice SLA risk visibility\u003c\/strong\u003e without manual reporting.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers implementing a \u003cstrong\u003eCFO KPI trend + executive summary\u003c\/strong\u003e workflow in n8n.\u003c\/li\u003e\n  \u003cli\u003eOperators who want Google Sheets + Looker Studio reporting with \u003cstrong\u003eAI-generated executive insights\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, Groq (Llama 3), Gmail, Slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e scheduling, \u003ccode\u003eif\u003c\/code\u003e branching on health score, HTML email formatting (\u003ccode\u003ehtml\u003c\/code\u003e), and Slack escalation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup:\u003c\/strong\u003e configure Google Sheets spreadsheet ID and sheet tabs (active invoices, KPI history, KPI snapshot, dashboard), plus add \u003cstrong\u003eGroq API credentials\u003c\/strong\u003e and confirm the selected model (e.g., \u003cem\u003ellama-3.3-70b-versati…\u003c\/em\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45895367819443,"sku":"N8N-18673","price":24.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/JRwNCidhcWYVHqbqx-UEs_Zpx5QOpE.png?v=1787648617","url":"https:\/\/buyflowscripts.com\/products\/cfo-invoice-health-report-n8n-google-sheets-groq-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}