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).

Related

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.