Skip to content
UI Automation

Batch Data Entry Automation

Enter multiple records into apps without APIs through UI automation

The Problem

You have 20 expense reports to submit, 15 contacts to add to a CRM, or 30 form entries to complete. The app has no API or import function. Doing it manually means repetitive clicking and typing for hours.

The Workflow

Step 1: Prepare Your Data

Give AI the records to enter.

Prompt to use:

I need to enter these 5 expenses into the Expensify web app:

1. Jan 15: $45.50 - Meals - "Team lunch at Cafe Milano"
2. Jan 16: $22.00 - Travel - "Uber to client office"
3. Jan 17: $89.99 - Office - "Wireless keyboard"
4. Jan 18: $12.50 - Meals - "Coffee meeting"
5. Jan 19: $156.00 - Travel - "Train to conference"

For each one, I need you to:
1. Click "New Expense"
2. Fill in the date, amount, category, and description
3. Click "Save"
4. Wait for the form to reset before the next entry

Step 2: Watch the First Entry

AI performs the first entry while you verify.

Example output:

STARTING BATCH ENTRY (1 of 5)

Clicking "New Expense" button...
Filling form:
  - Date: Jan 15
  - Amount: $45.50
  - Category: selecting "Meals"
  - Description: "Team lunch at Cafe Milano"
Clicking "Save"...

✓ Entry 1 complete. Proceed with remaining 4?

Step 3: Continue or Adjust

If something needs adjustment, correct it before continuing.

Prompt to use:

The category dropdown uses "Food & Drink" not "Meals".
Use that category instead and continue with the rest.

Step 4: Review Results

After completion, verify all entries.

Prompt to use:

Done. Now check the expense list to confirm all 5
entries appear correctly.

Expected Result

Multiple records entered into any application through UI automation, turning hours of repetitive data entry into a supervised automated process.

Tools Used

This workflow uses the UI Automation toolbox:

ToolPurpose
ui_viewer_get_ui_treeAnalyze form structure
ui_viewer_find_elementsLocate form fields and buttons
ui_controller_clickClick buttons and dropdowns
ui_controller_type_textEnter text values

Tips

  • Always watch the first entry to catch any issues
  • Use clear, consistent data format for AI to parse
  • Break large batches into smaller sets (10-20 at a time)
  • Save a backup of your data before starting

Ready to automate your Mac?

Download Macuse to use this workflow with Claude Desktop, Cursor, Raycast, and more.

Download for macOS