Detect early payment invoice opportunities with Groq and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 15 nodes and runs on a schedule (every day at 09:00). Along the way it connects Groq Chat Model, Google Sheets and Gmail. It also calls api.npoint.io over HTTP.
How it runs
Trigger: On a schedule (every day at 09:00).
- Fetch Invoice Data (HTTP Request): calls api.npoint.io
- Calculate Discount ROI (Code): runs custom JavaScript code
- Check Discount Eligibility (If): checks a condition and branches into true / false
- Prepare Invoice Data (Edit Fields (Set)): sets 8 fields: vendor, amount, savings…
- Mark Expired Invoices (Code): runs custom JavaScript code
- AI Payment Decision Engine (AI Agent): runs an AI agent, with model: Groq AI Model
- Save Expired Invoice Log (Google Sheets): append
- Clean AI Response (Code): runs custom JavaScript code
- Save Eligible Invoice Log (Google Sheets): append
- Check High Priority Opportunity (If): checks a condition and branches into true / false
…plus 3 more steps. See the full node list below.
Services it uses
HTTP calls to: api.npoint.io
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 - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This workflow runs daily to fetch invoice data from an HTTP endpoint, calculate early-payment savings and annualized ROI, and use Groq (Llama 3.3) to prioritize eligible discounts. It logs eligible and expired invoices to Google Sheets and…