Auto Expense Tracker From Line Messages With Gpt 4 And Google Sheets 6264 – n8n Workflows – Free Template

What This Workflow Does

The Special Tracker Share workflow automates the extraction and validation of expense records and invoices. It intelligently filters incoming data to ensure only bookkeeping-related content is processed, then extracts key financial information and stores it in Google Sheets for centralized tracking and analysis.

How It Works

This workflow follows a systematic process to handle financial data:

• A webhook receives incoming data from external sources
• The workflow immediately validates whether the input is expense or invoice-related content
• Non-bookkeeping data is rejected and processing stops automatically
• Valid expense records are processed through an AI agent powered by OpenAI’s language model
• Six critical data fields are extracted: Date, Channel, Channel Type, Amount, Vendor, and Category
• Extracted data is structured and formatted consistently
• Information is merged and aggregated for quality assurance
• Validated records are automatically written to Google Sheets for permanent storage and reporting

Use Cases

• Invoice Processing: Automatically extract vendor information, dates, and amounts from received invoices without manual data entry
• Expense Report Automation: Process employee expense submissions by extracting dates, channels, and amounts for reimbursement tracking
• Multi-Channel Expense Tracking: Consolidate expenses from various channels (online, in-store, digital payments) into a single organized spreadsheet
• Real-Time Financial Monitoring: Maintain up-to-date expense records by automatically logging transactions as they occur
• Vendor and Category Management: Organize and categorize business expenses for accurate financial reporting and budget analysis

Nodes Used

• Webhook: Receives incoming data triggers from external applications
• Set: Configures variables and prepares data for processing
• HTTP Request: Makes API calls to retrieve or send data as needed
• @n8n/agent: Orchestrates the AI-powered extraction logic
• @n8n/lmChatOpenAi: Leverages OpenAI’s language model for intelligent data extraction
• Google Sheets: Stores extracted records in a structured spreadsheet format
• Merge: Combines data from multiple processing paths
• @n8n/outputParserStructured: Formats extracted data into consistent structured fields
• Aggregate: Consolidates and validates data quality before final storage
• Sticky Note: Provides workflow documentation and processing notes
• Switch: Routes data based on validation rules and relevance checks

Prerequisites

• An active n8n instance with webhook capabilities enabled
• OpenAI API key for language model access and data extraction
• Google Sheets connected through n8n’s Google Sheets integration
• A target Google Sheet with columns for Date, Channel, Channel Type, Amount, Vendor, and Category
• Understanding of bookkeeping terminology to configure relevance filters
• Basic familiarity with n8n workflow construction and node configuration

Difficulty Level

Intermediate to Advanced: This workflow requires understanding of AI-powered data extraction, API integrations, and conditional logic. Users should be comfortable with webhook configuration, OpenAI API setup, and Google Sheets integration. Customization may be needed for specific business requirements and expense categories.

This workflow template is shared under the n8n fair-code license. Free to use and modify.