FTP and Knowledge: Spreadsheet Embed and Query Template

On a schedule, this template pulls Excel and CSV files from an FTP folder, embeds them into a persistent Knowledge collection, and lets downstream workflows answer questions over the tabular data in plain language.

What It Builds

A Schedule trigger fires on your chosen cron interval and a FTP connector node lists and downloads the spreadsheets waiting in a folder. A Knowledge node in Embed mode adds each file to a named, persistent collection so the tabular content stays searchable across runs. Later, any workflow can use a Knowledge node in Query mode to ask questions over that data and get natural-language answers back.

The Prompt

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

Build a workflow that runs every morning at 6am, downloads all the Excel and CSV files from the /reports folder on my FTP server, and embeds them into a persistent Knowledge collection called "sales-data" so I can later ask questions about the numbers in plain language.

Connectors Used

Schedule trigger - runs the workflow on a cron interval in your timezone.
FTP - lists and downloads the Excel and CSV files from a server folder.
Knowledge - embeds the files into a persistent collection, then answers questions over them in Query mode.

Customize It

Change the cron time, the FTP folder path, and the collection name directly in the prompt. You can also narrow the file types (CSV only), add a Query step that emails a daily summary, or point a separate workflow at the same collection so several teams share one source of truth.

Tips

Use a persistent collection (not Transient) so the embedded data survives between runs and stays queryable.
Give the FTP connection read access to the target folder, and move processed files aside so the same rows are not re-embedded each run.
For querying, a Knowledge node in Query mode with a Response Schema returns clean structured JSON instead of free text.