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:
| Tool | Purpose |
|---|---|
ui_viewer_get_ui_tree | Analyze form structure |
ui_viewer_find_elements | Locate form fields and buttons |
ui_controller_click | Click buttons and dropdowns |
ui_controller_type_text | Enter 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
Related Workflows
- Menu Navigation - Find app commands
Ready to automate your Mac?
Download Macuse to use this workflow with Claude Desktop, Cursor, Raycast, and more.
Download for macOSRelated Workflows
Learn More
Your AI Agent Doesn't Need 5 Tools to Control Your Mac
A technical look at consolidating OpenClaw's fragmented macOS skills into a single MCP server with native API access to Calendar, Mail, Notes, and more.
See Your Emails and Events Right in the Chat
Macuse 1.4 brings MCP Apps to your AI chat. See emails, calendar events, notes, and reminders as visual cards. Click to open directly in native Mac apps.