Completed

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);
}
}

Skills: Javascript

See more: sending upto mails day, sending thousand mails day, sending bulk mails, google spreadsheet send email when changed, automatically email google spreadsheet, google sheets send email based on date, google spreadsheet email notification script, google sheets send email based on cell value, google sheets email trigger, email google sheet as pdf, email google spreadsheet as attachment, data entry, data processing, excel, email handling, web search, sending automatic sms php, automatic numbers spreadsheet, script sending automatic mail, prevent facebook sending automatic invites

About the Employer:
( 1 review ) Tel Aviv, Israel

Project ID: #16298761

Awarded to:

kishu0079

hello I have done this project.. please check this link. created by me. -->[login to view URL] I want your More

$15 USD in 1 day
(2 Reviews)
2.4

27 freelancers are bidding on average $28 for this job

$25 USD in 1 day
(22 Reviews)
5.3
berngood

I have studied the requirements. I can do the job. No payment until the job is done. All I want from you is good review in return. I will give you highly secured site. can we chat

$15 USD in 1 day
(1 Review)
1.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 More

$30 USD in 2 days
(1 Review)
0.6
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

$25 USD in 1 day
(0 Reviews)
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 More

$25 USD in 1 day
(0 Reviews)
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. More

$25 USD in 1 day
(0 Reviews)
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

$30 USD in 2 days
(0 Reviews)
0.0
gyogeshwar

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

$20 USD in 1 day
(0 Reviews)
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 More

$20 USD in 1 day
(0 Reviews)
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 More

$12 USD in 2 days
(1 Review)
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 More

$20 USD in 1 day
(0 Reviews)
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

$25 USD in 1 day
(1 Review)
0.0
ByteCode4

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

$20 USD in 1 day
(0 Reviews)
0.0
ikramhossien

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

$25 USD in 1 day
(0 Reviews)
0.0
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 More

$10 USD in 1 day
(0 Reviews)
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 More

$30 USD in 3 days
(0 Reviews)
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% [login to view URL] are very responsible towards our clients. We know our More

$50 USD in 1 day
(0 Reviews)
0.0
imraz2016

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

$20 USD in 1 day
(0 Reviews)
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 More

$30 USD in 1 day
(0 Reviews)
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.

$19 USD in 1 day
(0 Reviews)
0.0