agentusecasesAll 965 use cases
Work & Operations

Extract invoice data and file it into a bookkeeping sheet

A self-hosted n8n workflow extracts accounting data from uploaded receipts and invoices with OpenAI, then after user review files the originals and appends data to a yearly sheet.

Done withn8n

What they did
Users upload an image or PDF through a web page to an n8n webhook, which looks up the user by token in Google Sheets. Images go to OpenAI vision. PDFs have their text extracted first, then analyzed. The model returns structured JSON (date, merchant, gross amount, VAT rate, category) for the user to review and edit. On save, the file goes into a Drive user/month folder, and the data is appended to a yearly sheet.
How it went
The source gives no accuracy or time-saving figures. It describes a working prototype with a demo video. The public repo holds sanitized exports that won't run until you configure your own credentials and IDs.
Worth knowing
You need your own OpenAI, Google Drive and Sheets OAuth credentials, a user lookup sheet, a base Drive folder and an n8n webhook domain. The token lookup is a prototype stand-in for real authentication.

Try it yourself with n8n

Build a self-hosted n8n workflow where I upload receipts or invoices to [folder or form], and OpenAI extracts vendor, date, totals, tax and invoice number. Show me the extracted data for review, then on approval file the original in [Drive folder] and append a row to my [year] bookkeeping sheet. It's done when a sample invoice flows through; do not file or write anything until I approve.

2 more accounts of this

Read the original ↗

Source: github.com · Undated

Five of these in your inbox every morning

The best things people got an AI agent to do, each with the prompt to try it.

More like this