I have an automation that looks for new records and then copies relevant data to another tab. However! The new records are coming across from an API that often creates duplicates (I can't access/ change this part) and my automation is also creating duplicates (despite setting up a Find function to avoid this) I think because the automations happen so fast they don't have time to find the double? The older records don't duplicate if that makes sense, just when a new set of two gets made via the API.
I tried setting the automation to trigger at a given time each day, but then my Find action doesn't work as it can't check a string against text if that makes sense.
Thanks for your help - here is a screenshot. The API runs daily at midnight, creating duplicate records in the same table. No links (as the API-linked sheet will overwrite daily so can't/ don't want to link to it). Does that help give more info? A delay between runs for the automation sounds ideal if possible! thanks so much