Automate German Tax Docs from Gmail to Google Sheets

Transform Your German Tax Document Processing with Intelligent Email Automation

Streamline your German tax compliance workflow with this powerful n8n automation that automatically extracts, processes, and organizes tax documents from Gmail attachments directly into structured Google Sheets records. Perfect for accountants, tax preparers, and freelancers managing recurring document intake and compliance workflows.

What This Workflow Does

This comprehensive automation monitors your Gmail for incoming messages with attachments, then intelligently processes each document through a sophisticated pipeline. The workflow uploads files to a designated Google Drive invoice folder, converts documents to base64 format, and leverages Google Gemini OCR for accurate text extraction. A specialized language and currency agent translates content to German, detects non-EUR amounts, retrieves historical exchange rates, and normalizes all values to EUR. Advanced extraction and classification agents then map document data to German tax fields including Einkunftsart, tax relevance, deductions, dates, and confidence scores. Finally, processed data along with Drive file links are automatically appended to your Google Sheets register.

Use Cases

• Tax Preparation Services: Automatically process client invoices, bank statements, and tax certificates received via email
• Freelancer Compliance: Maintain organized tax records from diverse income sources and business expenses
• Accounting Firms: Streamline document intake for multiple clients with consistent German tax field mapping
• Business Operations: Create audit-ready documentation with automatic currency conversion and categorization

Technical Details

Built with essential n8n nodes including Set, Code, Merge, Sticky Note, Google Drive, and HTTP Request components. This workflow integrates seamlessly with Gmail, Google Drive, Google Sheets, and Google Gemini APIs. Requires community AI tool node installation and is designed for self-hosted n8n instances only.

Setup is straightforward: add your Gmail, Google Drive, Google Sheets, and Google Gemini credentials, configure your Gemini API key, select your target Drive folder and output spreadsheet, then activate. The workflow includes detailed setup instructions and supports immediate testing with sample attachments.