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 runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. 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 CPU seconds 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
CRM & sales

Create a Pipeline deal from a new Discord channel message

Sales teams often miss leads buried in Discord conversations. This scenario captures every new message in a chosen Discord channel and creates a corresponding deal in Pipeline, using the message text as the deal description and the author's username as part of the deal name. Sales managers and business development reps can log inbound signals from team discussions directly into Pipeline CRM without manual data entry. The connection turns Discord into a lead source, so no opportunity slips through the cracks.

8s~$0.002
CRM & sales

Create a Pipeline deal when a new HubSpot deal is added

Manually copying deal data from HubSpot to Pipeline wastes time and risks errors. This automation triggers on the New Deal event in HubSpot and then runs the Create Deal action in Pipeline, mapping the deal name, amount, and associated contact email and name. Sales operations teams and CRM administrators who use both HubSpot and Pipeline can eliminate duplicate data entry. HubSpot captures the initial deal, and Pipeline receives a matching record immediately, so both systems stay aligned without manual work.

8s~$0.002