Yes: http://bit.ly/lerK1S
(This is a time series graph of the count of my GMail spam folder since 2009, updated daily.)
(This is a time series graph of the count of my GMail spam folder since 2009, updated daily.)
I wish I'd had your foresight and set this up earlier, but now I'm glad I didn't let that prevent me from doing it anyway; it's always fun to play scientist. :)
Also how do you automate the counting and storing it in the spreadsheet? I think that's pretty damn cool.
As to how - cron job on my server querying GMail via IMAP. Source below. Manually copy and paste the resulting text file to a GDoc spreadsheet; use the Time Series widget to generate the chart.
require 'net/imap'
require 'date'
imap = Net::IMAP.new('imap.gmail.com',993,true)
imap.login('yourlogin','yourpwd')
msgs = imap.status("[Gmail]/Spam",["MESSAGES"])["MESSAGES"]
puts Date.today.to_s + "\t" + msgs.to_s