Use Google Apps Script to handle emails from Gmail

Cancelled Posted Feb 27, 2015 Paid on delivery
Cancelled Paid on delivery

We have the following piece of google apps script:

[url removed, login to view]

Text version of the code found at the bottom of this post.

I need someone to adapt that solution so it retrieve new messages and based upon the messages received, run an ultradox. This is done by simply having the google apps script visit a web page, which executes the ultradox, I believe you can use URL parameters to get parameters sent to ultradox. Please make the ultradox send an email in return with the texts seen below (for example: "If a customer sends an email with no attachment").

A different ultradox should be run for the following scenarios so that we can send individual emails in each case:

For email account 1:

- If a customer sends an email with no attachment

- If a customer sends an email where at least one of the attachments is not a csv file

- If a customer sends an email that is not empty with only and attachment. It is alright with spaces and new-lines but the email should have no text

For email account 2:

- If a customer sends an email with no attachment

- If a customer sends an email that is not empty with only and attachment. It is alright with spaces and new-lines but the email should have no text

- If a customer sends an email with at attachment if the type .xls

Please create both test gmail accounts (two) and ultradox account at [url removed, login to view] and tell me the gmail addresses so I can test the live solution by sending emails to it, once you have finished this task. If I for example send an email to one of the gmail addresses with an attachment of the type xls, then I expect an email in return with the following text:

"- If a customer sends an email with at attachment if the type .xls"

Max price: 100$

If I see nothing in your bid indicating that you have actually read this description and understood it, then I will not accept your bid.

function getUdgift_vist_i_bank_mail(){

[url removed, login to view]("1DHlLTznTTV2Y_0eHRCXp-DpPYMsuARDW2Z9Hgp8Y5iM").getSheetByName("Number of unimported attachments").getRange('a3:d500').clear()

var thread = [url removed, login to view]();

var messages = [url removed, login to view](thread);

var row = 3;

for (var i = 0 ; i < [url removed, login to view]; i++) {

for (var j = 0; j < messages[i].length; j++) {

[url removed, login to view]("1DHlLTznTTV2Y_0eHRCXp-DpPYMsuARDW2Z9Hgp8Y5iM").getSheetByName("Number of unimported attachments").getRange('a' + row).setValue(row-2);

[url removed, login to view]("1DHlLTznTTV2Y_0eHRCXp-DpPYMsuARDW2Z9Hgp8Y5iM").getSheetByName("Number of unimported attachments").getRange('b' + row).setValue(messages[i][j].getAttachments().length);

[url removed, login to view]("1DHlLTznTTV2Y_0eHRCXp-DpPYMsuARDW2Z9Hgp8Y5iM").getSheetByName("Number of unimported attachments").getRange('c' + row).setValue(messages[i][j].getFrom());

[url removed, login to view]("1DHlLTznTTV2Y_0eHRCXp-DpPYMsuARDW2Z9Hgp8Y5iM").getSheetByName("Number of unimported attachments").getRange('d' + row).setValue(messages[i][j].getDate());

row++;

}

}

}

Google App Engine PHP

Project ID: #7216671

About the project

1 proposal Remote project Active Feb 28, 2015

1 freelancer is bidding on average $309 for this job

prashushinde9

Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bu More

$309 USD in 10 days
(21 Reviews)
5.7