What started as a cool thing when I got and hung online my twitter archive after seeing that Martin got his, he then put out there what seemed like a dream
— Martin Hawksey (@mhawksey) January 16, 2013
It took him like 24 hours to build this. See Keep your Twitter Archive fresh on Google Drive using a bit of Google Apps Script.
That’s right, all of thr history of the Twitter archive, but it automatically updates itself! Martin not only figured out how to do that via the Twitter API, but it runs completely in a Google Spreadsheet.
But wait there is nore.
You can store the whole thing on a Google GDrive, so you do not even need a web host to have your own, dynamically updated twitter archive.
Mine is alive and updating at
https://googledrive.com/host/0B3J3hv1B8VO1YUdCeHdRd3pBcVk/ Note (August 17, 2016) Google is nuking hosting web content but Martin has an end around — using the gibberish after .
/host/ (a folder ID), my archive is now at https://script.google.com/macros/s/AKfycbwrXr8ejYjHwGEO6kj8f4WHIh096ARDRHdNOgAXPqGltoa80FU/exec?folder_id=0B3J3hv1B8VO1YUdCeHdRd3pBcVk (which is now what I point http://tweets.cogdogblog.com to)
UPDATE: August 28, 2016: Scratch that. Martin has doubled his genius card points with his new script that now publishes the archive to GitHub Pages. A rather nice side benefit is that you can (I do) sync that locally using the GitHub desktop app or diving into command line land. I updated mine now hosted at https://cogdog.github.io/tweets and adjusted my domain forwarder to go there too.
Just for grins, I too a screenshot before I ran an update:
I then tweeted:
— Alan Levine (@cogdog) January 22, 2013
I updated the archive via Martin’s script, and check it out:
Is this not amazing? The Twitter Archive snapshot is updating itself, running in a public spreadsheet on a public drive. All I need to do is update my subdomain tweets.cogdogblog.com so it forwards to that ugly url (why does google make the ugliest freaking URLs?)
Martin’s spreadsheet has a setting to run the updates once a day, so it is fully automated. It even keeps a log of its work:
If you are one of the lucky shmucks like me with a twitter archive, give Martin’s script magic a try. The rest of ya? Keep behind the velvet ropes. And stop drooling in the red carpet.
Martin, you are a generous genius.
Someone call the castle and get this man knighted!