Google scripts to send a customized email with PDF to owner and user when user submits google form
$30-250 SGD
已完成
已发布超过 3 年前
$30-250 SGD
货到付款
I did a google forms for my colleagues to order items, it is linked to a google sheets so that I can keep count. But I need someone to use google app script to code so that an email will be sent to me and whoever that submits the form. The email should show the item, size, quantity, as well as the order ID generated in the google sheet. Some items have sizes, some doesn't. The size should reflect on the form if there is, and disappear when the item does not have a size. The email should have those in the Email Body and a PDF which I will give you in google docs format.
On form Submit, you can do anything
[login to view URL] a mail to the person ordering it (his email ID will be needed)
[login to view URL] a mail to you
[login to view URL] any google sheet with information fed in the form or any other linked information from any other sheet (linked by a key value)
[login to view URL] PDF containing any image and table etc. The PDF can have information from any other linked sheet (linked by a key value)
I have done all these and much more in a number of my projects.
I will provide you a solution exceeding your expectations. I have over 3 decades of experience and 7 years in Google Sheets/forms etc
Hello there,
I have carefully read your requirements and can confirm that I can deliver the work in given timeframe and budget. Kindly provide me the google login so I can start working on it. Thanks