Skip to content
RoadstarRoadstarRoadstar Docs

A month of hours

Markdown

What Sam said

Section titled “What Sam said”

In Bookkeeper’s chat:

Can you total October’s hours per client from the timesheet? I need it for invoicing.

The chat starts a thread, “October hours”.

1. Bring the timesheet into the workspace

Section titled “1. Bring the timesheet into the workspace”
use_tool
{ "name": "files.search", "input": { "query": "Timesheet 2026" } }

The timesheet is a Google Sheet. open copies it into /work/inbox as .xlsx:

use_tool
{ "name": "workspace.open", "input": { "files": ["7c41e2d0:1TsTimesheet2026SheetX4"] } }
{ "opened": [{ "path": "/work/inbox/Timesheet 2026.xlsx", "from": "7c41e2d0:1TsTimesheet2026SheetX4" }] }

2. Total it with code

Section titled “2. Total it with code”
use_tool
{
  "name": "workspace.write",
  "input": {
    "path": "october.py",
    "content": "import pandas as pd\n\nhours = pd.read_excel('/work/inbox/Timesheet 2026.xlsx', sheet_name='Log')\noctober = hours[(hours['Date'] >= '2026-10-01') & (hours['Date'] < '2026-11-01')]\nby_client = october.groupby('Client', as_index=False)['Hours'].sum().sort_values('Hours', ascending=False)\nby_client.to_excel('october-hours.xlsx', index=False)\nprint(by_client.to_string(index=False))\nprint('Total', by_client['Hours'].sum())\n"
  }
}
use_tool
{ "name": "workspace.bash", "input": { "command": "python october.py" } }

The run’s output:

         Client  Hours
  Juniper Dental   46.5
    Ortiz Bakery   31.0
 Harbor Florists   12.5
Total 90.0

Code in the workspace has no internet and changes nothing of Sam’s, so none of this needs a yes.

3. Save it to Drive

Section titled “3. Save it to Drive”

files.save puts a workspace file in Drive. asGoogle turns the .xlsx into a Google Sheet:

use_tool
{
  "name": "files.save",
  "input": {
    "workspace": "october-hours.xlsx",
    "name": "October 2026 hours by client",
    "asGoogle": true,
    "folderId": "7c41e2d0:1FoBookkeeping2026"
  }
}

A new file needs no yes. With over, the same call would write a new version of the Drive file it was opened from, and that is checked.

4. It answers

Section titled “4. It answers”

October: 90 hours across three clients. Juniper Dental 46.5, Ortiz Bakery 31, Harbor Florists 12.5. The sheet is in Bookkeeping 2026 in Drive.

Section titled “Related”