Automate Telr Payment Reports: SQL Insertion & Email Alerts

Transform your Telr payment gateway reporting from manual drudgery into a fully automated system that fetches transaction data, stores it in your database, and keeps your team informed via email notifications—all running seamlessly in the background.

What this workflow does

This comprehensive n8n automation handles the complete Telr payment report lifecycle without any manual intervention. The workflow triggers on your defined schedule, makes two strategic API calls to Telr (first for raw data, then filtered by date range), processes the downloaded XLS files through decompression and data extraction, transforms records using custom JavaScript logic, inserts everything into your SQL database, and sends success confirmations via email. Every step is orchestrated to ensure your payment data flows smoothly from Telr's servers into your business systems.

Use cases

• Daily payment reconciliation: Automatically sync yesterday's transactions into your accounting database every morning
• Financial reporting automation: Keep your finance team updated with processed payment data without manual downloads
• Business intelligence feeds: Populate your analytics dashboards with fresh Telr transaction data
• Compliance documentation: Maintain automated records of all payment gateway transactions for audit trails

Technical details

Built with essential n8n nodes including Schedule Trigger for automated execution, dual Telr API integrations for comprehensive data retrieval, XML to JSON conversion for seamless processing, compression handling for file extraction, JavaScript code nodes for custom business logic transformation, SQL database insertion capabilities, and email notification system for operational visibility.

Setup requirements

You'll need your Telr API credentials (store ID and API key) configured in n8n's credential system, plus access to a SQL database where transaction records will be stored. The workflow is designed for merchants, developers, and finance analysts who want to eliminate manual Telr report processing while maintaining complete visibility into their payment data pipeline.