Read Gmail receipt PDFs with Claude and reconcile card statements in Google Sheets

by 久保田 卓磨 ✓ · 1 views · created 2026-10-13 · Invoice Processing, AI Summarization

What this workflow does

This AI workflow has 21 nodes and runs on Gmail events (message received) (plus 2 other triggers). Along the way it connects Gmail, Anthropic, Google Sheets and Slack.

How it runs

Trigger: On Gmail events (message received) (plus 2 other triggers).

1. Config (Edit Fields (Set)): sets 8 fields: base_currency, card_date_col, card_vendor_col…
2. Spreadsheet ID (Edit Fields (Set)): sets 1 field: spreadsheet_id
3. Is it a new email? (If): checks a condition and branches into true / false
4. Add the Receipts, Card and Matches tabs (HTTP Request): calls an HTTP API (POST)
5. Split attachments (Code): runs custom JavaScript code
6. Read Receipts tab (Google Sheets): read (sheet)
7. Write the header rows (HTTP Request): calls an HTTP API (POST)
8. Extract text from PDF (Extract from File): extracts data from a file (pdf)
9. Read Card tab (Google Sheets): read (sheet)
10. AI: Read receipt (Anthropic): analyze (document)

…plus 8 more steps. See the full node list below.

Services it uses

GmailAnthropicGoogle SheetsSlack

Before you upgrade to n8n 3.0

Nodes used (10)

• Gmail Triggern8n-nodes-base.gmailTrigger
• Manual Triggern8n-nodes-base.manualTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if
• Coden8n-nodes-base.code
• Extract from Filen8n-nodes-base.extractFromFile
• Anthropic@n8n/n8n-nodes-langchain.anthropic
• Google Sheetsn8n-nodes-base.googleSheets
• Slackn8n-nodes-base.slack
• HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick overview This workflow monitors Gmail for PDF receipts, uses Anthropic Claude to extract structured receipt data, stores validated results in Google Sheets, then matches receipts to a pasted card statement and posts a reconciliation summary to Slack.…

View the original on n8n.io → Check your own copy