Money

Turn a PDF invoice upload into a spreadsheet row

  • Level Beginner
  • Setup~30 min (estimated)
  • Evidence Anecdotal
  • CostNot stated in source
  • No-codeNo
n8nSource-linkedBeginner-friendly

What they did

An n8n workflow takes an uploaded PDF invoice, extracts invoice number, total and other labeled fields, appends a row to Google Sheets, and flags needs_review when the number or total is missing.

How it went

Node-by-node writeup; digital PDFs only, no OCR

Worth knowing

  • Node-by-node writeup; digital PDFs only, no OCR.

Prompt

Cleaned version rewritten from the source — not a direct quote.

When I upload a PDF invoice to [folder/form], extract the vendor, invoice number, date and total, and add a row to [Invoices sheet]. If the number or total is missing, set needs_review = yes instead of guessing.

Recommended

Try it in Grok Bot

  1. Copy the prompt (button below).
  2. Open Grok Bot chat and paste it. Replace any [bracketed] placeholders.
  3. Connect the listed tools (Google Sheets) as connectors when Grok Bot asks.
  4. If the task repeats, ask: "Make this a daily routine."

Alternatives: the same prompt works in n8n, Claude, ChatGPT Agent, OpenClaw.

Set it up

Tools: Google Sheets · Stack: n8n + Google Sheets

  1. Read the original source for full context.
  2. Connect the tools your agent needs.
  3. Paste the prompt and replace [bracketed] placeholders.
  4. Run once manually and check the output before scheduling it.

Generic suggested steps, not from the source.

Evidence

Node-by-node writeup; digital PDFs only, no OCR

Source: Web · Verified by us: not yet · Report broken or outdated

Related use cases

MoneyWeb · 2026-02

Check a hospital bill against what Medicare would pay

A writer gave Claude the coded hospital claim (UB-04) for his late brother-in-law's $195,628 ER bill and asked it to build a spreadsheet of Medicare rates per code. Claude flagged bundled items billed separately, a bypass charge for a procedure that never happened, and a ventilation charge Medicare does not allow.

  • Level Intermediate
  • Setup1–3 hrs*
  • Evidence Strong evidence
ClaudeSource-linked
Inbox & communicationReddit

6-class email router for a 22-person consultancy

An IMAP trigger feeds an OpenAI classifier that routes 80–120 emails a day to Slack, Pipedrive and Zendesk. It hit 94% accuracy on 500 emails and saves 11 hours a week.

  • Level Intermediate
  • Setup1–3 hrs*
  • Evidence Some evidence
n8nSource-linked
MoneyReddit

Invoice capture for a distributor: 4m12s down to 38s each

A shared Gmail label feeds an extractor, totals are validated to €0.01, low-confidence fields go to a human, and results push to Sage. 87% need no human touch.

  • Level Intermediate
  • Setup1–3 hrs*
  • Evidence Some evidence
n8nMakeSource-linkedNeeds verification