A client's old billing software has no API. How would you automate data entry into it?
Automation workflows · Beginner 3
Short answer
First look for another way in: an import feature, a supported database or file import, or a newer version with an API. If none exists, use RPA to drive the screen like a person would, with a dedicated bot account, checks after each entry, screenshots and logs, and an alert when the screen changes.
Deeper answer
RPA works through the user interface, so it is slower and breaks when screens change. It is the right choice when there is truly no better option and the volume justifies it, but it needs care.
Good RPA design uses stable selectors, waits for screens to load, verifies each saved record, runs under its own account with only the permissions it needs, and keeps a queue so failed items can be retried. Agree with the client who maintains it, and document it, because these bots need regular attention.
What a strong answer covers
- Looks for imports, files or other integration first
- Uses RPA as the fallback, driving the interface
- Uses a dedicated bot account with limited rights
- Validates entries and logs with screenshots
- Plans for maintenance and breakage
Answer it out loud in the mock interview about 1.5 min
Follow-ups to expect
- What makes RPA bots break?
- How would you test it before going live?
Common mistakes
- Jumping to RPA without checking for import features
- Running the bot under a person's login
Learn it
- Design an automation that reads supplier invoices from email and enters them into accounting software.
- An API your workflow calls starts returning 429 errors. What do you do?
- Your automation created every order twice last night. How do you find and fix it?
- Tell me about an automation you built and how much time it saved.
- How would you build AI triage for a support inbox?
- The AI in your invoice automation sometimes reads the total wrong. How do you stop wrong amounts reaching the accounts?
- An API returns JSON in a different shape from what the next app needs. How do you handle it?
- How do you measure the return on an automation project?
- How would you choose between n8n, Zapier, Make and Power Automate?
- When would you use RPA instead of an API integration?
- Walk me through building a simple automation in n8n or Zapier.
- What is a webhook, and how is it different from polling?
- How do you decide which process to automate first?
- How would you design a WhatsApp assistant for a small business, and when should it hand over to a person?
- Your automation fails halfway through. How do you design for that?