Connector

Send Open Exchange Rates data to Google Sheets

Load Open Exchange Rates into your data warehouse first, join them to orders and invoices by date and currency, then send the converted answers to Google Sheets on a schedule. The sheet stays tied to your source of truth, not to an App ID.

Open Exchange R…ConnectedHistorical excha…
Data MartPublishedone definition
Google SheetsDateBaseCurre…Daily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get Started Free

Hand this to your AI

Rates pasted into a sheet convert one report once, and nobody can tell later which rate it used.

Paste this into your AI assistant. It loads Open Exchange Rates into your data warehouse, joins them to orders and invoices by date and currency in a Data Mart, and sends converted figures to your sheet on a schedule.

The prompt

send a monthly Google Sheets report of our invoices converted to EUR at each invoice date's rate, showing the original currency, the rate and the converted amount

Endpoints

Open Exchange Rates Endpoints

Documentation

1 Open Exchange Rates endpoints you can import. Each lands in its own table in your data warehouse.

S00 · Why

Why Open Exchange Rates does not go straight to Google Sheets

Rates copied into a sheet convert one report once. They do not say which rate each report used, because orders, invoices and rates live in different systems. A sheet is not built to join them reliably, at scale or business-ready, so the join happens in a data warehouse first.

  • Open Exchange Rates reports the rate, not how your numbers use it
  • The data analyst joins rates to orders and invoices by date and currency and controls the result
  • Stakeholders keep the sheet they like, now on one currency basis
Open Exchange…Rates by currency
Google Sheets
No link to revenue
Data warehouseJoined by id
OrdersOrder totals
InvoicesBilling, currency

S01 · Step 1

Step 1: Load Open Exchange Rates into your data warehouse first

Create a Data Mart with Open Exchange Rates as the data source and choose where the data lands. It works with any popular data warehouse.

  • One endpoint, Historical exchange rates data, with four fields: date, base, currency and rate
  • Authorize with your Open Exchange Rates App ID
  • Open the Open Exchange Rates connector for your data warehouse below
Open Exchan…Data Mart
Your data warehouseGoogle BigQueryAWS AthenaSnowflakeAWS RedshiftDatabricks
open_exchange_rates.historical

S03 · Step 3

Step 3: Send Open Exchange Rates data to Google Sheets

Connect a Google Sheets report to the Data Mart. Aliases and field descriptions arrive as notes in the column headers, so everyone reads the same definitions.

  • The sheet reads your data warehouse, not the Open Exchange Rates API
  • Hover a header to see what currency or rate means
Google SheetsNotes in headersdatecurrencyrate
currencyTarget currency
rateExchange rate

S04 · Step 4

Step 4: Refresh your Open Exchange Rates sheet on a schedule

Set a scheduled refresh once. Daily is the usual choice and hourly is possible when you need it.

  • Every refresh is logged in Run History
  • List the currency codes once; a base other than USD needs the Developer plan or higher
ScheduleRefresh on a scheduleHourlyDailyDaily 09:00
Google SheetsUpdated
Run HistoryReport refreshedReport refreshedReport refreshed

S05 · Step 5

Step 5: Reuse Open Exchange Rates inside OWOX MCP

The same Data Mart works in OWOX MCP, your AI assistant for data. Request any report, chat with your data, then get the report in Google Sheets or Excel in one click.

  • Ask in plain words; the answer comes from your data warehouse
  • Define the numbers once and every report reads them
OWOX MCPShow settled_revenue by currency and monthsettled_revenue
Google SheetsOpen
ExcelOpen

Recent updates

Why OWOX

Why OWOX for Open Exchange Rates in Google Sheets

Hand-built API scripts and add-ons that pull straight from Open Exchange Rates get numbers into a sheet. OWOX also keeps the data yours, linked and ready to model.

  • You own the data. It lands in your own data warehouse, in tables you control.
  • One rate for every report. Orders and invoices convert with the same Open Exchange Rates table, by date and currency.
  • Currency logic defined once. The conversion lives in a Data Mart, not in a cell someone typed.
  • Sheets stay in sync. Notes in the headers, a schedule you set once, no API token to fix in the sheet.
  • Maintained for you. No scripts to repair when Open Exchange Rates changes how it serves data.

Book a callGet Started Free

Trust

The Data Partner You Can Trust

users

166K Source: Internal OWOX data as of 2026-11-15

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers