This template runs on a schedule, fetches JSON from the public Frankfurter and open.er-api endpoints in JavaScript, merges quotes, and writes a dated snapshot as a new row in Google Sheets. Those FX endpoints do not need an API key unless you switch to a paid provider. Connect Google Sheets and set the interval and timezone on the schedule.
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 →Workflow preview
A schedule starts the scenario at the interval and timezone you set.
JavaScript requests Frankfurter and open.er-api, merges pair rates, and handles HTTP errors.
Google Sheets writes date, pairs, values, and source notes as a new row.
Add a schedule. Choose daily or market-hours timing in your timezone.
Add a JavaScript node. Get JSON from the public Frankfurter and open.er-api URLs, merge quotes, and retry or skip on HTTP errors.
Add a Google Sheets connection. Add a new row on a tab with columns for date, pairs, values, and source.
FAQ
More templates
This template watches an Airtable table for new or updated currency rows and posts those fields to ExRt.Live. Airtable starts the run. JavaScript maps pair, rate, and timestamp, then calls the ExRt.Live API with your key in that node. Connect Airtable, pick the base and table, and put the ExRt.Live API key in the JavaScript node.
Manually copying form responses into your CRM wastes time and risks errors. This integration captures each New Submission event from 123FormBuilder and uses it to Create a Lead in Insightly, mapping the respondent's name, email, and custom fields directly into a new lead record. Marketing managers and sales teams can eliminate data entry and get leads into Insightly instantly for follow-up. By connecting 123FormBuilder's form capture with Insightly's CRM, you keep your sales pipeline fed without manual work.
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.
