Workflow
How it works
1. A daily schedule starts the template. 2. An HTTP request asks the exchange-rate API for the latest rates of the base currency (put your API key in the URL). 3. Parse JSON turns the answer into fields. 4. Google Sheets writes the update time, base currency and the EUR, GBP, ILS and JPY rates into the rate row of your sheet. 5. Choose the spreadsheet and sheet when you install the template and add more currencies as extra columns if you need them.