Analyze invoice exceptions weekly and publish RCA reports with Groq and Notion
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 16 nodes and runs on a schedule (every week at 09:00). Along the way it connects Google Sheets, Groq Chat Model, Notion and Slack.
How it runs
Trigger: On a schedule (every week at 09:00).
- Fetch: Invoice Exceptions (Google Sheets): uses Google Sheets
- Group Exceptions (Code): runs custom JavaScript code
- AI: Root Cause Analysis (Basic LLM Chain): sends a prompt to an LLM, with model: LLM: Groq RCA; output parser: Parser: RCA Output
- Extract: RCA Data (Edit Fields (Set)): sets 1 field: root_cause_analysis
- AI: Recommend Fixes (Basic LLM Chain): sends a prompt to an LLM, with model: LLM: Groq Fixes; output parser: Parser: Fixes Output
- Extract: Fixes Data (Edit Fields (Set)): sets 4 fields: Missing Receipt, Price Variance, Tax Mismatch…
- Generate Markdown Report (Code): runs custom JavaScript code
- Convert Markdown to Blocks (Code): runs custom JavaScript code
- Notion: work with database page
- Notion: Inject Blocks API (HTTP Request): calls an HTTP API (PATCH)
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Edit Fields (Set)
n8n-nodes-base.set - Notion
n8n-nodes-base.notion - HTTP Request
n8n-nodes-base.httpRequest - Slack
n8n-nodes-base.slack
From the author
Quick overview This workflow runs weekly to pull invoice exception data from Google Sheets, uses Groq-hosted LLMs to generate root-cause analysis and upstream process fixes, then publishes a formatted report to a Notion database and posts a Slack…