Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 Spreadsheet.

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.

My question is, 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?)

share|improve this question
Does it have to come from email? Can you use a web form instead? – William Jackson Apr 7 '11 at 17:04
up vote 1 down vote accepted

As long as you don't need to parse the contents of the subject line, you can do this with If This Then That.

You'll need the Gmail and Google Drive channels. Specifically:


Depending on how you're going to identify the incoming message, you'll use one of the following triggers:

  • Any new email in inbox
  • New email in inbox from
  • New starred email in inbox
  • New email in inbox labeled
  • New email in inbox from search

"Subject" is one of the ingredients available, which you'll obviously need. There's other useful things, like "ReceivedAt".


You'll want Add row to spreadsheet where you'll defined the name of the spreadsheet, what goes in the row, and the folder path in Google Drive where it's located.

There are several recipes already shared that might service. This recipe, for instance, saves a new row for every received message.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.