Expense organizer with Google Drive routing and Gemini AI entity detection

Who's it for This workflow is perfect for individuals, small businesses, or households who need to: - Automatically process and categorize expense receipts - Extract structured data from invoices and receipts using AI - Store receipts in multiple locations (Google Drive and S3) - Send automated email notifications with expense details - Send documents to accounting systems via email hooks How it works This comprehensive expense processing workflow combines AI-powered document analysis with automated file management and notifications. Here's the complete flow: 1. Form Submission: Users submit expenses through a web form with receipt upload and category selection (Personal, Business, or Shared/Home) 2. AI Document Processing: The workflow extracts text from PDF receipts using OCR, then uses Google Gemini AI to parse and structure the data into a standardized JSON format including vendor details, amounts, dates, and categorization 3. Smart Routing: Based on the expense category, receipts are automatically routed to different processing paths with category-specific folder organization 4. Multi-Destination Storage: Receipts are uploaded to: - Google Drive (organized by year/month folders) - S3 cloud storage buckets - Different destinations based on expense type 5. Email Notifications: Sends formatted HTML email notifications with complete expense details and links to stored receipts 6. Accounting System Integration: Automatically forwards business expenses to accounting systems via email hooks (customizable per user requirements) Requirements Credentials needed: - Google Gemini API: For AI-powered document analysis - Google Drive OAuth2: For personal and business drive access - Gmail OAuth2: For sending email notifications - S3 Storage: For cloud backup (AWS S3, Wasabi, etc.) Services used: - Google Drive (multiple accounts supported) - Google Gemini AI - Gmail - S3-compatible storage - Form trigger webhook How to set up Step 1: Configure Credentials 1. Set up Google Gemini API credentials in n8n 2. Configure Google Drive OAuth2 for both personal and business accounts 3. Add Gmail OAuth2 credentials 4. Set up S3 storage credentials Step 2: Update Configuration 1. Replace all placeholder values: - YOURGEMINICREDENTIALID with your Gemini credential ID - YOURPERSONALGDRIVECREDENTIALID with personal Drive credential - YOURBUSINESSGDRIVECREDENTIALID with business Drive credential - YOURGMAILCREDENTIALID with Gmail credential - YOURS3CREDENTIALID with S3 credential 2. Update Google Drive folder structure: - Replace YOURBUSINESSDRIVEID and YOURSHAREDDRIVEID with actual drive IDs - Update the JavaScript code in the three Code nodes with your actual folder mapping 3. Configure email addresses: - Replace [email protected] with your notification email - Replace [email protected] with your accounting system's email hook (this is a mail hook for uploading documents to small business accounting systems - can be modified per user requirements) 4. Update S3 bucket names: - Replace business-expenses, personal-expenses, and shared-expenses with your bucket names Step 3: Set Up Folder Structure Create organized folder structures in your Google Drives: Drive Root/ ├── 2024/ │ ├── January/ │ ├── February/ │ └── ... (all months) ├── 2025/ │ ├── January/ │ └── ... (all months) └── 2026/ └── ... (all months) Step 4: Test the Workflow 1. Activate the workflow 2. Submit a test expense through the form 3. Verify files are uploaded to correct locations 4. Check email notifications are received How to customize the workflow Expense Categories Modify the form dropdown options and conditional logic to add/remove expense categories: - Edit the "On form submission" node form fields - Update the IF condition nodes for routing - Add new processing paths as needed AI Processing Schema Customize the structured output parser schema to extract different fields: - Modify the JSON schema in the "Structured Output Parser" node - Update the AI system prompt for