Keep your finance sheet current without manual work. A daily run collects the latest USD exchange rates, updates an invoice sheet, and records a full history for audits and reporting. Ideal for teams that bill in USD and need reliable daily rates for quotes and invoices.

At 8 am, a schedule starts an API call to fetch USD rates. A small code step reshapes the response into a flat JSON list of currencies. A field filter pulls base currency and the update time. A merge step combines these details, then one Google Sheets step updates your invoice template while another appends the full set of rates to an archive sheet. You get a fresh figure for the day and a clean log of prior days in the same file.

Setup needs an ExchangeRate API key and Google Sheets access in n8n Cloud. Expect less manual copying, fewer mistakes, and faster quotes. Helpful for daily invoicing, budget checks, and monthly close where you need a clear audit trail of historical rates.

• Daily schedule at 8 am to run the rate refresh automatically
• HTTP request to fetch the latest USD exchange rates from the API
• Code step flattens conversion rates into a simple JSON map
• Field filter extracts base currency and the last update time
• Merge step combines metadata with the full currency list
• Google Sheets update writes the current rate and timestamp to the invoice sheet
• Google Sheets append adds a new row of all rates to the Archives sheet

• Reduce manual work from 30 minutes to 2 minutes per day
• Improve data accuracy by 90 percent by removing copy paste
• Keep a daily audit trail of rates in one archive sheet
• Handle over 100 currencies with one API call
• Connect API data to Google Sheets every morning without reminders

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and ExchangeRate API. See the Tools Required section above for links to create accounts with these services.
3. Open the HTTP Request node. Replace the placeholder in the URL with your ExchangeRate API key. If you prefer credentials, double click the node, create a new credential, and follow the on screen steps.
4. Test the HTTP Request node by clicking Execute Node. You should see a JSON object that includes conversion_rates and base_code.
5. Open the Code node and keep the default script that outputs the conversion_rates map. Run the node to confirm a flat list of currency keys and values.
6. Open the Set node named Filter Fields and verify it maps base currency and update time fields. Make sure the field names match the headers you plan to use in Google Sheets.
7. Open the Google Sheets node named Update Rate Sheet. In the credentials dropdown, click Create new credential, sign in with your Google account, and allow access. Select your spreadsheet by URL or ID and choose the invoice sheet. Use the Update operation and set a match column that identifies the row to update such as base_currency.
8. Open the Google Sheets node named Archive Rates. Use the same credential. Select the same spreadsheet and pick the Archives sheet. Keep the Append operation and confirm the sheet has headers for base_currency, time, and currencies you want to store.
9. Run the full workflow once. Check the invoice sheet for the current rate and timestamp. Check the Archives sheet for the new row of daily rates.
10. Open the Schedule Trigger node and confirm the time and timezone match your team. Adjust the hour if you want a different local run time.
11. If you see a 403 or permission error in Google Sheets, make sure the Google account used in n8n has edit access to the file. Share the sheet with that account if needed.
12. If the API call fails, verify the API key value and quota on the ExchangeRate API dashboard. Fix the key and test again.
13. Activate the workflow so it runs every morning. Monitor executions in n8n and review logs if any step fails.