How to get CSV Upload and automations/actions to skip over dupes

I have set up actions/automations to add records to table 2 when a record is added to table 1.
I have a key field where table 2 prevents dupes from being created.
I do not mind if dupes are in table 1.

When manually/individually adding records and dupes to table 1 it will add the first record to table 2, but not the dupes that follow.... just how I want it to.

However when I do a csv upload where there are dupes, the action/automation breaks and does not add the records to table 2.

How can I work around this?

Essentially I would like the automation/action to skip the dupe and continue running skipping to the next line on the csv, instead of breaking.