Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I get sales notifications via email (Gmail) and I would like a way to parse these incoming emails for key information (purchase id, customer name, email, etc) and then import that into a Google Docs spreadsheet or something similar.

Does anyone have any recommendations for the best way to do this?

share|improve this question

migrated from superuser.com Sep 15 '11 at 14:05

This question came from our site for computer enthusiasts and power users.

2  
Just doing it online or using any client software / operating system? –  slhck Sep 15 '11 at 13:21
    
What is the format of the emails? Are they generated by a computer system, so they are a consistent structure? –  bwall Sep 15 '11 at 13:27
    
All done online if possible, if it'd have to be done on the client and I'd rent a virtual server for it. Usually work with Windows, but if Linux offers the best solution then I'd take that. But would much rather do this in the cloud. I was surprised not to find an app or service that could already do this. –  Rowan Sep 15 '11 at 13:48
    
Emails are in plain text format and the structure is consistent. –  Rowan Sep 15 '11 at 13:48
2  
Why was this migrated to Web Applications if using a client-side solution was acceptable -- just not the preferred option -- and the only answer so far is that you have to do this on the client-side. Perhaps revert the migration? –  Rowan Sep 15 '11 at 14:38

2 Answers 2

This is a web service that looks like it can do what you need:

http://www.cypressnet.com/Products/msgparse/service.htm

This is another interesting service, which can parse an email and post the results into a form on a web page. If the first option doesn't work, you might be able to get this to work, with a little configuration.

http://cloudmailin.com/

share|improve this answer

You have to have an application running that downloads the information and parses it. You can either use some sort of system service that does it, while the server is up of course, or simply a desktop application.

The service/application could do anything you want at that point with the imported data.

share|improve this answer

Your Answer

 
discard

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.