Using Sheets

Learn how to create, configure, and run workflows in bulk using Sheets.

Creating a Sheet

Create a Blank Sheet

1. Navigate to Sheets in the sidebar
2. Click the Create button
3. Select Blank from the dropdown
4. Your new sheet opens automatically

Rename Your Sheet

1. Click on the sheet name in the header
2. Type your new name
3. Press Enter or click outside to save

---

Working with Tabs

Tabs help you organize related data within a single sheet. Each tab has its own columns, rows, and workflow configurations.

Create a New Tab

1. Click the + button next to existing tabs
2. A new tab is created and becomes active

Switch Between Tabs

Click on any tab name to switch to that tab. The active tab is highlighted with a white background.

Tab Actions

Click the dropdown arrow (▼) next to a tab name to access:

Action	Description
Rename	Change the tab name
Duplicate	Create a copy of the tab with all data
Delete	Remove the tab (requires confirmation)

You cannot delete the last remaining tab in a sheet.

---

Managing Columns

Add a Column

1. Click Add a column button in the header row
2. Select the column type:
   • Text - Plain text data
   • Number - Numeric values
   • Markdown - Rich text with formatting
   • Workflow - Execute a workflow
   • Superblock - Run pre-built AI blocks

Column Menu

Click on any column header to open the column menu:

Option	Description
Rename	Edit the column name directly in the input field
Change Type	Convert the column to a different type
Hide column	Remove from view without deleting
Delete column	Permanently remove the column and its data

Change Column Type

1. Click the column header
2. Click on the current type (e.g., “Text”)
3. Select the new type from the submenu

Changing a column type may affect existing data. Text to Number conversion will fail for non-numeric values.

Hide and Show Columns

To hide a column:

1. Click the column header
2. Select Hide column

To show hidden columns:

1. Click Hidden columns in the toolbar
2. Toggle visibility for each column

---

Managing Rows

Add Rows

Add a single row:

• Click Add Row in the footer

Add multiple rows:

1. Click the dropdown arrow next to Add Row
2. Select Add 10 Rows

Select Rows

• Click the row number to select a single row
• Hold Shift and click to select a range
• Selected rows are highlighted

Delete Rows

1. Select the rows you want to delete
2. Click Delete X Rows button that appears in the footer
3. Confirm the deletion

---

Editing Cells

Enter Data

1. Click on any cell to select it
2. Start typing to enter data
3. Press Enter to save and move down
4. Press Tab to save and move right

Edit Existing Data

1. Double-click a cell to enter edit mode
2. Modify the content
3. Press Enter or click outside to save

Copy and Paste

• Use Ctrl/Cmd + C to copy selected cells
• Use Ctrl/Cmd + V to paste
• Paste works across multiple cells

---

Adding Workflow Columns

Workflow columns are the core feature of Sheets. They connect your data to Slate Workflows for bulk processing.

Step 1: Add a Workflow Column

1. Click Add a column
2. Select Workflow
3. The workflow selection modal opens

Step 2: Select a Workflow

1. Browse or search your workflows
2. Click on a workflow to select it
3. The input mapping screen appears

Step 3: Map Inputs

Each workflow input needs to be mapped to a sheet column:

1. For each workflow input field, select a source column from the dropdown
2. Required fields are marked with an asterisk (*)
3. Optional fields can be left unmapped

Example mapping:

Workflow Input	Mapped To
Topic *	Column A (Keywords)
Target Audience	Column B (Audience)
Tone	Column C (Style)

Step 4: Save Configuration

Click Save to add the workflow column. The column header shows the workflow name.

---

Running Workflows

Run for Selected Rows

1. Select the rows you want to process
2. Click the Run button on the workflow column
3. Workflows execute for each selected row
4. Results appear in the column cells

Run for All Rows

1. Ensure no rows are selected
2. Click the Run button on the workflow column
3. All rows are processed

Run a Single Row

When your sheet has at least one workflow column, a green play button (▶) appears on the left side of every row.

1. Click ▶ on the row you want to run.
2. All workflow columns in that row execute sequentially.
3. The button shows a blue spinner while running.

To stop a running row, click the spinner. A confirmation dialog asks “Stop sequential execution?” — confirm to cancel.

Monitor Progress

• Cells show a loading indicator while processing
• Completed cells display the workflow output
• Failed cells show an error indicator

Auto-Run on New Rows

Auto-run triggers workflow execution automatically whenever new rows are added to the sheet.

Enable auto-run:

1. Click the Settings dropdown in the sheet toolbar.
2. Toggle Auto run rows on.

When enabled, each new row runs its workflow columns sequentially in the background. Auto-run only triggers when the first workflow column’s input is filled.

Rows marked as duplicates by the duplicate check are skipped by auto-run. See the Duplicate Check section below.

Duplicate Check

Duplicate check detects rows with matching values across columns you choose. Duplicate rows are highlighted and skipped by auto-run.

Enable duplicate check:

1. Click the Settings dropdown in the sheet toolbar.
2. Toggle Duplicate check on.
3. Select which columns to compare under Columns to compare.

Only newly added or updated rows are checked — existing rows are not re-evaluated.

When duplicates are found, a Delete duplicate rows button appears in the toolbar. Click the button to permanently remove all duplicate rows while keeping the originals.

Deleting duplicate rows is permanent and cannot be undone.

---

Toolbar Features

The toolbar provides quick access to common actions:

Hidden Columns

View and toggle visibility of hidden columns.

Freeze Columns

Lock columns in place so they remain visible while scrolling horizontally.

1. Click Freeze columns in the toolbar
2. Select how many columns to freeze
3. Frozen columns stay visible when scrolling

Row Height

Adjust the height of all rows:

Size	Best For
Small	Dense data, numbers, short text
Medium	Standard text content
Tall	Multi-line content
Extra Tall	Long-form content, markdown

Undo / Redo

• Click Undo to reverse the last action
• Click Redo to restore an undone action
• Keyboard shortcuts: Ctrl/Cmd + Z (Undo), Ctrl/Cmd + Shift + Z (Redo)

---

Updating Workflow Columns

You can modify a workflow column’s configuration after creation:

1. Click on the workflow column header
2. Select the workflow type option
3. Choose a different workflow or update input mappings
4. Click Save

---

Best Practices

Organize with Tabs

• Use separate tabs for different data sets
• Keep related workflows in the same tab
• Name tabs descriptively

Prepare Data First

• Add and populate input columns before adding workflow columns
• Validate data formats match workflow expectations
• Test with a few rows before bulk processing

Batch Processing

• Start with small batches (10-20 rows) to verify results
• Increase batch size once confident in the setup
• Monitor for errors during large runs

Column Naming

• Use clear, descriptive column names
• Include the data type or purpose
• Avoid special characters

---

Keyboard Shortcuts

Shortcut	Action
Enter	Save cell and move down
Tab	Save cell and move right
Escape	Cancel editing
Ctrl/Cmd + Z	Undo
Ctrl/Cmd + Shift + Z	Redo
Ctrl/Cmd + C	Copy
Ctrl/Cmd + V	Paste

---

What’s Next

• See Use Cases for practical examples
• Explore Workflows to create custom workflows for your sheets