The fastest way to understand this project is to watch this 2:27 video: [url removed, login to view]
As an administrator of an existing Google Sheet and Custom Script, I can already highlight a row in the Google Sheet and click custom button called "Document Creator" and it automatically creates a new google document based on the existing custom script. This is great but I also have to then click the newly created document file in my Google Drive, download the PDF, and then open a separate email to send the attachment to the recipient. This is time consuming.
The goal of this project is so that as an administrator, when I click "Document Creator" I would like the script to also generate and send a specific email with attachments to the specified users and email addresses contained within that highlighted row of this same Google Sheet.
Attached is the existing Google Sheet script for your reference. Upon award of this project, you will be given full access to the current Google Sheet as well as the email format and attachments to send. Thanks!
Hi, I watched your video explaining what you want to be done and I can do it. It`s a small modification to be done in your script, just send me the template of the e-mail. Best regards.