Cancelled

Google Apps Script required to Parse emails to a Spreadsheet

We have a website thru which we sell pictures. Our shopping cart software on our website sends us an email each time there is a transaction.

E.g Email below. Get your own sample email by going to [url removed, login to view] and fill in a dummy order, you will not be charged anything.

-------Start of Example---------

Subject: A new order has been received [201206101206_01879]

CUSTOMER DETAILS

Customer name Anjana

Customer email [DELETED BY [url removed, login to view]]

Address rh-1 punit chs sectr 68 plot no 28 koperkhairne

Contact number 981982666

Additional requests

ORDER DETAILS

Items in this order S1_Shiamak_24

Item ID S1_Shiamak_24

Item Name S1-Shiamak--24

Options Size: 6"x8" Group Print

Unit Price [url removed, login to view]

Quantity 1

Total [url removed, login to view]

Item ID S1_Shiamak_29

Item Name S1-Shiamak--29

Options Size: 8"x12" Group Print

Unit Price [url removed, login to view]

Quantity 1

Total [url removed, login to view]

ORDER SUMMARY

Total Order Price [url removed, login to view] INR

-------End of Example---------

We need a solution that will automatically convert the emails to a spreadsheet either exc or google docs with each field of the email going into its respective column like:

Name. Email. Address. Number. Etc...

Please note that in the example email above there is only one item ordered, this can change to upto 15 items, soo each item will need to be in a separate column

Please respond with your proposed plan of action. If you feel te price quoted is not correct feel free to suggest.

If you would like to reccomended an off the shelf solution that's also fine. We will pay you a finder's fee

Update:

All email is sent and received via Google Apps (gmail)

We use Apple Mac so no Windows / PC Solutions please - only web based or platform agnostic

Your solution will need to either download the email from gmail or access it some other way - No outlook

Skills: Google App Engine, Javascript

See more: parse email address google, parse email google spreadsheet, www freelancer in contact number, www freelancer apps com, www docs google com, windows app freelancer, windows action script, windows 8 freelancer, web-based javascript spreadsheet, web apps google, use script in google spreadsheet, update the windows freelancer, update freelancer com, summary freelancer example, spreadsheet script google, spreadsheet script, spreadsheet javascript, spreadsheet in javascript, software solutions freelancer, software required freelancer, sell your app, sell thru, script google spreadsheet, sample google apps, rs solutions

About the Employer:
( 0 reviews ) Mumbai, India

Project ID: #4208499

9 freelancers are bidding on average $99 for this job

exwizzard

Hello, I have the required skills for developing the feature. Please check the private message for more details. Thanks!

$100 USD in 1 day
(2 Reviews)
3.8
brendonf

I have done something similar before. I would write a PHP script that would log into your Gmail, parse the data and then update a Google spreadsheet. Please see PM.

$90 USD in 0 days
(12 Reviews)
3.7
lcmarques

Hello, i can help you. Thanks, Luis

$300 USD in 10 days
(2 Reviews)
3.2
pbq

plan of action in pmb

$100 USD in 3 days
(2 Reviews)
2.8
GeorgeKazi

Hi! Please see your inbox.

$40 USD in 5 days
(1 Review)
2.7
cobycecil

Hi, got a great experience using Google App Engine and also Python, witch is cross-platform. Also this job seems pretty simple, just need a few more details. Thanks!

$40 USD in 4 days
(4 Reviews)
2.6
esafeguard

Ready to start. Regards.

$150 USD in 3 days
(2 Reviews)
1.9
samadhinie

Please check PMB

$35 USD in 4 days
(0 Reviews)
0.0
dgnwebs

Let me provide you with the script according to your requirements, just let me know.

$40 USD in 1 day
(0 Reviews)
0.0