Latenode
Tools
JavaScript
Google sheets

FX rates to spreadsheet

Use the Tools scheduler to wake the workflow, call Frankfurter and open.er-api from JavaScript (HTTP fetch), merge quotes, and write a dated row to Google Sheets. No mystery middleware—just schedule, code, and Sheets.

Updated May 8, 2026Est. run: 7sEst. cost: $0.0004
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Finance & exchange rates

Workflow preview

What this template does

  • Explicit public API endpoints in JavaScript.
  • Sheets is the warehouse finance teams can chart.
  • Tools trigger documents when pulls happen.

How it works

1
Trigger

Timer

Tools kicks off the job.

2
Logic

HTTP fetch

JavaScript pulls JSON from both APIs, handles failures.

3
Action

Write row

Sheets stores the snapshot.

Setup guide

1

Connect Google Sheets

Target spreadsheet + tab for FX history.

2

Set Tools schedule

Align with market open/close needs.

3

Code retries

Handle 429/5xx with exponential backoff in JavaScript.

Requirements

Outbound HTTPS allowed from Latenode to the FX endpoints
Google Sheet with columns for date, pairs, values
Understanding of API attribution requirements

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Finance & exchange rates

Automatically sync Airtable data to ExRt.Live for live exchange rates

This Latenode automation template allows users to automatically sync new or updated records from Airtable, a popular cloud-based spreadsheet and database platform, to ExRt.Live, a live currency and cryptocurrency exchange platform. This integration enables finance professionals and traders to keep their exchange rate data up-to-date in real-time, streamlining their workflow and ensuring they have access to the latest market information. The automation simplifies the process of managing exchange rate data, reducing manual effort and improving data accuracy.

7s$0.0005
Finance & exchange rates

Sync live exchange rates to Google Sheets for accurate invoicing

This workflow automates the process of fetching live currency exchange rates from the ExchangeRate API and updating a Google Sheet with the latest values, ensuring accurate currency conversions for finance teams, analysts, and anyone working with spreadsheets who needs up-to-date exchange rate data. It retrieves the rates daily, stores the latest data in a 'Rate Sheet' tab, and archives historical records in an 'Archives' tab, all without requiring any manual intervention or code writing.

12s$0.0008
Integrations & automation

Site monitor to RSS

Tools schedules checks, Headless Browser loads each monitored URL, JavaScript diffs visible text or selectors against the last snapshot in Database, and rss.app (or JavaScript POST) publishes feed items when changes exceed your threshold. Replaces Zapier+rss.app-only diagrams with explicit Latenode nodes.

9s$0.0006