Log JPY daily to Google Drive
If
Today's exchange rate report
This Trigger retrieves today's current exchange rate for any two currencies at the time you specify.
Then
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Explore more great ways to automate Google Sheets and Finance