BareBones + Google Sheets
Love entering things in a sheet? Keep it. Make the sheet your on-ramp and let a new row flow straight into the ledger — you get the familiar grid and a real, reconciled book behind it.
function postRow(e) {
const [date, amount, category, note] = e.values;
UrlFetchApp.fetch(
'https://barebonespm.com/api/v1/ledger', {
method: 'post',
contentType: 'application/json',
headers: { Authorization: 'Bearer ' + KEY },
payload: JSON.stringify({
amount: Number(amount),
type: 'EXPENSE',
category: category,
transaction_date: date,
reason_description: note,
}),
});
}What you'll need
Where each row lands
Authorization: Bearer <your_api_key>
Create a key on your dashboard. Full reference in the API docs.
| Field | Type | Notes |
|---|---|---|
| amount* | number | Dollar amount, e.g. 142.50 |
| type* | enum | INCOME, EXPENSE, or CHARGE |
| category* | enum | RENT, UTILITIES, REPAIRS, INSURANCE, TAXES, … |
| property_id | integer | Which property (optional) |
| unit_id | integer | Specific unit; omit = property-wide |
| transaction_date | string | YYYY-MM-DD; defaults to today |
| reason_description | string | Free-text note for the line |
| status | enum | PAID or UNPAID (default UNPAID; ignored for INCOME) |
* required
Two ways
Pick code or no-code
Apps Script keeps it all inside Google; a Zap or Make scenario keeps it point-and-click.
Create an API key
Generate one under API keys. For Apps Script, store it with Script Properties, not inline.
Lay out your columns
Date, amount, category, note — one row per transaction. Use the exact category values from the reference above.
Code path — Apps Script
Add an Extensions → Apps Script function like the one shown, triggered on form submit or on edit, to POST the new row.
No-code path — Zapier / Make
Prefer no code? Use a “New Spreadsheet Row” trigger and a webhook/HTTP action to post to the ledger.
Add a row, watch it land
Enter a transaction. Within moments it appears in your BareBones ledger, categorized and counted.
Get your API key and wire it up.
Create a key on your dashboard, point your tool at POST /api/v1/ledger, and your books start keeping themselves.
Other integrations