Tamamlanmış

Sending automatic mails from spreadsheet

Hi,

I need to have a google spreadsheet were one person enters data, and when he finishes (by filling a cell with a word or a number), a mail is sent to his colleague with the data he entered. once a mail was sent a cell on the sheet should indicate that.

A mail for the same row can't be sent twice.

The number of rows in the spreadsheet are variable and goes up to 100.

Thanks

Need it as a script not a plug-in , Thanks

This is what i have so far:

function sendEmails() {
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2; // First row of data to process
var numRows = 100; // Number of rows to process
// Fetch the range of cells A2:B3
var dataRange = sheet.getRange(startRow, 1, numRows, 2)
// Fetch values for each row in the Range.
var data = dataRange.getValues();
for (i in data) {
var row = data[i];
var emailAddress = row[0]; // First column
var message = row[1]; // Second column
var subject = "Sending emails from a Spreadsheet";
MailApp.sendEmail(emailAddress, subject, message);
}
}

Beceriler: Javascript

Daha fazlasını görün: sending upto mails day, sending thousand mails day, sending bulk mails, sending automatic sms php, automatic numbers spreadsheet, script sending automatic mail, prevent facebook sending automatic invites, sending thousand mails, sending automatic email excell file, sending automatic advertisment bluetooth, sending automatic reminders php, sending million mails, internet sites commonly used india sending bulk mails, sending thousand mails address, automatic voting program xtreme top 100

İşveren Hakkında:
( 0 değerlendirme ) Israel

Proje NO: #16298761

Seçilen:

kishu0079

hello I have done this project.. please check this link. created by me. -->[url removed, login to view] I want your Daha fazlası

1 gün içinde 15$ USD
(0 Değerlendirme)
0.0

28 freelancers are bidding on average $27 for this job

1 gün içinde 25$ USD
(9 Değerlendirme)
4.2
InOutData

Hello! I may be able to set this up for you. I have a few questions though. 1: Are you using a free Google account or a paid g suite account? 2: You said the sheets go up to 100 rows, but how many emails will yo Daha fazlası

in 2 gün içinde30$ USD
(1 Değerlendirme)
0.7
akthar0025

Hello Sir I read your requirements and understand very-well and ready to start work from now. Let's discuss more about project in chat. Thank you My main skills include: • Data Entry • Data management • web scra Daha fazlası

1 gün içinde 10$ USD
(0 Değerlendirme)
0.0
akmsrkfl

Hello, I am Saidur Rahman Khan. I am very much interested in your project. I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills. I have a lot of e Daha fazlası

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
jayeshneema02

Hi, I would like to work with you, can we discuss more? you can know more about me here: jayeshneema dot com I, am Jayesh Neema having 5 Year Experienced Full Stack Developer with versatility of Technologies. Daha fazlası

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
singhnidhi13

Hi, Please let me know more about the project. So I could tell you about the work flow and the output. I have 4+ Year’s Experience Thank You

in 2 gün içinde30$ USD
(0 Değerlendirme)
0.0
gyogeshwar

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

1 gün içinde 20$ USD
(0 Değerlendirme)
0.0
pasipiya

I can do your work very quickly and attractively. Just give me a chance. If You are not satisfying I promise to refund your money. I am an undergraduate Electrical and Information engineering student. So I have skill t Daha fazlası

1 gün içinde 20$ USD
(0 Değerlendirme)
0.0
labibhasan01718

Hi, I am very much interested to do your offer. I am professional and vastly experienced in extracting data from different websites or anywhere on Google. I always ensure that what I do is very much accurate. My sk Daha fazlası

in 2 gün içinde12$ USD
(0 Değerlendirme)
0.0
smhossainazad

Hi, I have read about your job details and interested in your project. I'm properly skilled with php,mysql etc. I have done many works in other marketplace now I intent start my career here. I have bid mostly low co Daha fazlası

1 gün içinde 20$ USD
(0 Değerlendirme)
0.0
kmohandas

Hello We are interested to take up the work. Please let us have the details. Prepared to fill in a few entries to prove our ability. Please come for a chat and we will finalise. With warm regards Mohandas

1 gün içinde 25$ USD
(1 Değerlendirme)
0.0
ByteCode4

We Will give you the Best Result by using My experience and excellent academic skills on your project

1 gün içinde 20$ USD
(0 Değerlendirme)
0.0
sultanarime90

Hello, I saw your project and its details . I will use google spreadsheet & complete your project properly.I am ready to work with you .please send message and discus over chat. Thank you

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
SBITServices

Hello HAGAIDEV , I have done same work previously. I have 2 years experience in Google Scripts programming and can complete task within time with 100% [url removed, login to view] are very responsible towards our clients. We know our Daha fazlası

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
ikramhossien

job is clear just award me and send me file then right now i can start,thanks,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
sayantanmallik

Hello dear, I hope this proposal find you well, I saw your job posting online, I would like to request you please have a look into my previous works. I am a full-time freelancer with over 5 years of vast experience i Daha fazlası

in 3 gün içinde30$ USD
(0 Değerlendirme)
0.0
imraz2016

i am expert like this job just contact me and share list then i can start right now,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,thanks

1 gün içinde 20$ USD
(0 Değerlendirme)
0.0
emresurmeli

I am expert in MS Office especially in excel. I can use VBA language in excel. I have experience about 2,5 year in decision support reports to board members. I am good at making up documents,excel report for board mem Daha fazlası

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
somnath8726

Hi, We have an experience team work this kind of project. Please come on chat so we can discuss more about the project. Thank you.

1 gün içinde 19$ USD
(0 Değerlendirme)
0.0
ChloeKincaid

A proposal has not yet been provided

in 3 gün içinde138$ USD
(0 Değerlendirme)
0.0