Your automation created every order twice last night. How do you find and fix it?
Automation workflows · Beginner 3
Short answer
Stop the workflow, list the duplicates and clean them up with the business. Then check the run history: often the trigger fired twice, a webhook was retried after a timeout, or a step was rerun after a failure. Fix it with idempotency: a unique order ID checked before creating, and safe retries. Add an alert for unusual volumes.
Deeper answer
Duplicates are one of the most common automation bugs. Webhook senders often retry when they do not get a quick success response, and many platforms rerun failed executions. If your 'create' step does not check whether the record already exists, every retry creates another copy.
The standard fix is an idempotency key, usually the source system's order or event ID, stored and checked before creating anything. Respond to webhooks quickly and do slow work after. Then add monitoring: a count of records created per hour with an alert when it jumps.
What a strong answer covers
- Stops the workflow and cleans up with the business
- Checks run history or logs for the cause
- Names likely causes like retries or double triggers
- Fixes with idempotency or a unique ID check
- Adds monitoring or alerts
Answer it out loud in the mock interview about 1.5 min
Follow-ups to expect
- How would you clean up the duplicates safely?
- What is an idempotency key?
Common mistakes
- Deleting duplicates by hand and not fixing the cause
- Turning off retries completely
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?
- 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?
- A client's old billing software has no API. How would you automate data entry into it?
- 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?