Use IFTTT to send currency exchange rate mail daily

Overview

Requirement

I want to have daily mail including currency exchange rate information.

  1. Mail subject: include the exchange rate in the mail subject.
  2. Mail content:
    1. Has some links to banks' exchange rate pages.
    2. Include some exchange rate history charts.

Solution

Use ifttt.com

  1. Create a new Applet on IFTTT

  2. Add a new "If This"

  3. Choose "finance" service

  4. Choose "Today's exchange rate report"

  5. Choose the input/output currency and trigger time.

  6. Add a new "Then That"

  7. Choose a "gmail" service

  8. If you just want to send yourself an email, you can click the right button. If you want to send to several recipients, you can click left button.

  9. This is an example to send yourself an email.

  10. This is my email body

     1As of {{CheckTime}}, 1 {{InputCurrency}} equals {{ExchangeRate}} {{OutputCurrency}}.<br>
     2<br>
     3via {{InfoUrl}}
     4
     5<b>美元匯率:</b>
     6<ul><li>
     7<a href="https://rate.bot.com.tw/xrt?Lang=zh-TW">即時</a>(台銀)&nbsp;
     8<a href="https://rate.bot.com.tw/xrt/quote/day/USD">當日</a>(台銀)&nbsp;
     9<a href="https://www.xe.com/currencycharts/?from=USD&to=TWD&view=1W">1周</a>(XE)&nbsp;
    10<a href="https://www.xe.com/currencycharts/?from=USD&to=TWD&view=1M">1個月</a>(XE)&nbsp;
    11<a href="https://rate.bot.com.tw/xrt/quote/ltm/USD">3個月</a>(台銀)&nbsp;
    12<a href="https://rate.bot.com.tw/xrt/quote/l6m/USD">6個月</a>(台銀)
    13</li><li>
    14<a href="https://rate.bot.com.tw/xrt/quote/l1y/USD">1年</a>(台銀)&nbsp;
    15<a href="https://www.esunbank.com.tw/bank/personal/deposit/rate/forex/exchange-rate-chart?Currency=USD/TWD">1年</a>(玉山)&nbsp;
    16<a href="https://www.xe.com/currencycharts/?from=USD&to=TWD&view=1Y">1年</a>(XE)&nbsp;
    17<a href="https://rate.bot.com.tw/xrt/quote/l3y/USD">3年</a>(台銀)&nbsp;
    18<a href="https://www.xe.com/currencycharts/?from=USD&to=TWD&view=5Y">5年</a>(XE)&nbsp;
    19<a href="https://www.xe.com/currencycharts/?from=USD&to=TWD&view=10Y">10年</a>(XE)&nbsp;
    20<a href="https://fxtop.com/en/historical-exchange-rates.php?A=1&C1=USD&C2=TWD&DD1=&MM1=&YYYY1=&B=1&P=&I=1&DD2=03&MM2=03&YYYY2=2099&btnOK=Go%21">1983~現在</a>(FXTOP)&nbsp;
    21</li><li>
    22<a href="https://historical.findrate.tw/USD/">1個月+1年+10年</a>(FindRate)
    23</li></ul><br/>
    24
    25<b>2022/1/1~2022/12/31:</b><br/>
    26<img src="https://fxtop.com/php/imggraph.php?C1=USD&C2=TWD&A=1&DD1=&MM1=01&YYYY1=2022&DD2=&MM2=12&YYYY2=2022&LANG=en&CJ=0&MM1Y=1&LARGE=&TR=OFF"><br/>
    27<b>2021/1/1~2022/12/31:</b><br/>
    28<img src="https://fxtop.com/php/imggraph.php?C1=USD&C2=TWD&A=1&DD1=&MM1=01&YYYY1=2021&DD2=&MM2=12&YYYY2=2022&LANG=en&CJ=0&MM1Y=1&LARGE=&TR=OFF"><br/>
    29<b>2020/1/1~2022/12/31:</b><br/>
    30<img src="https://fxtop.com/php/imggraph.php?C1=USD&C2=TWD&A=1&DD1=&MM1=01&YYYY1=2020&DD2=&MM2=12&YYYY2=2022&LANG=en&CJ=0&MM1Y=1&LARGE=&TR=OFF"><br/>
    31<b>2000/1/1~2022/12/31:</b><br/>
    32<img src="https://fxtop.com/php/imggraph.php?C1=USD&C2=TWD&A=1&DD1=&MM1=01&YYYY1=2000&DD2=&MM2=12&YYYY2=2022&LANG=en&CJ=0&MM1Y=1&LARGE=&TR=OFF"><br/
    

Mail sample

IFTTT applet location

This is my IFTTT applet: https://ifttt.com/applets/SxPJ2fpv-

About the exchange rate history chart

I only find 2 websites that provide exchange rate charts to embed in the mail content.

  1. https://fxtop.com/, it provides PNG format chart, I already include it in my IFTTT applet.
  2. https://www.currencyconverterrate.com/, it provides SVG format chart (ex: https://www.currencyconverterrate.com/currencycharts/usd/usd-twd-exchange-rates-history-chart-7-day.svg), but I cannot find a solution to show SVG in gmail. If you find a solution, please let me know, thanks.