Script or add-on to extract specific data from gmail or pop?
 

I am trying to automate my business a bit more by adding a couple time saving features for email handling. I currently use gmail with both pop accounts and standard gmail accounts. I am looking for the best way to do the following.

1. When I get "UPS Quantum View" tracking information emails, I want to extract both the tracking number and the reference number (both will always be in the same spot of the email) from the email and plug it into my order database through either a php link or sql insert.

2. When a customer emails me whom already ordered from me, I want a script or add on to look up the customers email in my order db to see if they already ordered from us, if so I would like to link to or display the order number somewhere in the window.

Are there any cool chrome add-ons or open source scripts that I can play with that might be able to pull this off or do I need to find a programmer?

bumpity bump

Look at Grease Monkey. No idea if it will do all of what you want, but you can tweak the hell out of Gmail with it. Someone may have already made what you're looking for. Other than that, no idea.

First mistake, using pop3 for your emails. I hope you have the option "Leave on server" enabled.

Second mistake, wanting an add-on to accomplish this. What you really want is a script which will log in to your gmail account, find said emails, extract the tracking number, and then update the database.