GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Script or add-on to extract specific data from gmail or pop?

mkx · 03-26-2013, 12:49 AM

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?

03-26-2013, 12:49 AM
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	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?