Route scanned invoices by company
Scanned invoices matched to a company, then emailed. An n8n template that watches a Google Drive folder for scanned invoices and extracts their text with OCR.Space. An OpenAI AI Agent reads the 'billed to' company name and checks it against a Google Sheet that holds company names and recipient emails. On a match, the invoice is sent as an attachment to the recipient through Gmail; on no match or an error, an alert email goes to an operator for manual review.
Steps
- Trigger: Watches a Google Drive folder for new invoicesGoogle Drive
- OCR Space extracts the textOCR.Space
- AI agent matches the company nameOpenAI
Cross-referenced against a database in Google Sheets. - Output: Sends the invoice to the matched recipientGmail
As an attachment. - Output: Emails an operator if there is no matchGmail
For manual review.
Limits
- If no company matches, an operator gets an email.
What it does well
- Company names are checked against a sheet of recipient emails.
Before you import
You need: OCR.Space header credential named apikey, an OpenAI API key, Google Drive and an email service.
Similar templates
Overdue invoice reminders in Gmail
Also for invoicing and payments, 7 steps.
Chase unpaid invoices with Claude
Also for invoicing and payments, 7 steps.
Chase unpaid invoices with OpenAI
Also for invoicing and payments, 7 steps.
Gmail and OpenAI: 29 templates compared
Same two apps, different steps.
Gmail and Google Drive: 12 templates compared
Same two apps, different steps.
Google Drive and OpenAI: 11 templates compared
Same two apps, different steps.
Google Drive and OCR.Space: 3 templates compared
Same two apps, different steps.
OCR.Space and OpenAI: 3 templates compared
Same two apps, different steps.
Copy records between apps
Other templates that do this task.