Google Apps Script Emailer PDF maker from Doc Template
4.7 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,026 students enrolled

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
4.7 (5 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,026 students enrolled
Created by Laurence Svekis
Last updated 4/2020
English
English [Auto]
Current price: $59.99 Original price: $99.99 Discount: 40% off
12 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 8 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to Apply Google Apps Script
  • How to write code to make things happen with GSuite
  • Explore what you can do with Google Apps Script
  • Connect GSuite Apps Together using Code
Course content
Expand 19 lectures 48:10
+ Introduction to coding Google Apps Script to make slides from Spreadsheets
19 lectures 48:10
Source Code
00:02
Copy Doc move to Folder
04:14
Source Code
00:06
Update Doc Content
05:17
Source Code
00:09
Save as PDF from Google Doc using Apps Script
03:12
Source Code
00:11
Send Email Apps Script
04:55
Source Code
00:23
Get Sheet Data.
05:00
Source Code
00:05
Sheet Data as PDF Project 1
04:11
Sheet Data as PDF Project 2
04:30
Source Code
00:22
PDFs Generator Conclusion
03:40
Final Source Code
00:46
Requirements
  • JavaScript
  • Prior Coding Experience
Description

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!

  1. Create a spreadsheet list out the first name, last name and email of the person.

  2. 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.

  1. Use Google Apps Script to list all the data from the spreadsheet

  2. Loop through the data populating the fields into new Google Doc created by Apps Script

  3. Create a PDF from the Google Doc - Save to your drive if you want!

  4. Send out the new PDF from the template with populated fields from the spreadsheet to the emails listed in the Spreadsheet

  5. 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.

Who this course is for:
  • Web Developers
  • Application Developers
  • Anyone who creates with Google Apps Script
  • JavaScript Programmers