notion-exrate-worker

Notion Exchange Rate Worker

A Cloudflare Workers Scheduled Worker that automatically fetches exchange rates from Open Exchange Rates API and updates a Notion database.

Features

• 🔄 Hourly automatic sync via Cron trigger
• 🔌 Manual sync via HTTP endpoint
• 💱 Supports 170+ currencies
• 🧮 Currency conversion API
• ⚡ Fast and serverless

Setup

Prerequisites

• Node.js 18+
• Cloudflare account
• Open Exchange Rates API App ID
• Notion Integration Token

Notion Setup

1. Create a Notion database with the following properties:

| Property | Type | |----------|------| | Code | Title | | Rate | Number | | Updated At | Date |

1. Create a Notion Integration at https://www.notion.so/my-integrations
2. Share your database with the integration

Installation

# Clone the repository
git clone git@ssh.git.ac:kotoyuuko/notion-exrate-worker.git
cd notion-exrate-worker

# Install dependencies
npm install

Configuration

1. Copy the example environment file:

   cp .dev.vars.example .dev.vars
   

2. Fill in your credentials in .dev.vars:

   OXR_APP_ID=your_open_exchange_rates_app_id
   NOTION_TOKEN=your_notion_integration_token
   NOTION_DATABASE_ID=your_notion_database_id
   

Local Development

# Start development server
npm run dev

# Test scheduled handler
curl "http://localhost:8787/__scheduled?cron=0+*+*+*+*"

# Or use manual sync endpoint
curl "http://localhost:8787/sync"

Deploy

# Deploy to Cloudflare Workers
npm run deploy

# Set production secrets
wrangler secret put OXR_APP_ID
wrangler secret put NOTION_TOKEN
wrangler secret put NOTION_DATABASE_ID

API Reference

Endpoints

Endpoint	Method	Description
/	GET	Info page
/convert	GET	Convert currency
/rates	GET	Get exchange rates
/sync	GET	Sync rates to Notion

Convert Currency

GET /convert?from=USD&to=CNY&amount=100

Parameters:

• from - Source currency code (e.g., USD, EUR, JPY)
• to - Target currency code
• amount - Amount to convert

Response:

{
  "success": true,
  "from": "USD",
  "to": "CNY",
  "amount": 100,
  "rate": 6.9002,
  "result": 690.02,
  "timestamp": 1773900000000
}

Get Exchange Rates

GET /rates?base=USD

Parameters:

• base - Base currency (default: USD)

Response:

{
  "base": "USD",
  "timestamp": 1773900000000,
  "rates": {
    "AED": 3.6725,
    "CNY": 6.9002,
    "EUR": 0.9175,
    "JPY": 149.85,
    ...
  }
}

Manual Sync to Notion

GET /sync

Response:

{
  "success": true,
  "currenciesFound": 173,
  "ratesFetched": 172,
  "succeeded": 172,
  "failed": 0,
  "errors": []
}

Tech Stack

• Cloudflare Workers
• Open Exchange Rates API
• Notion API
• TypeScript

License

MIT