Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Apps Script Emailer PDF maker from Doc Template
Rating: 4.8 out of 5(10 ratings)
2,070 students

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
Created byLaurence Svekis
Last updated 11/2024
English

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

2 sections • 23 lectures • 1h 13m total length

  • PDFs Generator Introduction.2:41

    Log spreadsheet data to populate a Google Docs template, generate PDFs, save them to Google Drive, and email customized documents via Google Apps Script.

  • Setup Google Apps Script4:12

    Set up a google apps script workflow to generate and email pdfs from a doc template by populating dynamic fields from a spreadsheet.

  • Google Apps Script Create Doc4:10

    Create a brand new Google Apps Script project named PDA maker, generate a document in Drive, and copy a template into the Docs folder while managing permissions.

  • Source Code0:02
  • Copy Doc move to Folder4:14
  • Source Code0:06
  • Update Doc Content5:17

    Copy the template to a new document in the same folder, open by id, replace first name and date in the body, then save and close.

  • Source Code0:09
  • Save as PDF from Google Doc using Apps Script3:12

    Learn to convert a Google Doc to PDF using Apps Script by exporting a blob, naming the PDF, saving it to a Drive folder, and preparing it for email attachments.

  • Source Code0:11
  • Send Email Apps Script4:55

    Attach a dynamically created pdf as a blob using the Google Apps Script session email and mail service to send content as an email attachment.

  • Source Code0:23
  • Get Sheet Data.5:00

    Learn how to fetch data from a Google Sheets spreadsheet using Apps Script, process the data array, populate a doc template, and generate PDFs for emailing and Drive storage.

  • Source Code0:05
  • Sheet Data as PDF Project 14:11

    Loop through spreadsheet data to generate pdfs from a doc template, creating copies in a folder, populating each with row-specific content, and preparing for emailing.

  • Sheet Data as PDF Project 24:30

    Conclude the project by converting a doc template to a pdf blob, then generate and email personalized pdf attachments using sheet data.

  • Source Code0:22
  • PDFs Generator Conclusion3:40

    Learn to generate PDFs via Google Apps Script from a flexible doc template by duplicating the template, populating it with spreadsheet data, and customizing fields, dates, and images.

  • Final Source Code0: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

Report abuse