Home/Browse/Financial document extraction from Gmail to Google Sheets

Financial document extraction from Gmail to Google Sheets

n8n20 modulesv1.0

GmailGoogle SheetsOpenAIGemini

At a glance

Financial document extraction from Gmail to Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, OpenAI, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

About this workflow

Overview Manual financial reconciliation is tedious and prone to error. This workflow functions as an AI Financial Controller, automatically monitoring your inbox for invoices, receipts, and bills, extracting the data using OCR, and syncing it to Google Sheets for approval. Unlike simple scrapers, this workflow uses a "Guardrail" AI agent to filter out non-financial emails (like newsletters) before they are processed, ensuring only actual transactions are recorded. Who is it for? Finance Teams: To automate the collection of vendor invoices. Freelancers: To track expenses and receipts for tax season. Operations Managers: To monitor budget spend and categorize costs automatically. How it works 1. Ingest: The workflow watches a specific Gmail label (e.g., "INBOX") for new emails. 2. Guardrail: A Gemini-powered AI agent analyzes the email text to determine if it is a valid financial transaction. If not, the workflow stops. 3. Extraction (OCR): If an attachment exists: An AI Agent (GPT-4o) extracts data from the PDF. If no attachment: An AI Agent extracts data directly from the email body. 4. Validation: Code nodes check for missing fields or invalid amounts. 5. Business Logic: The system automatically assigns General Ledger (GL) categories (e.g., "Uber" -> "Travel") and sets approval statuses based on amount thresholds. 6. Sync: Validated data is logged to Google Sheets, and a confirmation email is sent. Errors are logged to a separate error sheet. How to set up 1. Google Sheets: Copy this Google Sheet template to your drive. It contains the necessary tabs (Invoices, Error Logs, Success Metrics). 2. Configure Workflow: Open the node named "Configuration: User Settings". Paste your Google Sheet ID (found in the URL of your new sheet). Enter the Admin Email address where you want to receive error notifications. 3. Credentials: Connect your Gmail account. Connect your Google Sheets account. Connect your OpenAI (for OCR) and Google Gemini/PaLM (for Guardrails) accounts. Requirements n8n version 1.0 or higher. Gmail account. OpenAI API Key. Google Gemini (PaLM) API Key.

Financial document extraction from Gmail to Google Sheets

At a glance

About this workflow

How to import this n8n workflow

Setup guide

Step 1: Connect your apps

Step 2: Import the workflow JSON

More N8n workflows

Reviews