I need to create a workflow to send an email containing the count of new items added weekly. We are adding items weekly so basically a count of items added such as : "You have 100 new items added".
This workflow needs to go to the specific user associated with the category. Such as the below:
If the category is West, and email goes to email@example.com
If the category is East, and email goes to firstname.lastname@example.org
How do I set this up?
PS I have SharePoint Designer