Create a Google Apps Scripts library that will email Form Responses


I am in need of a Google Apps Script that will complete the following tasks once a Google Form response has been received to a Google Sheet:

- A 'confirmation' email is sent to the form submitter, showing all of the information that has been submitted. The email must use a Google Doc as the body template for easy editing.

- A 'response received' email is sent to one (or more) administrators, showing all of the information that has been received. Email addresses for the administrators should be stored in a new worksheet in the Google Sheets response file. The email must use a Google Doc as the body template for easy editing.

The Google Doc template will be something like this:


Hi <<Your Name>>,

Thank you, your form response was received on <<Timestamp>> and the a copy of the information submitted is below for your records.

<<Field Name>> :: <<Field Value>>




There will be lots of forms that need to have this functionality so the main chunk of the script needs to be made in to a library script.

Habilidades: Google App Engine, Javascript, Desenvolvimento de Software

Veja mais: template library, script sheets, scripts for google forms, script for google forms, library template, google scripts forms, google scripts for forms, google apps javascript, google apps email, c template library, apps scripts google, apps script google, Google Sheet Script, google forms scripts, google form scripts, all google apps, responses, library information, google-form, google sheet, google forms, google doc, google apps, google apps scripts, google apps script for sheets

Acerca do Empregador:
( 3 comentários ) Hamilton, New Zealand

ID do Projeto: #6819464

Concedido a:


Dear sir, I am expert on Google Apps Scripts. I have just finished one that work with spreadsheet. You can see a demo send file from spreadsheet with content here: [login to view URL] Mais

$8 NZD / hora
(21 Comentários)

2 freelancers estão ofertando em média $12/hora para esse trabalho


A proposal has not yet been provided

$16 NZD / hora
(0 Comentários)