Free Open Exchange Rates to Google Sheets Connector by OWOX: Own Your Currency Data, Automate Your Insights
Easily import exchange rate data into Google Sheets with this free, customizable connector.
Tracking currency in Open Exchange Rates is straightforward. Getting those rates into Google Sheets without copy-pasting CSVs or wrestling with API scripts? That’s the headache.
If you’ve ever scrambled to update exchange-rate tables by hand, you know the drill: stale numbers, broken formulas, and wasted hours every reporting cycle.
That ends today.
With the free, no-code Open Exchange Rates → Google Sheets connector from OWOX (Community Apps Script Edition), fresh FX data streams straight into your spreadsheet on schedule. In just a few clicks, you can import, refresh, and manage live currency rates - keeping finance and analytics teams fully in control, minus the manual work and extra fees.
Why We Made This Free Connector
Currency data powers everything from e-commerce pricing to global revenue reports, but accessing live exchange rates in a flexible, analyst-friendly format isn’t always easy.
At OWOX, we believe analysts and finance teams shouldn’t have to rely on manual downloads, paywalled tools, or black-box integrations just to get the data they need. That’s why we created this free Open Exchange Rates connector as part of the OWOX Data Marts (Community Apps Script Edition).
No subscriptions. No hidden limits. Just transparent, reliable access to exchange rate data in Google Sheets, where you can build models, automate workflows, and track FX changes on your terms.
Whether you’re managing pricing strategies, monitoring multi-currency trends, or blending exchange rates into broader business reports, this connector puts you in complete control.
Join the Open-Source Movement
We’re not just releasing a free connector, we’re inviting you to help shape the future of open marketing analytics tools.
At OWOX, we believe that data access and transparency should be a right, not a luxury. That’s why this connector is 100% open-source, giving you full control over how it works, what it does, and how far it can go.
If you like what we do, please ⭐ star our GitHub repo to show your support – it helps us reach more analysts and grow the number of available connectors.
Also, feel free to:
- Explore the code and customize it to fit your needs.
- Contribute to this data connectivity ecosystem by suggesting new connectors, pulling new connectors, and / or providing documentation to support the wider community.
- Join our community & share your feedback.
We’ve built the core, the foundation; now it’s your turn to take it further.
Why Bring Open Exchange Rates Data into Google Sheets?
Open Exchange Rates provides reliable FX data, but the native platform isn’t built for custom workflows or real-time financial modeling. That’s where this connector makes a difference.
❌ Static dashboards make it hard to analyze trends across time or currencies
❌ Manual downloads slow down reporting and increase the risk of errors
❌ Paid platforms often restrict access based on usage, features, or support
✅ With Google Sheets, you’re free to model currency data however you need, no platform limits
✅ Blend exchange rates with sales data, forecasts, or country-level metrics for deeper insights
✅ Automate updates and share reports with your team in minutes, no coding or exports needed
Using this free OWOX connector, you can bring exchange rate data straight into Google Sheets, fast, flexible, and fully transparent.
Why Choose the OWOX Connector for Open Exchange Rates to Google Sheets
With the OWOX connector, you get more than just a data pipeline; you gain complete control over your exchange rate data directly inside Google Sheets.
Unlike third-party tools that impose pricing tiers, usage caps, or rigid interfaces, this solution is fully open-source and script-based.
- Built with Google Apps Script – runs entirely in your spreadsheet, with no external tools or hosted services
- Full transparency – inspect, modify, or extend the script logic to fit your reporting and modeling needs
- Lightweight setup – easily define your date range, currency symbols, and refresh parameters in minutes
- Always free – no subscriptions, usage fees, or field restrictions
Whether you’re building custom dashboards, automating daily FX tracking, or feeding live exchange rates into other models, the OWOX connector provides a flexible and reliable foundation, all within Google Sheets.
Check out our other free connectors:
If you're enjoying seamless currency data in Google Sheets, explore these additional integrations:
Open Exchange Rates → BigQuery
Microsoft Ads → Google Sheets
Criteo Ads → Google Sheets
LinkedIn Ads → Google Sheets
All zero cost, no code required, just smarter workflows across your data ecosystem.
How the Connector Works
We built the OWOX Open Exchange Rates connector to simplify access to global currency data, without requiring third-party platforms, CSV exports, or coding skills.
It’s powered by OWOX Data Marts (Community Apps Script Edition) and runs entirely inside your own Google Sheets environment.
Here’s what it does behind the scenes:
- Uses native Google Apps Script to run securely inside your spreadsheet.
- Connects directly to the Open Exchange Rates API using your App ID, no middle layers or hidden services.
- Let you define your start date and select specific currency symbols to fetch, so you get exactly the data you need.
- Imports historical and current exchange rates into a structured “Data” tab for easy use in financial models or reports.
- Supports safe data cleanup by removing older rows if needed, keeping your Sheet responsive and organized.
With full visibility into how it works, this connector gives you reliable access to accurate currency data and the flexibility to adapt it to any use case, from pricing strategies to market dashboards.
Step-by-Step: Import Open Exchange Rates Data into Google Sheets
Getting currency data into Google Sheets is simple with the OWOX connector. In just a few steps, you’ll be streaming structured exchange rate data directly into your spreadsheet.
Step 1: Copy the Google Sheets Template ( ~1 min)
To streamline the setup process, use our pre-configured Google Sheets template; no need to build from scratch.
- Access the Template
- Open the “Open Exchange Rates → Google Sheets Template” from OWOX.
- Create a Personal Copy
- Go to File → Make a copy to save it to your Google Drive.
.png
)
Step 2: Configure the Template ( ~1 min)
Once you’ve copied the Open Exchange Rates Google Sheets template, head to the Config tab to configure key import parameters.
- Set the Start Date
- Pick the date from which you want to begin fetching historical exchange rate data.
Note: A wide date range may result in slower imports, depending on API limits.
- Pick the date from which you want to begin fetching historical exchange rate data.
- Define Symbols
- Enter the currency symbols you want to track (e.g., EUR, GBP, JPY). You can include multiple symbols, separated by commas.
- Note: The base currency is fixed to USD by default. A full list of supported currency symbols and names can be found here.
You may also adjust the following fields in the Config tab:
- Destination Spreadsheet: Leave blank to import data into the current sheet.
- Destination Sheet Name: Data is imported into the "Data" sheet by default. Specify a name or ID to use a different sheet.
- ReimportLookbackWindow: Choose how many past days to include when refreshing data (default: 2).
- CleanUp to Keep Window: Define how many days of data you’d like to retain in your sheet to keep it clean and manageable.
Step 3: Get Your App ID for Open Exchange Rates ( ~1 min)
To authorize your connector and start importing data, you’ll need to generate an App ID from Open Exchange Rates.
- Log in to Your Account
- Visit https://openexchangerates.org and sign in or create an account.
- Go to the App IDs Section
- Navigate to the Integration → App IDs section from the dashboard.
- Create a New App ID
- Enter a name for your app and click Generate New App ID.
- Copy Your App ID
- Once generated, copy the App ID, as you’ll use it when setting up the connector in Google Sheets.
Step 4: Enter Your Credentials in the Template ( ~10 seconds)
Once you’ve generated your App ID, connect it to the template.
- Open the Credentials Menu
- In your Google Sheet, go to the top menu → OWOX → Manage credentials.
- Add Your App ID
- Paste the App ID you generated from the Open Exchange Rates dashboard into the prompt that appears.
- Click OK.
You’re now ready to start importing exchange rate data into Google Sheets.
Step 5: Run the Connector & Import Your Data ( ~1 min)
With your App ID in place, you're ready to fetch live exchange rate data into your spreadsheet.
- Run the Import
In your Google Sheet, go to the top menu → OWOX → Import New Data.
- Wait for Completion
- Once the log shows "Import is finished", your exchange rate data will appear in the Data sheet.
📊 Real-Time Visualization with OWOX BigQuery Data Marts
Getting exchange rate data into Google Sheets is just the beginning. The true advantage comes when you turn that raw data into visual insights, instantly.
With the OWOX BigQuery Data Marts, you can convert your Open Exchange Rates data into dynamic pivot tables and charts in one click. No scripts. No formatting hassle. Just fast, visual answers for finance and analytics teams.
Use OWOX AutoCharts to:
📊 Create visual snapshots of currency trends over time
📈 Compare exchange rates between selected currencies (e.g., USD to EUR, GBP to JPY)
🔍 Monitor fluctuations and outliers across custom timeframes
🔁 Auto-refresh your dashboards as new data flows in
Whether you're tracking global pricing, auditing international conversions, or building currency-adjusted reports, OWOX AutoCharts makes your financial data clear, flexible, and ready to share.
What’s Next?
This connector is part of the OWOX Data Marts (Community Apps Script Edition), a growing library of free, open-source tools for marketing and finance analysts.
Explore more resources here:
🔗 More free connectors – including Twitter Ads and Reddit Ads Connectors for Google Sheets and many more.
🎥 Step-by-step video walkthroughs – to help you set up and troubleshoot with ease
📊 Prebuilt dashboard templates – to speed up insights and performance tracking.
Explore the full list of tools on our GitHub repo, drop us a ⭐ star, and help shape the future of open analytics with OWOX Connectors.
Frequently asked questions
.png)
.png)
Finally, a tool that doesn't ask business users to learn a new dashboarding UI. Our marketing team already knows Sheets. OWOX just delivers the right data.
Joinable data marts concept was the thing that sold us. We can now use the semantic layer without building one.
Self-hosted the OSS version on Digital Ocean. Zero vendor lock-in. Contributed a Shopify connector back in week two.