How can I build a workflow that sends internal notifications on activity count?

There are a bunch of ways you could approach this but would it not be easier to put a weekly activity report on a dashboard and set the dashboard to send itselft to you once a week?