Templates / Approve and audit expense claims with Google Gemini and Google Sheets

Approve and audit expense claims with Google Gemini and Google Sheets

Ready for 3.0

by Mohd Maaz Khan · 21 views · created 2026-08-31 · Invoice Processing, AI Chatbot

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 33 nodes and runs when an HTTP POST request hits its webhook URL (plus 3 other triggers). Along the way it connects Google Gemini, Google Sheets and Gmail.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 3 other triggers).

  1. Split Bulk Attachments (Code): runs custom JavaScript code
  2. Find Claim By ID (Google Sheets): uses Google Sheets
  3. Parse Decision (Code): runs custom JavaScript code
  4. Capture Employee Info (Code): runs custom JavaScript code
  5. Respond - Status Check (Respond to Webhook): sends the response back to the webhook caller
  6. Find Pending Claim (Google Sheets): uses Google Sheets
  7. Ask Gemini to Read Receipt (Google Gemini): analyze (image)
  8. Approved or Rejected? (If): checks a condition and branches into true / false
  9. Parse Extracted Data (Code): runs custom JavaScript code
  10. Update Ledger - Approved (Google Sheets): update

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

Services it uses

Google GeminiGoogle SheetsGmail

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (8)

From the author

Quick overview This workflow accepts expense receipts via a web upload webhook or email (IMAP), uses Google Gemini to extract claim details, checks policy rules and past spend in Google Sheets, and either auto-approves and logs the claim or emails a manager…

Excerpt from Mohd Maaz Khan's description on n8n.io.

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

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.