FTP, CSV, and Slack: On-Demand Report Summary Template
A scheduled Spojit workflow that pulls the latest CSV report from an FTP folder, summarizes its row counts and totals, and posts a clean recap to Slack.
What It Builds
A Schedule trigger fires on your chosen cadence, a FTP connector node downloads the newest CSV from a folder, and a CSV connector node parses the rows. A Transform node tallies the row count and any numeric totals, then a Slack connector node posts the summary to a channel so the team sees the numbers without opening a file.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Build a scheduled workflow that runs every weekday at 8am, downloads the most recent CSV file from the /reports folder on my FTP server, counts the total rows and sums the amount column, then posts a summary to the #reports Slack channel showing the file name, row count, and total.
Connectors Used
- Schedule trigger - runs the workflow on a fixed cadence using a cron expression and time zone.
- FTP - lists the report folder and downloads the latest CSV file.
- CSV - parses the file into rows so totals can be calculated.
- Slack - posts the finished recap to your chosen channel.
Customize It
Change the schedule (for example to hourly or weekly), point the FTP path at a different folder, swap #reports for your channel, and name the columns you want summed or counted. You can ask for averages, top values, or a date filter directly in the prompt.
Tips
- Use Direct mode on the FTP and Slack nodes for predictable, lower-cost runs once the steps are fixed.
- Make sure your Slack connection has permission to post in the target channel.
- If filenames carry dates, tell Miraxa how to pick the newest one (by name or by modified time).