FTP and Slack: Daily Reconciliation File Check Template

A scheduled workflow that checks your FTP folder each morning for the expected daily settlement file and posts a clear confirmation or a missing-file alert to Slack, so reconciliation never stalls on a file nobody noticed was late.

What It Builds

A Schedule trigger fires every morning before your finance team starts. A FTP Connector node lists the target folder and checks whether today's settlement file has landed. A Condition node then branches: if the file is present, a Slack Connector node posts a confirmation with the file name and size; if it is missing or late, Slack posts an alert so someone can chase it before reconciliation begins.

The Prompt

Paste this into Spojit's Miraxa and it builds the workflow, connecting the tools for you:

Build a workflow that runs every weekday at 7am and checks an FTP folder for today's settlement file named like settlement-YYYY-MM-DD.csv. If the file exists, post a confirmation to the #reconciliation Slack channel with the file name and size. If it is missing, post an alert to #reconciliation saying the daily settlement file has not arrived yet.

Connectors Used

Schedule trigger - runs the check each morning on a cron schedule in your timezone.
FTP - lists the folder and confirms whether the expected file has arrived.
Slack - posts the confirmation or the missing-file alert to your channel.

Customize It

Change the run time and days in the prompt, the folder path and the file-name pattern (the date format matters), and the Slack channel. You can also raise the alert urgency by mentioning a person or group, or add a second Slack message when the file arrives unusually late.

Tips

Give the FTP connection read access to the exact settlement folder; a wrong path reads as a missing file.
Use Direct mode on the FTP and Slack nodes for a fixed, no-AI-cost check that runs the same way every day.
Account for weekends and holidays in the schedule so you do not get false alerts when no file is expected.