Google Apps Script Emailer PDF maker from Doc Template
Using a Google Doc Template - Populate the data from a Spreadsheet - Generate PDFs and email them to the listed emails
https://www.udemy.com/course/learn-google-apps-script-course/?couponCode=NEWCOURSE
JavaScript is a prerequisite to this course !!!!!!!! The course demonstrates Applying Google Apps Script to create a time saving micro application making use of GSuite apps connected together to produce amazing functionality.
Source Code is included
Do you need to send a bunch of custom PDFs to a group of email recipients - of course you already have it listed in a Google Spreadsheet. Wouldn't it be nice if this could be done with a simple script. You're in luck!
-
Create a spreadsheet list out the first name, last name and email of the person.
-
Create a Google Doc which can be used as a template with firstname lastname and data fields
Now the fun part - coding with Google Apps Script.
-
Use Google Apps Script to list all the data from the spreadsheet
-
Loop through the data populating the fields into new Google Doc created by Apps Script
-
Create a PDF from the Google Doc - Save to your drive if you want!
-
Send out the new PDF from the template with populated fields from the spreadsheet to the emails listed in the Spreadsheet
-
Thats it all done with a simple Google Script.
Google Apps Script is a cloud based JavaScript Language that lets you power up your Gsuite and do some unbelievable things - saving you time. Like magic - great to amaze your coworkers :)
Taught by an instructor with many years of REAL World web development - Google Developer Expert!!!
Please note that this is a project based course and is fast paced focused on the project that is outlined in this description.
Get Courses Taught by Laurence Svekis
Connect with Laurence Svekis
Contact