How to find items that exist in SharePoint List and not in Excel?

[KamKam]

I'm working with a very large amount of data stored in an Excel sheet. Once a day a SharePoint list needs to be updated to reflect exactly what is on the Excel sheet. Because, of the large quantity of data, I'm trying to:

• Update the items when the primary key exists in both the SharePoint list and the Excel sheet.
• Delete the items with a primary key that exists on the SharePoint list but not in the Excel sheet.
• Create items with a primary key that exists in the Excel sheet but do not exist in the SharePoint List.

I've managed to do the update portion by using filter as illustrated below:

However, I am stuck on when to delete and create items.

What would be the best way to accomplish this?