Closed

Google Apps Script required to Parse emails to a Spreadsheet

This project received 9 bids from talented freelancers with an average bid price of $99 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
9
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online