Google scripts to send a customized email with PDF to owner and user when user submits google form

$30-250 SGD

Completed

Posted

over 3 years ago

$30-250 SGD

Paid on delivery

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.

Google Sheets

JavaScript

HTML

Project ID: 28390147

About the project

4 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@aruls1962

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

$75 SGD in 2 days

4.3

(2 reviews)

1.3

4 freelancers are bidding on average $169 SGD for this job

@dragunor

i will make script that send email on submitting google form please ping so we can start asap thank you

$200 SGD in 7 days

4.8

(7 reviews)

2.9

@abdullahmunir11

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

$200 SGD in 7 days