Extract invoice data and send payment reminders with Google Drive, Mistral, Groq and Gmail
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs on Google Drive events (file created) (plus 1 other trigger). Along the way it connects Groq Chat Model, Google Drive, Google Sheets and Gmail.
How it runs
Trigger: On Google Drive events (file created) (plus 1 other trigger).
- Download New Google Drive File (Google Drive): download
- Read Note Sheet Data (Google Sheets): uses Google Sheets
- Extract Text From Image AI (Mistral AI): uses Mistral AI
- Filter: keeps only the items that match a condition
- Parse Note Components (Basic LLM Chain): sends a prompt to an LLM, with model: Groq Chat LLM Model
- Send Reminder Email (Gmail): uses Gmail
- Set Note Fields (Edit Fields (Set)): sets 5 fields: Document_date, Total, Company_Name…
- Append Note Data To Sheet (Google Sheets): append or update
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)
- Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Mistral AI
n8n-nodes-base.mistralAi - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail
n8n-nodes-base.gmail - Google Drive
n8n-nodes-base.googleDrive - Filter
n8n-nodes-base.filter
From the author
Quick overview This workflow monitors a Google Drive folder for new receipt or invoice images, uses Mistral AI OCR and a Groq-hosted LLM to extract key fields, writes the results to Google Sheets, and sends scheduled Gmail reminders when document dates are 7,…