Monday.com Batch Operator Agent

TRIGGER KEYWORDS

Automatically routes when user mentions:

• "bulk Monday"
• "batch update Monday"
• "mass create items"
• "update all items"
• "migrate Monday data"
• "import to Monday"
• "export from Monday"
• "parallel processing Monday"

CAPABILITIES

1. Parallel Item Creation: Create hundreds of items efficiently
2. Batch Updates: Update multiple items/columns in parallel
3. Mass Deletion: Archive or delete items at scale
4. Cross-Board Operations: Copy/move items between boards
5. Data Import: Import from CSV/JSON to Monday.com
6. Data Export: Export board data to various formats
7. Rate Limit Management: Automatic throttling and retry logic

PREREQUISITES

• MONDAY_API_TOKEN environment variable
• Board IDs for source/target boards
• Admin permissions for cross-board operations

ARCHITECTURE

Processing Pipeline

Input Data
    │
    ▼
┌─────────────────┐
│ Validation      │ ← Verify data format, required fields
└────────┬────────┘
         │
         ▼
┌─────────────────┐
│ Chunking        │ ← Split into batches (default: 50 items)
└────────┬────────┘
         │
         ▼
┌─────────────────┐
│ Parallel Exec   │ ← Process chunks concurrently (default: 3)
└────────┬────────┘
         │
         ▼
┌─────────────────┐
│ Rate Limiting   │ ← Respect API limits, backoff on errors
└────────┬────────┘
         │
         ▼
┌─────────────────┐
│ Result Agg      │ ← Collect results, report failures
└─────────────────┘

Configuration Options

Option	Default	Description
batchSize	50	Items per batch
parallelism	3	Concurrent batches
retryAttempts	3	Retry failed operations
retryDelay	1000ms	Delay between retries
continueOnError	true	Continue if batch fails

BATCH IMPORT WORKFLOW

Step 1: Prepare Import File

CSV Format:

name,status,date,owner_email,priority
Task 1,Working on it,2024-01-15,john@example.com,High
Task 2,Done,2024-01-10,jane@example.com,Medium

JSON Format:

[
  {
    "name": "Task 1",
    "columns": {
      "status": "Working on it",
      "date4": "2024-01-15",
      "person": "john@example.com",
      "priority": "High"
    }
  }
]

Step 2: Validate Data

node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js validate \
  --file data.csv \
  --board 12345

Validation Checks:

• Required columns present
• Data types match column types
• Email addresses valid
• Date formats correct
• Enum values in allowed list

Step 3: Preview Import

node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js preview \
  --file data.csv \
  --board 12345 \
  --limit 5

Step 4: Execute Import

node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js import \
  --file data.csv \
  --board 12345 \
  --group new_group \
  --batch-size 50 \
  --parallel 3

BATCH UPDATE WORKFLOW

Update by Filter

# Update all items in a group
node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js update \
  --board 12345 \
  --filter "group=topics" \
  --set "status=Done"

# Update items matching criteria
node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js update \
  --board 12345 \
  --filter "status=Stuck" \
  --set "priority=Critical"

Update from File

node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js update-file \
  --board 12345 \
  --file updates.json

updates.json format:

[
  { "item_id": "123456", "columns": { "status": "Done" } },
  { "item_id": "123457", "columns": { "status": "Done", "date4": "2024-01-20" } }
]

BATCH EXPORT WORKFLOW

Export to CSV

node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js export \
  --board 12345 \
  --format csv \
  --output board_export.csv

Export to JSON

node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js export \
  --board 12345 \
  --format json \
  --include-subitems \
  --output board_export.json

Export with Filters

node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js export \
  --board 12345 \
  --filter "status=Done" \
  --columns "name,status,date4,person" \
  --format csv \
  --output done_items.csv

CROSS-BOARD OPERATIONS

Copy Items to Another Board

node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js copy \
  --source-board 12345 \
  --target-board 67890 \
  --filter "status=Done" \
  --column-mapping mapping.json

column-mapping.json:

{
  "status": "status_1",
  "date4": "date",
  "person": "owner"
}

Move Items Between Boards

node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js move \
  --source-board 12345 \
  --target-board 67890 \
  --items "item1,item2,item3"

Sync Boards

# One-way sync from source to target
node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js sync \
  --source-board 12345 \
  --target-board 67890 \
  --match-field "external_id" \
  --update-only

BATCH DELETE OPERATIONS

Archive by Filter

node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js archive \
  --board 12345 \
  --filter "status=Done,date4<2024-01-01" \
  --dry-run

# Execute if dry-run looks good
node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js archive \
  --board 12345 \
  --filter "status=Done,date4<2024-01-01"

Delete by Item IDs

node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js delete \
  --items "123,456,789" \
  --confirm

RATE LIMIT MANAGEMENT

Automatic Throttling

The batch manager automatically:

1. Monitors API rate limits (10,000/minute)
2. Adjusts parallelism when approaching limits
3. Implements exponential backoff on 429 errors
4. Queues operations during rate limit windows

Manual Rate Control

# Conservative mode (slower, safer)
node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js import \
  --file data.csv \
  --board 12345 \
  --batch-size 25 \
  --parallel 1 \
  --rate-limit 100

# Aggressive mode (faster, uses more quota)
node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js import \
  --file data.csv \
  --board 12345 \
  --batch-size 100 \
  --parallel 5

ERROR RECOVERY

Checkpoint/Resume

Large operations create checkpoints for recovery:

# Start operation (creates checkpoint)
node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js import \
  --file large_data.csv \
  --board 12345 \
  --checkpoint-dir ./checkpoints

# Resume from checkpoint after failure
node .claude-plugins/opspal-monday/scripts/lib/monday-batch-manager.js resume \
  --checkpoint ./checkpoints/import_20240115_123456.json

Error Report

Failed operations generate detailed error reports:

Batch Operation Report
═══════════════════════════════════════════════════════

Operation: import
Board: 12345
Started: 2024-01-15 10:00:00
Completed: 2024-01-15 10:15:32

Results:
  ✓ Succeeded: 485 items
  ✗ Failed: 15 items
  ○ Skipped: 0 items

Success Rate: 97.0%

Failed Items:
┌─────┬──────────────────┬────────────────────────────────┐
│ Row │ Name             │ Error                          │
├─────┼──────────────────┼────────────────────────────────┤
│ 23  │ Invalid Task     │ Invalid date format            │
│ 45  │ Missing Owner    │ Person 'x@y.com' not found     │
│ 67  │ Bad Status       │ Status 'Unknown' not in board  │
└─────┴──────────────────┴────────────────────────────────┘

Error Details: ./errors/import_20240115_errors.json

PERFORMANCE METRICS

Typical Performance

Operation	Items	Time (50/batch, 3 parallel)
Create	100	~15 seconds
Create	500	~60 seconds
Create	1000	~120 seconds
Update	100	~10 seconds
Update	500	~45 seconds
Export	1000	~20 seconds

Optimization Tips

1. Larger batches for homogeneous data
2. Higher parallelism during off-peak hours
3. Pre-validate data to avoid failed operations
4. Use filters to limit scope
5. Cache user IDs to avoid repeated lookups

EXAMPLE INTERACTIONS

User: "Import 500 tasks from tasks.csv to the Project board"

Agent:

1. Validate CSV structure against board columns
2. Map CSV columns to board columns
3. Preview first 5 rows
4. Request confirmation
5. Execute import with progress reporting
6. Report results and any failures

User: "Update all Stuck items to have Critical priority"

Agent:

1. Query items with status=Stuck
2. Show count and ask for confirmation
3. Execute batch update with progress
4. Report results

User: "Export all completed items from last month to CSV"

Agent:

1. Calculate date range
2. Query items with filters
3. Export to CSV
4. Return file path

OUTPUT FORMAT

Import Progress

Monday.com Batch Import
═══════════════════════════════════════════════════════

Board: Project Tasks (12345)
Source: tasks.csv
Items: 500

Progress: [████████████████████░░░░░░░░░░] 67%
Batches: 7/10 complete
Items: 335/500 created

Current Rate: 45 items/minute
ETA: ~3 minutes remaining

✓ Batch 1: 50 items created
✓ Batch 2: 50 items created
✓ Batch 3: 50 items created
✓ Batch 4: 50 items created
✓ Batch 5: 50 items created
✓ Batch 6: 50 items created
✓ Batch 7: 35 items created
◐ Batch 8: In progress...

Final Report

Monday.com Batch Import Complete
═══════════════════════════════════════════════════════

Board: Project Tasks (12345)
Duration: 11 minutes 23 seconds

Results:
  ✓ Created: 487 items
  ✗ Failed: 13 items
  ○ Skipped: 0 items

Success Rate: 97.4%

Performance:
  - Average: 43 items/minute
  - Peak: 52 items/minute
  - API Calls: 312

Errors saved to: ./errors/import_20240115_errors.json

Next Steps:
  - Review failed items in error report
  - Verify imported data in Monday.com
  - Run /asana-update if linked

INTEGRATION WITH OTHER AGENTS

• monday-board-manager: Create boards before batch import
• monday-item-manager: Handle individual item operations
• asana-task-manager: Cross-platform task synchronization