Fermé

Script Editor Google Sheets - Auto Email

I have a form that is connected to a sheet and I would like the following to happen when a someone submits a response:

* An auto email to be send with all the information on the spreadsheet in that row.

The auto email on the google sheet is not sufficient as once they submit their responses there is a calculation that is done on the spreadsheet that give a final score.

So I want all of this information emailed to the person who submits the form.

The email is in Column B

Response data is from B to O

Calculated SCORE is Column Q

I believe it is a script, so I am looking for someone to type this script and get it working for me. I can provide the access to the sheet or you can write the script and give to me.

Compétences : PHP, Javascript, Excel, Architecture Logicielle, HTML

en voir plus : google apps script email template, google apps script send email with attachment, send email when value changes in google spreadsheet, google sheets send email when cell value changes, automatically email google spreadsheet, google sheets send email when new row added, google sheets send email based on date, send email when google sheet is updated, auto email batch script, auto email script, auto email confirm script, auto email confirmation script, windows auto email script, write php script translate google, perl email write script, auto email google spreadsheet, outlook auto email script, craigslist auto email script, vba auto email script, script update cell google sheets

Concernant l'employeur :
( 4 commentaires ) Merrylands, Australia

Nº du projet : #21258786

14 freelance font une offre moyenne de $24 pour ce travail

BaNgan

Hi, I can use Google Apps script to detect when new row added and use SendMail() method to collect the send the email with dynamic info Thanks Ngan Le

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(321 Commentaires)
7.3
amitbanerjee2812

Dear Hiring Manager, I read your job description and I am confident that I can exceed your expectations. I am a professional programmer on PHP+MySQL+WordPress. Please have a look at my recent work for WordPress : 1. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(27 Commentaires)
5.2
SamerHany

Hi there, I have 5+ years of experience in scripting and automation. Would love to help with your project. Please feel free to contact me to discuss further details. Regards, Samer

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(9 Commentaires)
3.8
PageOllice

Hello, I am interested in your project and would like to invite you for further discussion. Waiting for your positive reply! Regards, Page M. O.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(7 Commentaires)
3.4
corporatessc

Hey there, I have understood your requirement, you wish to automatically send an email whoever submits a Google form along with the additional data from the attached spreadsheet. Prior calculations will be done befor Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(6 Commentaires)
3.2
prashant2621

Hello Sir/Mam, APComp is one of the best providers of software development and other professional IT services. We have over 5 years in the software development field and a long list of satisfied customers. We know tha Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(10 Commentaires)
2.6
ammaraunitech

Hello! I am very interested in your post project. I am really looking for this kind of project for a long time in freelancer since I have rich experience on it. I think this project is very suitable for me and I am su Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(1 Évaluation)
1.6
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
NancyObasi

I have read the project details and I'm certain, i can do handle this project well Relevant Skills and Experience PHP, Java Script, Data Entry

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(0 Commentaires)
0.0
stephenL2E

You do not need a script. Message me and I will show you how you can do it easily, and any other similar stuff.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
ngururani

I have experience working on Microsoft tools and can help accomplish this task. For exact timeline, I need to understand the exact requirements.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 18 jours
(0 Commentaires)
0.0
Rodylyn

Hi! I am applying for a Virtual Admin or Personal Assistant and I can help you to do the task well. I have the following experiences and area of expertise. · 12 years of hands-on experience in Payroll, billing, o Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(0 Commentaires)
0.0
yousafkh9

Hi, I have program ready and saved in my drive. I only need 30 minutes to install program in your sheet and we are good to go. Link: [login to view URL] Program features 1: dynamic email, th Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
ppfk

Hello. I have read and understand your project completely. Let me start by pointing out that I have already created this kind of automated sheet before in Google using Google Apps Script, where an email is sent to a pe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0