Monday, September 03, 2012

Use Gmail and Google Docs to Easily and Quickly Track Anything [Quantified Self]

Source: http://lifehacker.com/5939539/use-gmail-and-google-docs-to-track-anything

Use Gmail and Google Docs to Easily and Quickly Track AnythingGoogle Docs and Gmail can be used together to create a simple yet flexible way of tracking just about anything. For example, you can easily track your expenses, create a workout log, or set up a food diary. Here's how.

The Power Tips for Google blog offers this awesome tip for setting up a form in Google Docs and then quickly accessing it in Gmail. The system is really easy to set up:

  1. Basically, create a spreadsheet in Google Docs and then go to Tools > Create form in the menu.
  2. Edit the form to add the items you want to record (e.g., date, amount, payment method, description, categories, etc.)
  3. Click on the "Email this form" button to email it to yourself.
  4. Whenever you want to add log something and have it entered into your spreadsheet, you can quickly submit the form from within that email.

That's it!

Use Gmail and Google Docs to Easily and Quickly Track AnythingWell, one more thing. For easy access to the form, enable the "Quick Links" lab feature (under Settings > Labs in Gmail) and you can add a permanent link to the form to your menu.

There are lots of ways you can use this. Our one-minute personal inventory form would be great to set up with this system. You can even share the form with other people, for simple group tracking.

Track Your Expenses Using Gmail and Google Docs | Power Tips for Google Docs