Skip to content
agentusehub

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.

Time saved
Not reported
Setup time
Not reported
Running cost
Not reported
Cost range
Not reported

Use case overview

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.

Reported experience

  1. 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.

  2. 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.

  3. 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.

Example prompts

Try 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.
Sales · Beginner
  1. Form submit
  2. Fetch company site
  3. Claude scores fit

Auto-qualify inbound leads before a rep sees them

Score every demo request against your ICP, update HubSpot and ping the right rep in Slack within a minute of the form submit.

n8n · Claude · HubSpot · Slack
Customer Support · Intermediate
  1. New ticket webhook
  2. Claude classifies
  3. Draft from help docs

Triage support tickets and draft first replies

Every new Zendesk ticket gets a category, priority and sentiment tag plus a draft reply in an internal note before an agent opens it.

Zendesk · n8n · Claude