Automate Receipt Verification with OpenAI, Slack, & Google Sheets

Automate Receipt Verification with OpenAI, Slack, & Google Sheets

Elevate your financial automation processes with the power of the "Automate Receipt Verification with OpenAI, Slack, & Google Sheets" workflow. Seamlessly verify invoice data, ensure accuracy with AI-powered extraction, and streamline collaboration through automated Slack notifications—all while maintaining an organized audit trail in Google Sheets. Perfect for n8n users aiming to enhance productivity with cutting-edge automation technology.

What this workflow does

• Receives Uploads: Initiates with a POST webhook request that includes an invoice image URL along with associated booking metadata like expected amount and currency.
• Data Normalization: Transforms incoming data into standardized fields such as document ID, booking/guest IDs, and expected values for consistency.
• AI-Powered Extraction: Utilizes OpenAI’s Vision via the Chat Model to extract crucial details including vendor, date, total, currency, and line items with confidence scores. Defaults to an ERROR verdict if extraction is unsuccessful.
• Verdict Validation: Analyzes the extracted data, checking the confidence levels and ensuring total and currency alignment with expected values to determine a verdict: APPROVED, REVIEW, or REJECTED.
• Slack Notifications: Flags non-APPROVED documents by posting detailed validation reasons to a designated Slack channel for prompt review.
• Tracking & Reporting: Logs every verification result into Google Sheets and provides a JSON response to the webhook caller, encapsulating document ID, verdict, and reasons.

Use cases

• Finance Automation: Perfect for finance teams aiming to automate receipt verification, reducing manual entry errors and improving workflow efficiency.
• Remote Auditing: Facilitates swift and accurate auditing processes by providing instant reviews and decisions based on AI-analyzed data.
• Compliance and Record-Keeping: Ensures all financial records are meticulously logged and accessible, enhancing compliance efforts.

Technical details

• Built with n8n using nodes: If, Code, Slack, Webhook, Sticky Note, Error Trigger
• Integrates OpenAI for vision-based data extraction
• Connects with Slack for real-time notifications and Google Sheets for result tracking