Skip to content

Automated checking and reporting of JPY to EUR exchange rate using GitHub Actions.

License

Notifications You must be signed in to change notification settings

PanosChatzi/yen_rate_automation

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

32 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

JPY to EUR Exchange Rate Checker

This GitHub Actions workflow fetches the latest JPY to EUR exchange rate every Monday at midnight (UTC) and sends an email notification if the rate falls below a specified threshold.

πŸš€ How It Works

  1. Fetches the JPY to EUR exchange rate from ExchangeRate-API.
  2. Logs the exchange rate and compares it to the previous value.
  3. Sends an email alert if the rate is below the set threshold.

πŸ›  Setup Instructions

1️⃣ Add Secrets to GitHub

Go to Settings β†’ Secrets and variables β†’ Actions β†’ New repository secret, and add:

Secret Name Description
EXCHANGE_API_KEY API key for exchange rate service (if needed)
SMTP_USER Your SMTP email address
SMTP_PASSWORD Your SMTP email password (or app password)
SMTP_SERVER SMTP server address (e.g., smtp.gmail.com)
SMTP_PORT SMTP port (e.g., 587 for TLS)
RECIPIENT_EMAIL The email address to receive alerts
PRICE_THRESHOLD The exchange rate threshold for alerts (e.g., 0.0065)

3️⃣ Manually Trigger the Workflow

You can also run the workflow manually:

  1. Go to Actions in your GitHub repository.
  2. Select Weekly JPY to EUR Rate Check.
  3. Click Run workflow.

πŸ”§ Dependencies

The R script requires:

  • httr
  • jsonlite
  • emayili

These are automatically installed when the workflow runs.


πŸ“„ Logs & Debugging

  • Exchange rates are logged in exchange_rate_log.txt.
  • To debug, check the GitHub Actions logs under Actions β†’ Workflow Runs.

πŸ“§ Email Notifications

  • If the exchange rate falls below the threshold, an email is sent.
  • The email includes the current rate and percentage change from the last logged value.

πŸ† Future Improvements

  • βœ… Add more exchange rate APIs for redundancy.
  • βœ… Improve email formatting.
  • πŸ—„ Store logs in a more structured format (e.g., CSV or database).

🌟 License

This project is open-source under the MIT License.

About

Automated checking and reporting of JPY to EUR exchange rate using GitHub Actions.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages