MoneySheets API

The MoneySheets API lets you read the financial data MoneySheets syncs into your Google Sheet — transactions, categories, and categorization rules — and control how and when that data is synced.

It is a small, predictable REST API. All requests are made over HTTPS, authenticated with a personal API token, and all responses are JSON.

Every endpoint is scoped to a single MoneySheets account: the token you send determines whose data you read and write.

Prefer to explore interactively? Try it in Swagger — sign-in required.

Authentication

The API authenticates with a personal API token. Create one in the dashboard under API tokens — you will see the token value once, so copy it somewhere safe.

Send the token in the Authorization header as a bearer token on every request. Tokens always start with the prefix ms_.

Each token carries one or more scopes. The read scope grants access to the GET endpoints (transactions, categories, rules, schedule). The write scope is required to trigger a sync or change your schedule. Requesting an endpoint without the required scope returns 403.

curl https://moneysheets.io/api/v2/transactions \
  -H "Authorization: Bearer ms_your_token_here"

Base URL

All endpoints live under the https://moneysheets.io/api/v2 base path. Paths in this reference are written relative to that base.

Requests must use HTTPS. Plain HTTP requests are redirected.

https://moneysheets.io/api/v2

Errors

The API uses conventional HTTP status codes. Any non-2xx response has a JSON body with a single error field describing what went wrong.

{
  "error": "Authentication required"
}

Rate limits

The sync endpoint is rate limited to protect the underlying Google Sheets integration. When you exceed the limit the API returns 429; wait a short while before retrying.

The read endpoints are not rate limited under normal use, but please avoid tight polling loops — the data changes at most a few times a day.

List transactions

Returns the transactions synced to your sheet within a date range, keyed by a unique transaction id. When the same transaction id occurs more than once in the range, later occurrences are suffixed with #2, #3, and so on.

curl "https://moneysheets.io/api/v2/transactions?start_date=2026-01-01&end_date=2026-01-31" \
  -H "Authorization: Bearer ms_your_token_here"

{
  "transactions": {
    "a1b2c3": {
      "row_index": 42,
      "amount": "-24.90",
      "date": "2026-01-14",
      "date_added": "2026-01-15T03:12:00+00:00",
      "account_id": "acc_123",
      "bank_account_identifier": "Revolut EUR",
      "sheet_description": "NETFLIX.COM",
      "category": "Subscriptions"
    }
  },
  "count": 1,
  "start_date": "2026-01-01",
  "end_date": "2026-01-31"
}

List categories

Returns the list of categories defined in your sheet.

curl https://moneysheets.io/api/v2/categories \
  -H "Authorization: Bearer ms_your_token_here"

{
  "categories": ["Groceries", "Rent", "Subscriptions", "Salary"]
}

List rules

Returns your categorization rules. Each rule maps a description pattern to a category, optionally constrained to an amount range.

curl https://moneysheets.io/api/v2/rules \
  -H "Authorization: Bearer ms_your_token_here"

{
  "rules": [
    {
      "description": "NETFLIX",
      "category": "Subscriptions",
      "minAmount": "",
      "maxAmount": ""
    }
  ]
}

Sync transactions

Triggers a sync of the latest bank transactions into your sheet. The sync runs in the background; the response confirms it was scheduled.

curl -X POST https://moneysheets.io/api/v2/sync-transactions \
  -H "Authorization: Bearer ms_your_token_here"

{
  "success": true,
  "message": "Sync scheduled"
}

Get schedule

Returns your current automatic sync schedule.

curl https://moneysheets.io/api/v2/schedule \
  -H "Authorization: Bearer ms_your_token_here"

{
  "active": true,
  "start_time": "08:00",
  "period_minutes": 1440,
  "cron": "0 8 * * *",
  "last_run_time": "2026-01-15T08:00:00+00:00"
}

Set schedule

Creates or updates the recurring sync schedule. start_time is the time of the first run; hours and minutes set the interval between runs.

curl -X POST https://moneysheets.io/api/v2/schedule \
  -H "Authorization: Bearer ms_your_token_here" \
  -H "Content-Type: application/json" \
  -d '{"start_time": "08:00", "hours": 24, "minutes": 0}'

{
  "success": true
}

Cancel schedule

Removes the recurring sync schedule. Automatic syncs stop; you can still sync manually.

curl -X DELETE https://moneysheets.io/api/v2/schedule \
  -H "Authorization: Bearer ms_your_token_here"

{
  "success": true
}