Schedule icon
Request icon
Log icon
Write icon
Query icon
If icon

Daily Exchange Rates to Push Notification with ntfy

Fetch daily ECB exchange rates from the free Frankfurter API, save them as CSV, summarize with DuckDB and push the report to your phone with ntfy.sh.

Categories
BusinessCore

Get the daily exchange rates on your phone without any account, API key or secret. This blueprint calls the free Frankfurter API (ECB reference rates), saves the rates into a CSV file, finds the highest and lowest rate with an in-memory DuckDB query and publishes the report as a push notification through ntfy.sh. A conditional step skips the notification on days when the ECB published no new rates, such as bank holidays.

How it works

  1. The weekday_schedule trigger (io.kestra.plugin.core.trigger.Schedule) runs the flow every weekday at 16:30 Budapest time, after the ECB publishes its rates.
  2. fetch_rates (io.kestra.plugin.core.http.Request) calls the Frankfurter API for the base and symbols inputs, with exponential retries.
  3. log_report (io.kestra.plugin.core.log.Log) parses the JSON with fromJson() and writes the rates into the execution log.
  4. save_csv (io.kestra.plugin.core.storage.Write) stores the rates as a CSV file in internal storage.
  5. summarize_rates (io.kestra.plugin.jdbc.duckdb.Query) reads the CSV in memory and returns the highest and lowest rate.
  6. check_fresh_rates (io.kestra.plugin.core.flow.If) compares the rate date with today's date. If the rates are fresh, or force_notify is true, send_notification posts the report to ntfy.sh. Otherwise log_stale_rates logs a warning.

What you get

  • A weekday push notification with the latest exchange rates and the highest and lowest rate.
  • A CSV file with the rates, downloadable from the execution outputs.
  • No duplicate notifications on days without new ECB data.

Who it's for

  • Finance and treasury teams who want a lightweight daily FX rate check.
  • Freelancers and small businesses invoicing in foreign currencies.
  • Anyone new to Kestra who wants an HTTP, DuckDB and conditional-branching example without any credentials.

Why orchestrate this with Kestra

A cron job with curl has no retries, no run history and no place to keep the CSV. Kestra gives the pipeline scheduling, retries, conditional branching, file outputs and a full execution history in one declarative flow.

Prerequisites

  • A private topic name on ntfy.sh and the ntfy app on your phone, subscribed to that topic. Anyone who knows the topic can read it, so pick a long random name.
  • No secrets are required.

Inputs

  • base (STRING, default EUR): base currency.
  • symbols (STRING, default HUF,USD,GBP,CHF,PLN): currencies to compare against the base.
  • ntfy_topic (STRING): your private ntfy.sh topic.
  • force_notify (BOOL, default false): send the notification even without new rates.

Outputs

  • rates_file: CSV file with the rates, available as {{ outputs.save_csv.uri }}.

Quick start

  1. Install the ntfy app and subscribe to your own topic.
  2. Set the ntfy_topic input default to that topic.
  3. Click Execute with force_notify set to true and check your phone.
  4. Leave the weekday_schedule trigger enabled for daily reports, or set disabled: true to run the flow manually only.

How to extend

  • Change base and symbols to track other currencies.
  • Swap the ntfy request for Slack, Discord or email notifications.
  • Append each CSV to a warehouse table to build a rate history.
  • Add an alert when a rate moves more than a threshold compared with the previous day.

Links

Orchestrate with Kestra
Orchestrate DuckDB with Kestra
Share this Blueprint
See How

New to Kestra?

Use blueprints to kickstart your first workflows.