custom scripts+Google docs email automatic response

Services required: Google Mail, Google Form, Google Spreadsheet

Create custom script on Google spreadsheet that links to a form and automate an email response back to the email address merge-tagged with a unique value.


1. Administrator copy and pastes 8 digit voucher codes in Column E from another source (e.g. all the way to row 1000)

2. Anonymous fills out a form with First Name, Last name, Email address and click submit.

3. Email addresses gets inputted onto the spreadsheet by the system; script validates the email address and sends an html response along with a value in column E (one voucher code) to that email address.

*if email address is not valid, don't send the email.

*one email submitted gets one unique voucher code only, no voucher code should be sent to two different addresses.

*only one submission is allowed from the same email address

Taidot: CSS, HTML, Javascript

Näytä lisää: spreadsheet script google, spreadsheet javascript, script google spreadsheet, valid email address, mail merge google, html spreadsheet code, html css javascript codes, google spreadsheet html, google scripts spreadsheet, google mail merge, google html email, google docs scripts, google docs mail merge, google docs mail, google docs email merge, email valid, email address valid, spreadsheet google, google spreadsheet scripts, google script spreadsheet, google form scripts, email g, anonymous mail, valid email, first name email

About the Employer:
( 24 reviews ) Toronto, Canada

Projektin tunnus: #1710569

1 freelanceria on tarjonnut keskimäärin 250 $ tähän työhön


Custom software development - <b><i>Removed by Admin</i></b>

250 $ CAD 1 päivässä
(0 arvostelua)