Find Jobs
Hire Freelancers

Develop a Google Apps Script.

$30-250 USD

Zamknięte
Opublikowano około 9 lat temu

$30-250 USD

Płatne przy odbiorze
We have the following piece of google apps script: [login to view URL] 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 [login to view URL] 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. I will only test three attempts on this project, after that I might stop testing if I don't see enough progress. function getUdgift_vist_i_bank_mail(){ [login to view URL]("1DHlLTznTTV2Y_0eHRCXp-DpPYMsuARDW2Z9Hgp8Y5iM").getSheetByName("Number of unimported attachments").getRange('a3:d500').clear() var thread = [login to view URL](); var messages = [login to view URL](thread); var row = 3; for (var i = 0 ; i < [login to view URL]; i++) { for (var j = 0; j < messages[i].length; j++) { [login to view URL]("1DHlLTznTTV2Y_0eHRCXp-DpPYMsuARDW2Z9Hgp8Y5iM").getSheetByName("Number of unimported attachments").getRange('a' + row).setValue(row-2); [login to view URL]("1DHlLTznTTV2Y_0eHRCXp-DpPYMsuARDW2Z9Hgp8Y5iM").getSheetByName("Number of unimported attachments").getRange('b' + row).setValue(messages[i][j].getAttachments().length); [login to view URL]("1DHlLTznTTV2Y_0eHRCXp-DpPYMsuARDW2Z9Hgp8Y5iM").getSheetByName("Number of unimported attachments").getRange('c' + row).setValue(messages[i][j].getFrom()); [login to view URL]("1DHlLTznTTV2Y_0eHRCXp-DpPYMsuARDW2Z9Hgp8Y5iM").getSheetByName("Number of unimported attachments").getRange('d' + row).setValue(messages[i][j].getDate()); row++; } } }
Identyfikator projektu: 7322959

Informację o projekcie

2 ofert
Zdalny projekt
Aktywny 9 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne

O kliencie

Flaga DENMARK
Copenhagen, Denmark
5,0
165
Zweryfikowana metoda płatności
Członek od sty 11, 2010

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.