Library / Documents, PDF & OCR
Documents, PDF & OCR
Process Colombian Invoices from Gmail with OpenAI
When an email arrives with invoices, it filters ZIP files, has OpenAI extract the fields, files them in Google Drive and logs to Sheets.
What it does
# Colombian Invoices Processing ## Overview Automated workflow: Colombian Invoices Processing. This workflow integrates 19 different services: stickyNote, merge, switch, lmChatOpenAi, xml. It contains 29 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 29 - Node Types: 19 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - Loop Over Items: splitInBatches - OpenAI Chat Model: lmChatOpenAi - Calculator: toolCalculator - Structured Output Parser: outputParserStructured - On Email receipt: gmailTrigger - Get Filename and mimeType: code - Filter ZIP files only: filter - Unzip Invoice: compression - Just for style: noOp - Get filename and mimeType on extracted docs: code - ... and 19 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible
The steps
- Loop Over Items
- OpenAI Chat Model
- Calculator
- Structured Output Parser
- On Email receipt
- Get Filename and mimeType
- Filter ZIP files only
- Unzip Invoice
- Just for style
- Get filename and mimeType on extracted docs
- Split XML and PDF
- Extract PDF Data
- Extract XML Data
- Convert to JSON
29 steps in total.
Similar automations
Finance, Invoices & AccountingProcess Colombian Electronic Invoices with OpenAI22 stepsDocuments, PDF & OCRColombian Invoices Processing23 stepsFinance, Invoices & AccountingGet the Colombian Peso TRM Exchange Rate via Telegram29 stepsDocuments, PDF & OCRProcess Google Keep Takeout JSON Notes from Drive with OpenAI into Sheets13 steps