Terminé

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

Compétences : Javascript

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Israel

Nº du projet : #16298761

Décerné à:

kishu0079

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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(0 Commentaires)
0.0

28 freelance font une offre moyenne de $27 pour ce travail

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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. Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
gyogeshwar

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
0.0
ByteCode4

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
ikramhossien

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
imraz2016

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
ChloeKincaid

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0