2.3 Cells: Where Data Lives

You've learned that rows are process instances and columns are processing steps. Now let's explore cells—the intersection where rows and columns meet, where your automation's data actually lives and breathes.

If rows are the heartbeat and columns are the muscles, cells are the bloodstream—carrying data through your automation, changing state as they process, and ultimately delivering the results you need.

---

The Concept: What Are Cells?

Cell = Row Meets Column

A cell is simply the intersection of one row and one column.

Think of it like a spreadsheet:

• Row 1, Column A = One specific cell
• Row 2, Column B = Another specific cell
• Each cell is unique and independent

Visual representation:

            Email       Company     Score
          ┌─────────┬─────────┬─────────┐
Lead 1    │ Cell 1  │ Cell 2  │ Cell 3  │
          ├─────────┼─────────┼─────────┤
Lead 2    │ Cell 4  │ Cell 5  │ Cell 6  │
          ├─────────┼─────────┼─────────┤
Lead 3    │ Cell 7  │ Cell 8  │ Cell 9  │
          └─────────┴─────────┴─────────┘

Each cell contains:

• Data: The actual value (email address, company name, score, AI response, etc.)
• State: Current status (Ready, Running, Completed, Error, etc.)
• Timestamp: When it was last updated
• Error info (if something went wrong)

Cell Lifecycle

Every cell goes through a lifecycle as it processes:

Created
   ↓
Ready (waiting)
   ↓
Queued (scheduled)
   ↓
Running (processing)
   ↓
Completed or Error or Skipped
   ↓
(stays in final state)

Manual columns don't have states—they just contain data you enter directly.

Why Cells Matter

Cells are where the action happens:

• Data storage: Each cell holds one piece of information
• State tracking: You can see exactly what's processing, what's done, what failed
• Independent execution: Each cell processes on its own schedule
• Full transparency: Watch your automation progress in real-time
• Easy debugging: Inspect any cell to see data, state, and errors

Real-world analogy:

• Row = A package being shipped
• Column = A shipping checkpoint (label, sort, load, deliver)
• Cell = The package at that specific checkpoint, with its current status

---

What's Inside a Cell?

Let's look at what information every cell contains.

The Data

What it is: The cell's content—the actual information you're working with

Examples:

Simple data:

• Text: "john@acme.com"
• Number: 85
• True/False: true

Complex data:

Company Information:
  Name: Acme Corp
  Website: acme.com
  Employees: 2500
  Industry: Technology
  Funding:
    Stage: Series B
    Amount: $50,000,000
  Location:
    City: Seattle
    State: WA
    Country: USA

When it's set:

• Manual columns: When you type it in
• Automated columns: When the automation completes successfully

The State

What it is: The cell's current status—what's happening right now

You'll see these states:

Cell States: What You'll See

Every cell shows its current state with color and icon. Here's what each means:

⚙️

Running

Cell is currently executing - AI is working, API is being called, or action is in progress

👉 Watch it work in real-time with the spinning gear icon

🕐

Queued

Cell is in the execution queue, will start processing soon

👉 Processing will start momentarily

⏸️

Rate Limited

Temporarily throttled to stay within API rate limits

👉 Will automatically resume when quota is available

⏳

Scheduled

Waiting for an external event (webhook, email, or scheduled time)

👉 Will update automatically when the event occurs

⚙️

Skipped (Condition failed)

The condition expression evaluated to false, so this cell was intentionally skipped

👉 This is normal - the column's condition wasn't met for this row

⊘

Skipped (Dependencies not present)

Required dependencies are not in completed state, so this cell cannot execute

👉 This is normal if upstream columns failed or were skipped

⚡

Unsuccessful

⚡ UNSUCCESSFUL

Execution failed with an error - needs your attention

👉 Click to see detailed error information and retry the cell

✓

Completed

Cell successfully completed and data is ready

👉 Click to view the data produced by this cell

🎬 Watch a Cell Flow Through States

⚙️

Running

→

✓

Completed

→

⚡ UNSUCCESSFUL

Unsuccessful

Watch cells transition: Running → Completed (success) or Unsuccessful (if errors occur)

State colors at a glance:

• Lots of green: Everything's working great
• Lots of blue spinning gears: Processing actively
• Blue lightning bolts: Errors that need attention
• Lots of gray: Automations haven't started yet

The Timestamp

What it is: When this cell was last modified

Example: Oct 24, 2024 2:32 PM

Useful for:

• "When was this lead enriched?"
• "Is this data still fresh?"
• "How long did this take?"
• "When did this error occur?"

The Error Information (if failed)

What it is: Details about what went wrong

Example:

Title: Authentication Failed
Description: API key invalid or expired. 
Please reconnect your account in Settings.

Only present when state = Error

Cleared when you re-run the cell successfully

---

Cell States in Detail

Let's explore each state and what you'll see.

Ready (Gray)

What you see: Gray cell, empty or "—"

What it means: Cell hasn't been calculated yet

When it happens:

• New row just created
• Cell was manually cleared
• Dependencies not satisfied yet

What's next: When dependencies are ready → switches to Queued

Example: You just added a row with an email address. The "Company Enrichment" column shows Ready because it hasn't run yet.

Queued (Blue Clock, Pulsing)

What you see: Blue color, clock icon with pulse animation

What it means: Cell is scheduled and waiting in line to process

When it happens:

• Dependencies just completed
• You manually triggered the cell
• Cell is retrying after rate limit

How long: Usually seconds (depends on how busy the system is)

What's next: → Running (when it's this cell's turn)

Example: Dependencies completed, enrichment is queued and will start processing momentarily.

Running (Blue Gear, Spinning)

What you see: Blue color, spinning gear icon

What it means: Cell is being processed right now

When it happens:

• Making an API call
• AI is generating a response
• Code is executing
• Action is being performed

How long: Varies by operation

• Quick tasks: < 1 second
• API calls: 1-5 seconds
• AI generation: 5-30 seconds
• Complex operations: 30+ seconds

What's next: → Completed (success) or → Error (if something goes wrong)

Example: The AI is currently analyzing the email and generating a response.

Rate Limited (Yellow Pause)

What you see: Yellow color, pause icon

What it means: Temporarily paused to respect API rate limits

When it happens:

• Column has rate limit configured
• Limit reached for current period
• Waiting for quota to reset

How long: Until rate limit window allows next execution

What's next: → Queued (when limit permits)

Example: You've made 100 API calls this hour. The system will automatically resume when the hour resets.

Why rate limiting:

• Protect external APIs from overload
• Control costs
• Prevent account suspension
• Spread load over time

Completed (Green Checkmark)

What you see: Green color, checkmark icon, data preview

What it means: Cell calculated successfully, data is ready

When it happens: Processing finished without errors

What's next:

• Stays Completed (usually)
• → Queued again (if you re-run manually or dependencies change)

Data visible: Click to see full data

Example: Company enrichment completed successfully. You can now see the company name, size, industry, and other data.

Error (Blue Lightning Bolt)

What you see: Blue color, lightning bolt icon, "Unsuccessful" badge

What it means: Something went wrong during processing

When it happens:

• API returned an error
• Network timeout
• Invalid settings
• Missing required data
• Authentication failed

Error details: Click the cell to see full error explanation

What's next: Stays Error until you fix the issue and re-run

Example: API key expired. Click to see the error details and reconnect your account.

Common errors and fixes:

• Authentication Failed: Reconnect your account in Settings
• Data Not Found: Check that the data exists in the previous column
• Rate Limit Exceeded: Wait or adjust rate limit settings
• Timeout: The service took too long; try again

Scheduled (Purple Hourglass, Pulsing)

What you see: Purple color, hourglass icon with pulse

What it means: Waiting for an external event

When it happens:

• Webhook waiting for incoming request
• Email listener waiting for new email
• Scheduled task waiting for specific time

How long: Indefinite (until the event occurs)

What's next: → Running (when event received) → Completed

Example: Webhook listener is scheduled and waiting for a customer to submit the form.

Failed (Red Icon)

What you see: Red color with special icon

What it means: Column's condition wasn't met for this row

When it happens:

• Column has a "run only if" condition
• Condition evaluated to false

What's next: Stays Skipped unless condition changes

Example: Column says "Only run if lead score > 50". This lead has score 35, so it was intentionally skipped.

Skipped (Dependencies not present) (Gray Slash)

What you see: Gray color, circle-slash icon

What it means: Required data from other columns isn't available

When it happens:

• Dependency column is Ready (not run yet)
• Dependency column is Error
• Dependency column is Skipped
• Dependency data is empty

What's next: Stays Skipped until dependencies are resolved

Example: This column needs company data, but the company enrichment column failed. So this column is automatically skipped.

---

Working with Cells

Let's explore how to interact with cells in the interface.

Viewing Cell Data

Quick preview (hover over cell):

• Shows first bit of data
• State and timestamp
• Hover tooltip with preview

Full view (click cell):

Cell Detail Panel - Interactive View

When you click on a cell, a sidebar opens with full details and actions:

Company Enrichment - Row #45

Completed

Updated: Oct 24, 2024 2:32 PM

Data:

▼company_data

name:"Acme Corp"

domain:"acme.com"

employees:2500

industry:"Technology"

▼funding:

stage:"Series B"

amount:50000000

▼location:

city:"Seattle"

state:"WA"

country:"USA"

Actions:

Interactive Features: Click property names to copy paths, click values to copy to clipboard, expand/collapse nested structures to explore your data.

The detail panel shows:

• Header: Column name, row number, state badge
• Timestamp: When last updated
• Full data: Complete content with pretty formatting
• Actions: Buttons to re-run, clear, or copy

For complex data (like objects):

• Click arrows to expand/collapse sections
• Click property names to copy the path
• Click values to copy to clipboard
• Search within the data

Viewing Errors

When a cell shows Error state:

1. Click the cell to open detail panel
2. Error icon shows in the cell and in actions
3. Error panel shows:
   • What went wrong: Plain English explanation
   • How to fix it: Step-by-step guidance
   • Technical details: For advanced users (status codes, URLs, etc.)
   • Suggested actions: Quick fixes like "Reconnect Account"

Example error view:

⚠️ Authentication Failed

What went wrong:
Your API key is invalid or has expired. 
The service cannot verify your account.

How to fix it:
1. Go to Settings → Accounts
2. Find the service account
3. Click "Reconnect"
4. Follow the authentication flow
5. Come back and click "Re-run Cell"

Technical Details:
Status: 401 Unauthorized
URL: https://api.clearbit.com/v2/companies/find

Cell Operations

Actions you can perform on cells:

1. Re-run Cell

What it does: Execute this cell again

When to use:

• Cell failed (retry after fixing issue)
• Data might have changed (refresh)
• Testing after configuration change

How:

1. Click the cell
2. Click "Re-run Cell" button
3. Cell goes: Queued → Running → Completed/Error

What happens:

• Previous data is replaced
• Error cleared (if successful)
• Timestamp updated
• Downstream columns may recalculate

2. Clear Cell

What it does: Reset cell to Ready, delete data

When to use:

• Start over with fresh calculation
• Remove incorrect data
• Reset before testing

How:

1. Click the cell
2. Click "Clear Cell" button
3. Confirm: "Clear data in this cell?"
4. Cell resets to Ready state

What happens:

• State → Ready
• Data deleted
• Error cleared (if present)
• Downstream cells may be affected

3. Copy Data

What it does: Copy cell data to clipboard

How:

1. Click the cell
2. Click "Copy Data" button
3. Data copied as text or JSON

Use cases:

• Paste into email or document
• Share with team
• Use in external tools

Bulk Operations

Work with multiple cells at once:

Re-run Multiple Cells

From column menu:

1. Click column header menu (⋮)
2. Choose "Run All" (runs all Ready/Error cells)
3. Or "Run Empty" (runs only Ready cells)
4. Or select rows first, then "Run Selected"

What happens: All selected cells start processing in order

Clear Multiple Cells

From column menu:

1. Click column header menu (⋮)
2. Choose "Clear All"
3. Warning shows which columns depend on this
4. Confirm to clear all cells

Use case: Reset entire column to start over

Cancel Processing

Stop cells that are running:

1. Click column header menu (⋮)
2. Select "Cancel"
3. Queued and Running cells stop

When to use:

• Wrong configuration detected
• Need to make changes first
• Prevent unnecessary API calls

Column Status Overview

The column header shows overall status for all cells in that column.

Visual indicators:

• Spinning gear icon: Some cells are currently running
• Clock icon: Some cells are queued
• Count badges: "Running: 2", "Queued: 5"

Hover for tooltip:

Column Status:
Running: 1 cell (Row 23)
Queued: 5 cells (Next: Row 24)

Click to navigate to active cell

Click the icon to jump directly to the first running or queued cell

Quick status scan:

• Look at column headers
• See which columns are actively processing
• See which columns have queued work
• Jump to cells that need attention

---

Real-Time Updates

Live updates as cells process:

• Cells change color instantly as they transition states
• No page refresh needed
• Smooth visual transitions
• Animations show active processing

What you'll see:

1. Time 0: Cell is gray (Ready)
2. Time 1: Cell turns blue with pulsing clock (Queued)
3. Time 2: Clock becomes spinning gear (Running)
4. Time 5: Cell turns green with checkmark (Completed)

Everyone sees the same thing:

• Multiple people can view the same table
• Everyone sees state changes simultaneously
• Perfect for team collaboration and monitoring

---

Troubleshooting Common Issues

Issue 1: Cell Stuck in Ready

Symptoms: Cell stays gray, never processes

Possible causes:

• Dependencies not completed
• Run mode is Manual
• Condition evaluates to false

Solutions:

1. Check dependencies: Click column menu → Configure. Are all dependency columns green (Completed)?
2. Check run mode: In configuration, is run mode set to "Run automatically"?
3. Check condition: Is there a condition that might be failing?
4. Manually trigger: Click column menu → "Run All" or "Run Empty"

Issue 2: Cell Keeps Failing

Symptoms: Cell goes Queued → Running → Error repeatedly

Possible causes:

• Invalid API credentials
• Missing required data
• Wrong configuration
• Service is down

Solutions:

1. Read error message: Click the failed cell to see full error details
2. Check authentication: Go to Settings → Accounts. Is account connected?
3. Verify configuration: Click column menu → Configure. Are all settings correct?
4. Check dependencies: Are the required data fields actually present?
5. Test with known-good data: Try a row you know should work
6. Check service status: Is the external service operational?

Issue 3: Cell Shows Wrong Data

Symptoms: Cell is Completed but data looks incorrect

Possible causes:

• Accessing wrong property
• Logic error in automation
• Unexpected API response structure

Solutions:

1. Inspect the data: Click cell to see full data structure
2. Check previous column: Is the input data correct?
3. Review configuration: Click column menu → Configure. Check all settings.
4. Re-run cell: Click "Re-run Cell" to fetch fresh data
5. Test with sample: Try with a known-good example

Issue 4: Cells Processing Very Slowly

Symptoms: Cells stay in Queued or Running for a long time

Possible causes:

• High queue depth
• Rate limiting active
• Complex processing
• External service slow

Solutions:

1. Check column status: Hover over column header icon. How many queued?
2. Look for rate limit: Are cells showing yellow "Rate Limited" state?
3. Wait patiently: Complex operations (AI generation) can take 30+ seconds
4. Check system load: Are many automations running at once?
5. Contact support: If consistently slow, there may be an issue

Issue 5: Cell State Looks Wrong

Symptoms: Cell shows one thing but behaves differently

Possible causes:

• Display not refreshed
• Sync issue
• Browser cache problem

Solutions:

1. Refresh page: Press F5 or Cmd/Ctrl+R to reload
2. Clear and re-run: Click column menu → "Clear All" then "Run All"
3. Check browser console: Press F12 and look for errors (advanced)
4. Try different browser: Rule out browser-specific issues
5. Contact support: If problem persists

---

Summary: Mastering Cells

You now understand cells completely:

✅ Concept: Cells are where rows and columns meet—where data lives ✅ Contents: Each cell has data, state, timestamp, and optional error info ✅ States: Eight possible states with distinct visual indicators ✅ Lifecycle: Cells flow through states as they process ✅ Viewing: Click any cell to see full details and actions ✅ Errors: Click failed cells to see detailed error information and fixes ✅ Operations: Re-run, clear, copy individual cells ✅ Bulk Actions: Manage multiple cells through column menu ✅ Real-Time: Watch cells update live as they process ✅ Troubleshooting: Diagnose and fix common cell issues

Key Principles:

1. Cells are independent — each processes on its own schedule
2. States show transparency — always know what's happening
3. Visual indicators are consistent — colors and icons tell the story
4. Real-time updates — watch your automation flow live
5. Errors are debuggable — clear messages guide you to fixes
6. Everything is inspectable — click any cell to see full details

Cells are where your automation's work actually happens. Understanding them gives you complete control over your processes.

---

Next: Chapter 3: Building Your First Automation — Now that you understand the fundamentals (rows, columns, cells), let's build something!