I built an invoice automation that processes invoices automatically from Google Drive.
No more manual data entry.
Here’s what it does:
• Watches a Google Drive folder
• Detects new invoices (PDF, JPG, PNG)
• Extracts all key data automatically
– Supplier
– Invoice number
– Date
– VAT
– Line items
– Total amount
• Pushes everything into Google Sheets
• Moves the processed file into a separate “Processed” folder
• Prevents duplicates
So the workflow becomes:
Upload invoice → Data extracted → Sheet updated → File archived.
No touching it.
Why this matters (ROI breakdown):
Let’s say:
You process 150 invoices per month
Each takes 3–5 minutes manually
That’s 450–750 minutes.
7.5 to 12.5 hours per month.
That’s 90–150 hours per year.
If admin time costs £20/hour:
That’s £1,800–£3,000/year in manual data entry.
And that’s before you factor in:
• Human error
• Missed VAT claims
• Duplicate entries
• Lost receipts
• Accountant back-and-forth
The benefit isn’t just “automation”.
It’s:
Time back
Cleaner books
Faster reporting
Better cash flow visibility
Less admin fatigue
And the biggest one?
You stop doing £20/hour tasks as a business owner.
Instead of:
Download → Open → Type → Check → File → Repeat
It becomes:
Upload → Done.
This is the type of automation that doesn’t look flashy.
But it compounds.
If anyone wants the Make scenario logic or how I structured the extraction prompts, happy to break it down