The other day I was browsing through Google's API documentation trying to figure out how to automatically create a spreadsheet to represent project health via Jira ticket priorities. On my last project I used to manually run filter for each feature to get the breakdown of Critical / Major / Minor issues, and then using a spreadsheet and color-coating I would make a heatmap of problem areas to help prioritize work.
For example, if I want to send an email, I simply write:
But the more I dug in, I found it's not just limited to Google API's. It's really not that hard to integrate other services as well. For example, the API documentation had an example which would grab XKCD's RSS feed and massage a change into the RSS feed. So, as a "hello world" I re-purposed the example script to send me an email whenever a new comic comes out. The email contains the comic, and the comic's caption.
The script looks like this:
After having this script setup for a couple weeks, I'm really happy with how it performs. I timed the interval so it arrives when I get to work, so I can read the latest comic as I sip my first coffee. I can see all sorts of applications for this. For example, I was able to connect to Jira and get information about bugs. I could take this info and turn it into a daily project status report, or make that heatmap I intended on building when I started this post ;)
Anyhow, the use-cases for this are endless, so go forth and hack and play! But remember, there are always limits (however they fairly reasonable ones).