CLI Reference

sheetlink items

JSON (default)

The default output. A structured JSON object is written to stdout, making it composable with any Unix tool. Nothing is written to disk unless you redirect the output.

Output shape:

{
  "synced_at": "2026-04-09T08:00:00.000Z",
  "items": [
    {
      "item_id": "VBX93wmRY4Iy...",
      "institution_name": "Chase",
      "accounts": [
        {
          "account_id": "acc_abc123",
          "name": "Chase Checking",
          "mask": "4242",
          "type": "depository",
          "subtype": "checking",
          "balances": {
            "current": 2847.12,
            "available": 2647.12
          }
        }
      ],
      "transactions": [
        {
          "transaction_id": "txn_xyz789",
          "date": "2026-04-08",
          "name": "Whole Foods Market",
          "amount": 47.23,
          "category": "Food and Drink",
          "account_id": "acc_abc123",
          "account_name": "Chase Checking",
          "account_mask": "4242",
          "institution_name": "Chase",
          "pending": false,
          "payment_channel": "in store",
          "merchant_name": "Whole Foods Market",
          "primary_category": "FOOD_AND_DRINK",
          "detailed_category": "FOOD_AND_DRINK_GROCERY_STORES"
        }
      ]
    }
  ]
}

# Get all transaction names
sheetlink sync | jq '[.items[].transactions[].name]'

# Sum all transaction amounts
sheetlink sync | jq '[.items[].transactions[].amount] | add'

# Filter by merchant
sheetlink sync | jq '.items[].transactions[] | select(.merchant_name == "Amazon")'

CSV

Writes a flat CSV file. Each sync overwrites the file — it’s a point-in-time snapshot, not an append log. The default output path is ./sheetlink-transactions.csv.

CSV columns (in order):

sheetlink sync --output csv --file ~/finances.csv

PostgresMAX

Upserts transactions and accounts into a Postgres database. Tables are created automatically on first run. Safe to run repeatedly — deduplication is handled by transaction_id and account_id.

sheetlink sync --output postgres://user:password@host:5432/dbname

Auto-created schema:

-- Transactions table
CREATE TABLE IF NOT EXISTS sheetlink_transactions (
  transaction_id    TEXT PRIMARY KEY,
  date              DATE NOT NULL,
  name              TEXT,
  amount            NUMERIC(12, 2),
  category          TEXT,
  account_id        TEXT,
  account_name      TEXT,
  account_mask      TEXT,
  institution_name  TEXT,
  pending           BOOLEAN,
  payment_channel   TEXT,
  merchant_name     TEXT,
  primary_category  TEXT,
  detailed_category TEXT,
  synced_at         TIMESTAMPTZ DEFAULT NOW()
);

-- Accounts table
CREATE TABLE IF NOT EXISTS sheetlink_accounts (
  account_id       TEXT PRIMARY KEY,
  name             TEXT,
  mask             TEXT,
  type             TEXT,
  subtype          TEXT,
  institution_name TEXT,
  balance_current  NUMERIC(12, 2),
  balance_available NUMERIC(12, 2),
  synced_at        TIMESTAMPTZ DEFAULT NOW()
);

SQLiteMAX

Same schema as Postgres, but written to a local SQLite file. No server required — great for local development, personal finance dashboards, or lightweight automation.

sheetlink sync --output sqlite:///~/finance.db

The file is created if it doesn’t exist. The same sheetlink_transactions and sheetlink_accounts tables are created with identical schema.