Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Loop Over Items
  2. OpenAI Chat Model
  3. Calculator
  4. Structured Output Parser
  5. On Email receipt
  6. Get Filename and mimeType
  7. Filter ZIP files only
  8. Unzip Invoice
  9. Just for style
  10. Get filename and mimeType on extracted docs
  11. Split XML and PDF
  12. Extract PDF Data
  13. Extract XML Data
  14. Convert to JSON

29 steps in total.

Similar automations