Capabilities

What the agent can do.

Overview

The agent is not a chatbot. It takes actions in your workbook — creating tables, writing code, browsing the web, managing files. Here’s what it can do.

Web research

The agent searches the open web, visits pages, and extracts structured data. It works with any publicly accessible website.

  • Search by topic, company, product, or keyword
  • Visit specific URLs and extract data from them
  • Collect data across multiple pages and sources
  • Handle pagination, lists, and nested content

It works best with public data. It can’t log into accounts or access paywalled content.

Table operations

The agent creates and manages tables directly.

  • Create tables with named, typed columns
  • Add, rename, retype, or delete columns
  • Insert, update, and delete rows
  • Populate tables with data from the web or uploaded files

Sheet operations

The agent reads and writes to sheets.

  • Set cell values, formatting, and notes
  • Build summaries, dashboards, and KPI displays
  • Merge cells for headers and section labels

Python execution

The agent writes and runs Python code in your workbook’s environment using the SheetOS SDK.

  • Query tables and sheets with SQL
  • Compute values, transform data, run analysis
  • Create automations that re-run when data changes
  • Process uploaded files (CSVs, PDFs, spreadsheets)

File management

The agent manages files in your workbook’s filesystem.

  • Read, write, edit, and delete files
  • Upload processing — extract data from CSVs, PDFs, and spreadsheets
  • Write automation scripts to src/engine/automations/

Workbook management

The agent manages workbook structure.

  • Create and delete pages (tables and sheets)
  • Rename entities
  • Set up the WORKBOOK.md documentation

Next