Send Bank of Canada data to Google Sheets
Load Bank of Canada daily rates, each quoted against the Canadian dollar, into your data warehouse first, join them to orders and invoices by date and currency, then send revenue in CAD to Google Sheets on a schedule. No key to manage, and the sheet stays tied to your source of truth.
Bank of CanadaConnectedExchange Rates
Google SheetsDateLabelRateDaily 09:00A rate table pasted into Google Sheets converts differently each week, and no report says which rate it used.
Paste this into your AI assistant. It loads Bank of Canada rates into your data warehouse with OWOX Data Marts, joins them to orders and invoices there, and sends revenue in CAD to Google Sheets on a schedule.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/bank-of-canada-connector-to-google-sheets.md. The task: load Bank of Canada daily rates into my data warehouse, join them to my orders and invoices by date and currency, and send revenue in CAD to a Google Sheets tab every morning. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
Bank of Canada Endpoints
1 Bank of Canada endpoints you can import. Each lands in its own table in your data warehouse.
Why Bank of Canada does not go straight to Google Sheets
A rate table pasted into a sheet gives you one conversion that drifts from the next one. It does not say which rate a report used, because revenue, invoices and rates live in different places. A sheet is not built to join them reliably, at scale or business-ready, so the join happens in a warehouse first.
- Bank of Canada publishes the rate, not how your reports use it
- The data analyst converts orders and invoices to CAD by date and currency and controls the result
- Stakeholders keep the sheet they like, now converted on one basis
Bank of CanadaOfficial FX ratesGoogle Sheets
Data warehouseJoined by idStep 1: Load Bank of Canada into your data warehouse first
Create a Data Mart with Bank of Canada as the source and choose where the data lands. It works with any popular data warehouse.
- One endpoint, Exchange Rates, with three fields: date, label and rate
- The source needs no credentials
- Open the Bank of Canada connector for your data warehouse below
Bank of Can…Data MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databricksbank_of_canada.exchange_ratesStep 2: Link Bank of Canada rates to orders and invoices
In your data warehouse the model puts the official rate table beside orders and invoices, joined by date and by currency code plus CAD (a EUR order matches EURCAD). Pick an industry to see the shape of its model.
- Every rate is quoted against the Canadian dollar, so CAD is the natural reporting basis
- Orders and invoices join on date and their currency code plus CAD, not a rate typed into a cell
- The measures, such as settled_revenue, are defined once
Bank of CanadaExchange RatesStep 3: Send Bank of Canada data to Google Sheets
Connect a 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 Bank of Canada Valet API
- Hover a header to see what date, label or rate means
Google SheetsNotes in headersdatelabelrateStep 4: Refresh your Bank of Canada 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
- Bank of Canada publishes a rate each business day, so a daily refresh keeps the sheet current
Google SheetsUpdatedStep 5: Reuse Bank of Canada inside OWOX MCP
The same Data Mart works in OWOX MCP, your 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
Google SheetsOpen
ExcelOpen
- 0.41.0Reuse one Google Sheets or Google Chat key across Destinations
- 0.40.0Warnings when a Count reads a joined Data Mart
- 0.40.0Open the Google Sheet a scheduled report fills, right from Triggers
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.38.0Google Sheets errors in Run History explain the cause and the fix
Why OWOX for Bank of Canada in Google Sheets
Pasting exchange rates into a sheet gets one conversion right once. OWOX keeps the rate table yours, linked to the numbers it converts and ready to model.
- You own the data. It lands in your own data warehouse, in tables you control.
- One official rate table. Every conversion in every report uses the same Bank of Canada rate, joined by date and currency.
- An audit trail for finance. The Data Mart keeps the SQL behind each converted number one click away.
- Sheets stay in sync. Notes in the headers, a schedule you set once, no export to redo in the sheet.
- Maintained for you. No scripts to repair when Bank of Canada changes how it serves data.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.