O'Reilly logo

Learning Google Apps Script by Ramalingam Ganapathy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The DriveApp class

This class allows you to create, search, and modify files and folders in your Drive.

For reference documentation on the DriveApp class, refer to the website: https://developers.google.com/apps-script/reference/drive/drive-app?hl=en.

Creating customized PDF files

Imagine that you need to create customized PDF files from the Sheet or external data. We can create PDF files from the HTML template. You simply need to format column headers and put some sample data in a new Sheet (AddressBook) as shown in the following screenshot:

Creating customized PDF files

Create the createPdfs function in the Code.gs file as listed here:

function createPdfs(){ // 0 based column numbers ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required