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
• ⚡ 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

Usage

Automatic Sync

The worker runs automatically every hour via Cron trigger.

Manual Sync

Send a GET request to the /sync endpoint:

curl https://your-worker.workers.dev/sync

Response:

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

API Reference

Endpoint	Method	Description
/	GET	Info page
/sync	GET	Manually trigger exchange rate sync

Tech Stack

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

License

MIT