{"product_id":"n8n-invoice-risk-triage-google-sheets-groq-slack-notion","title":"n8n Invoice Risk Triage: Google Sheets + Groq + Slack\/Notion","description":"\u003ch3\u003eInstantly triage invoice payment risk—then escalate the ones that matter\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow reviews pending invoices from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, scores each one’s \u003cstrong\u003edelay risk\u003c\/strong\u003e, uses \u003cstrong\u003eGroq\u003c\/strong\u003e to generate a concise recommendation, logs results back to Sheets, and escalates \u003cstrong\u003emedium\/high-risk\u003c\/strong\u003e invoices to \u003cstrong\u003eSlack\u003c\/strong\u003e and \u003cstrong\u003eNotion\u003c\/strong\u003e (with \u003cstrong\u003eGmail\u003c\/strong\u003e reminders when appropriate).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls data from Google Sheets\u003c\/strong\u003e: Reads pending invoices and matching vendor payment history from your selected spreadsheet tabs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required fields\u003c\/strong\u003e: Checks each invoice for required information (e.g., a due date and a positive amount). Any invalid records are sent to \u003cstrong\u003eSlack\u003c\/strong\u003e for cleanup.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates a delay risk score (0–100)\u003c\/strong\u003e: Merges valid invoices with vendor history, computes days until due, and derives a 0–100 risk score based on vendor payment timing and reliability.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Groq for an AI risk summary\u003c\/strong\u003e: Sends invoice details to \u003cstrong\u003eGroq\u003c\/strong\u003e to produce a one-sentence risk summary and a one-sentence recommended action.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets\u003c\/strong\u003e: Appends invoice ID, vendor, risk score, Groq recommendation, and the log date into a risk log tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates by risk level\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eHigh risk (\u0026gt; 70)\u003c\/strong\u003e: Posts an escalation to \u003cstrong\u003eSlack\u003c\/strong\u003e and creates a high-priority follow-up task in \u003cstrong\u003eNotion\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eMedium risk (≥ 40, not high)\u003c\/strong\u003e: Sends a gentle reminder via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eLow risk\u003c\/strong\u003e: Only logs the result.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAP teams want automatic triage for invoices likely to slip beyond due dates.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators track vendor payment reliability and standardize follow-ups using AI-assisted recommendations.\u003c\/li\u003e\n  \u003cli\u003eFinance ops need a single workflow to validate records, score risk, and route actions to Slack\/Notion.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: Invoices input, vendor history merge, and risk log output.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGroq\u003c\/strong\u003e: Generates one-sentence risk summaries and recommended actions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e: Sends invalid-record alerts and high-risk escalations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotion\u003c\/strong\u003e: Creates high-priority follow-up tasks for high-risk invoices.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: Sends gentle reminder emails for medium-risk invoices.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes mentioned\u003c\/strong\u003e: if, set, code, gmail, merge, slack.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45895368310963,"sku":"N8N-18672","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/GfZQ2IWqEjIgDkE8IlRG0_7ohFfyeB.png?v=1787648643","url":"https:\/\/buyflowscripts.com\/products\/n8n-invoice-risk-triage-google-sheets-groq-slack-notion","provider":"N8N Commerce","version":"1.0","type":"link"}