Lengkap

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

Kemahiran: Javascript

Lihat lagi: 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

Tentang Majikan:
( 0 ulasan ) Israel

ID Projek: #16298761

Dianugerahkan kepada:

kishu0079

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

$15 USD dalam sehari
(0 Ulasan)
0.0

28 pekerja bebas membida secara purata $27 untuk pekerjaan ini

$25 USD dalam sehari
(9 Ulasan)
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 Lagi

$30 USD dalam 2 hari
(1 Ulasan)
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 Lagi

$10 USD dalam sehari
(0 Ulasan)
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 Lagi

$25 USD dalam sehari
(0 Ulasan)
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. Lagi

$25 USD dalam sehari
(0 Ulasan)
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 dalam 2 hari
(0 Ulasan)
0.0
gyogeshwar

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

$20 USD dalam sehari
(0 Ulasan)
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 Lagi

$20 USD dalam sehari
(0 Ulasan)
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 Lagi

$12 USD dalam 2 hari
(0 Ulasan)
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 Lagi

$20 USD dalam sehari
(0 Ulasan)
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 dalam sehari
(1 Ulasan)
0.0
ByteCode4

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

$20 USD dalam sehari
(0 Ulasan)
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

$25 USD dalam sehari
(0 Ulasan)
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 Lagi

$50 USD dalam sehari
(0 Ulasan)
0.0
ikramhossien

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

$25 USD dalam sehari
(0 Ulasan)
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 Lagi

$30 USD dalam 3 hari
(0 Ulasan)
0.0
imraz2016

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

$20 USD dalam sehari
(0 Ulasan)
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 Lagi

$30 USD dalam sehari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
0.0
ChloeKincaid

A proposal has not yet been provided

$138 USD dalam 3 hari
(0 Ulasan)
0.0