Wow, long time no posts. It might be a bit weird to review your own tool, but someone might find this useful.
Bit.ly is great for creating and editing links used in multiple locations - particularly useful if you don't remember where you used them. But do you want to manage your bit.ly links more efficiently? Check if they are still valid URLs? Keep a backup copy of your links in a spreadsheet?
This Google spreadsheet draws on the bitly API to pull out the links, then runs a script to check the status of the full URL on a ‘Link summary’ page. I’ve colour coded the main response codes to indicate real (red) problems and potential (orange – login may be needed).
Early days, but this spreadsheet can be re-purposed for any bitly library – you just need to generate an access key at https://bitly.com/a/oauth_apps from your own login and add it to cell B1 in the ‘data’ sheet. It currently processes up to 1000 links, but you can easily change this. I would recommend making a copy of the values in a new sheet too, just in case there is ever a bit.ly disaster.
Here's a link to a public version - please save as a copy before adding your access key or the world will know how to access your bit.ly links!
As ever, I am standing on the shoulders of giants, so great credit must go to the component writers:
JSON import: Trevor Lohrbeer (http://blog.fastfedora.com/projects/import-json)
URL checker: Cheok Luk (http://www.tinkeredge.com/blog/2012/04/check-on-page-for-broken-links-with-google-docs/)