In Progress

Simple add row to google spreadsheet from email

I would like a script to automatically add a row to an existing google spreadsheet whenever an email is received.

Functionality:

- Email arrives into an existing gmail account (dedicated for this purpose)

- The subject line contains data for the new row, with each column delimited by “~” characters. E.g.

Subject line: “Organise a meeting with Mike~5~URGENT”

The script would then create a new row in the google spreadsheet with the following information:

Column 1 value: “Organise a meeting with Mike”

Column 2 value: “5”

Column 3 value: “URGENT”

- There is a Google Spreadsheets API available with functionality to add rows: [url removed, login to view]

- The script needs to be hosted with a free hosting service which you will need to select & configure (search “free php hosting” for a list). I need this hosted this so I can maintain it myself please (i.e. not hosed on your hosting or shared hosting somewhere).

- You will probably need to set the script up as cron job to poll for new emails from the gmail account every minute (unless the free hosting comes with an email address you can take content directly from?)

Other points:

- Basic documentation required please (e.g. account & ssh details for the free hosting, location of the script, etc)

- The script needs to scale if more “~” signs are used (e.g. if there are 5 “~” characters in the subject, 6 values/columns are present)

- Only information in the subject line should be used to create the new row. Any data in the body should be ignored.

- Login details for the gmail account & google spreadsheet will be provided to the successful bidder.

Many thanks

Skills: PHP, Software Architecture

See more: add row spreadsheet email, email row spreadsheet, spreadsheet script google, spreadsheet script, simple free php code, service spreadsheet, script google spreadsheet, php code google search, location service google, job spreadsheet, html spreadsheet code, html spreadsheet, html email hosting, google spreadsheet script api, google spreadsheet html, google search php api, google login script, google location service, google html email, gmail architecture, gmail automatically add spreadsheet, spreadsheet google, google script spreadsheet, email g, take google

About the Employer:
( 2 reviews ) Hampton Wick, United Kingdom

Project ID: #1117506

Awarded to:

eduardobaret

Read PM please

$110 USD in 1 day
(3 Reviews)
3.3

1 freelancer is bidding on average $110 for this job

ahmed613

PHP expert with Google APIs..

$110 USD in 1 day
(60 Reviews)
4.9