Completed

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: automatically add google spreadsheet row email received, add row spreadsheet email, email row spreadsheet, google spreadsheet add row email, email add rows google spreadsheet, email add row google spreadsheet, php add row google spreadsheet, gmail automatically add row google spreadsheet, spreadsheet script google, spreadsheet script, spreadsheet in html, simple free php code, service spreadsheet, script google spreadsheet, php code for google search, location service google, job spreadsheet, html to spreadsheet, html spreadsheet code, html spreadsheet, html email hosting, google spreadsheet script api, google spreadsheet html, google search php api, google search api php code

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