I'd like to be able to extract tasks from the subject line of an email in Gmail (using some sort of custom syntax) and then insert the task as a row in a shared Google Sheets.
Currently the best way I've thought of doing this would be to write a Gmail Contextual Gadget. The main downside to this is that I'd have to start using Google Apps just to get this functionality.
Are there any other ways to achieve this?
Also, does anyone know if Gmail Contextual Gadgets work on Google Apps or does it require the Google Apps for Business?