Notification Center: Sparrow notifications not removed automatically
You could just use temporary screen pop-ups, and disable the notification center:

You can set this per app.

Apple Menu -> System Preferences -> Notifications

Then, for Sparrow, choose Banners, not alerts.