| Runs | Every minute |
|---|---|
| Reads | Customer payment notification emails (e-transfer and pay-by-bank) |
| Matches | Pay-by-bank emails to the payment provider's API, conservatively, to fill in the contract number |
| Writes | New rows in a daily Excel workbook for the loan-management system (LMS), through Microsoft Graph |
| Protects | Against duplicates, with a processed-keys table |
| Tools | n8n, Microsoft Outlook, Microsoft Graph, SharePoint, JavaScript, OAuth 2.0 |
| Our part | The connection to the payment provider's API and the read-only transaction lookups. The flow was built by a member of the lender's team. |
| Status | Live in production |
What does it do?
- Polls the mailbox every minute for customer payment notification emails.
- Extracts the payer, amount and reference from each email.
- Matches pay-by-bank emails to the payment provider's API to fill in the contract number. Our part is this connection and its read-only lookups.
- Skips anything already added, using a processed-keys table.
- Appends new rows to the day's Excel workbook for the loan-management system, with a new workbook each business day.
What doesn't it do?
- Post into the loan system itself. It fills the daily workbook for the loan-management system.
- Force a match. Matching to the provider's records is conservative.
- Use AI.
Will it work with our loan management system (LMS)?
If your loan system can export a report or import a file, we can usually work with it. In this example the flow fills a daily Excel workbook for the loan-management system. Where the vendor's API isn't open to you, files are the route.
What would this look like at your lender?
If your payments arrive as notification emails, we can build the whole flow for you, including the kind of payment provider connection we built here. In the free prototype we'd use a few of your real notice formats with customer details removed, your workbook template and your daily cutoff, and show it filling a test workbook from a test inbox.
- Notices copied into Excel, no reconciling: Outlook to Excel are both well-known apps with ready-made connectors, so this can be a standard automation at $499.
- Pay-by-bank payments reconciled to contract numbers against your payment provider: a custom build, fixed in writing after the prototype, from $995.
- Watching it for you: $99 a month for monitoring, fixes and small changes, month to month.
Customer names and amounts will pass through your workflow, so on your build we'd set the platform to keep its run history only as long as you need it, and we'd agree with you how many transactions a day it must handle.