Extract invoice data and file it into a bookkeeping sheet
Available for freelance n8n projects: Upwork-Link. Task: The author built a self-hosted n8n workflow to automate small business bookkeeping. Users upload receipts or invoices via a web interface; n8n identifies the user, extracts data (Date, Merchant, Gross, VAT, Category) using OpenAI, and returns it for human review. After confirmation, the system files the document in Google Drive and appends data to a yearly Google Sheet. The stack includes Docker, Caddy, and Azure for deployment.; tools: n8n. Human role: The original post does not say how a person stayed involved.; limitations: The repository contains sanitized workflow files that require manual configuration of API keys, OAuth credentials, and resource IDs to run. The solution relies on a token-based user lookup in Google Sheets rather than a full authentication system. Human verification is mandatory before data persistence..
Tools
Published on Agent Work Atlas:
Overview
Available for freelance n8n projects: Upwork-Link
Workflow
The author built a self-hosted n8n workflow to automate small business bookkeeping. Users upload receipts or invoices via a web interface; n8n identifies the user, extracts data (Date, Merchant, Gross, VAT, Category) using OpenAI, and returns it for human review. After confirmation, the system files the document in Google Drive and appends data to a yearly Google Sheet. The stack includes Docker, Caddy, and Azure for deployment.
Reported result
The source does not report measured outcomes, efficiency gains, or error rates. It describes the system as a functional prototype demonstrating end-to-end automation capabilities. No specific business impact metrics are provided.
Human role
The original post does not say how a person stayed involved.
Limitations
The repository contains sanitized workflow files that require manual configuration of API keys, OAuth credentials, and resource IDs to run. The solution relies on a token-based user lookup in Google Sheets rather than a full authentication system. Human verification is mandatory before data persistence.
Try it
I need to set up a document automation workflow for my small business. I have receipts and invoices in [replaceable input: image/PDF format] that need to be logged into [replaceable input: Google Sheets]. Please guide me through building an n8n workflow that: 1) Accepts file uploads via a webhook, 2) Uses OpenAI to extract Date, Merchant, Gross Amount, VAT Rate, and Category, 3) Sends the extracted JSON to a frontend for my manual review, and 4) Upon my confirmation, saves the file to [replaceable input: Google Drive folder] and appends the data to the sheet. Start by creating a sample workflow for one test receipt. Show me the extracted data and the proposed file structure before I approve the final configuration. Do not auto-save any data without my explicit confirmation.
Source reports are not independently verified. Publication date is the catalog publication date, not the original article date.