Removing Duplicates

Khari Shiver

Hello,

I have a sheet that I am going to import data into via Data Shuttle that contains a list of requests that need to be approved by a manager. Once the data is imported, I am going to set up an automation that sends an email notifying the manager they have a pending request. The challenge is one manager's email address may appear on the sheet more than once and I only want one email to be sent.

I think I need to find a way to move only one instance of each email address to another sheet and send the alert from the secondary sheet. All that said, I'm not sure how to approach and solve this one. Any advice would be extremely helpful.

Also I currently have two date columns in the system that are generally two days apart if that helps with a solution.

Thank you in advance.

Paul Newcome

I would suggest a time based trigger for your automation. If you have it sent daily, it should group all applicable rows into a single email.