Spreadsheet Tour
The sheet is where data meets the canvas. Circuitry's spreadsheet is a real workbook — formulas, multiple sheet tabs, find-and-replace-grade search — living inside the same studio as your workflows, agents, and whiteboards. Workflows read it and write it, agents pull rows from it as context, and it can mirror an online spreadsheet so the numbers your team already maintains flow straight into everything you build. You think in a sheet, then direct the rest of the studio from it — no exporting, no copy-paste shuffle.
This page tours the standalone spreadsheet editor — the workbook you open as its own tab. For formulas and day-to-day techniques see the Sheet User Guide; for the grid that lives on a workflow node, see the Datagrid node.
A tour of the controls
The formula bar
The strip across the top is the command line of the sheet:
- Cell reference box — shows the active cell (like A1) at the left of the bar.
- f(x) Insert function — opens a menu of common functions, plus category submenus with every function's name and a one-line description. Click one and it drops into the formula bar.
- Formula input — type a value or a formula like
=SUM(A1:A10)and press ⏎ to commit it to the active cell. While you're inside a formula's parentheses the input's border turns emerald — click or drag on the grid and the range is written in for you.
Toolbar actions
To the right of the formula bar:
- Search — toggles the in-sheet search bar. ⌘F
- Export CSV — downloads the sheet as a CSV file.
- / Theme toggle — flips the spreadsheet between light and dark, independently of the rest of the studio.
- Remote workbook — links this workbook to an online spreadsheet (see below). The icon turns emerald once linked, and the tooltip shows the linked workbook's name.
- Save — saves the spreadsheet document. ⌘S
(Shortcuts are shown as ⌘ — use Ctrl on Windows/Linux.)
Search
Open search with or ⌘F and a bar appears below the formula bar:
- Search input — live search across every cell, with an "N of M" match counter.
- Previous match — jump back a match. ⇧⏎
- Next match — jump forward. ⏎
- Close — dismiss the search bar. Esc
Mirror an online spreadsheet
The button opens the Remote workbook sync panel — a whole-workbook mirror between Circuitry and a spreadsheet that lives online:
- Service — choose the provider (Google Sheets or Microsoft Excel).
- Connection — pick an existing account, or hit Connect a new account to sign in to a new one.
- Spreadsheet — pick which remote spreadsheet to link.
- Pull all — replace your local tabs with every remote tab.
- Push all — write every local tab to the remote spreadsheet, creating any missing tabs.
- Unlink — remove the link.
- Delete remote tabs not in this workbook (on Push) — an opt-in prune for keeping the remote side exactly in step; you're asked to confirm before anything is removed.
Once linked, the same data is available to your team in their browser and to your workflows and agents in Circuitry.
Sheet tabs
The bottom of the editor is a tab bar for the workbook's sheets:
- Add sheet — appends a new sheet tab.
- Click a tab to switch to it; double-click to rename it inline.
- Right-click a tab for more: Rename, Duplicate, and Delete (the last remaining sheet can't be deleted).
The grid
- It grows as you go. There's no add-row or add-column ceremony — keep scrolling and the grid keeps extending, up to 10,000 rows and 1,000 columns per sheet.
- Right-click any cell for Cut, Copy, Paste, and Delete.
- Live collaboration aware. In a pair session, a banner above the formula bar lets a viewer Request edit access, hand control back with Done editing, or snap back to following the driver's view — see Sharing & Live Collaboration.
Keyboard
| Shortcut | Action |
|---|---|
| ⌘F | Open in-sheet search |
| ⌘S | Save |
| ⌘Z | Undo |
| ⌘C / ⌘X / ⌘V | Copy / cut / paste cells |
| ⏎ (formula bar) | Commit the value or formula |
| ⏎ / ⇧⏎ (search) | Next / previous match |
| Esc | Close search, cancel an edit, or clear the selection |
| Arrow keys, ⇥, PageUp / PageDown, Home / End | Move around the grid |
Works with the rest of the studio
- Sheet User Guide — formulas, functions, and everyday techniques
- Datagrid node — the sheet as a workflow node that steps read and write
- Data Wizard — let AI fill, transform, and analyse sheet data
- Workflows — wire sheets into automations alongside every other node
- Sharing & Live Collaboration — share a sheet with a link, edit it live together