Latenode

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 Apr 13, 2026Est. run: 26sEst. cost: $0.0703
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.

More templates

You might also like

Browse all templates →
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.

7s$0.0004
Calendar & scheduling

Sync Gmail emails to Google Calendar and create events

This Latenode automation allows users to automatically create Google Calendar events directly from their Gmail emails. By enabling the 'Events from Gmail' setting or manually selecting 'Create event' from the 'More' menu within an email, users can seamlessly schedule events and appointments based on reservation details or travel information received through their email. This integration between Gmail and Google Calendar streamlines the scheduling process, saving users time and ensuring their calendar stays up-to-date with their upcoming commitments.

26s$0.0703
Integrations & automation

Automatically translate new Discord messages using Google Cloud Translate

This automation integrates Discord and Google Translate to monitor specific Discord channels for new messages. When a new message is detected, the automation will automatically translate the text into a target language using Google Translate and then post the translated message back to Discord or another destination. This allows users to stay connected with their communities across language barriers, facilitating global collaboration and discussion within the Discord platform.

26s$0.0703