You can use a Google Apps Script for that, similar to what this guy did

https://news.ycombinator.com/item?id=40373060