New Apps Script - Basic level

Among the office suite of applications, Google offers one of the easiest to use suites. It includes Apps Script, a tool for programming and automating various office applications. With a basic knowledge, you should be able to write applications to access, modify files, send emails without any programming skills. The training is therefore best suited for those who are already familiar with Google Workspace office applications and want to learn Apps Script programming.

First steps

• Development Environment and Source Code

Basics

• JavaScript
• Cycles and Branches
• Variables
• Calling a program from another program
• Standalone and Bound

DocumentApp

• Creating a document
• Accessing a document
• Document content
• Writing to a document
• Using part of a document
• Formatting a document
• Editing document text
• Copying the content of a document

SpreadsheetApp

• Create a workbook
• Access Workbook
• Access spreadsheet data
• Write data to Cells
• Formatting cells
• Copying spreadsheet data to a document
• Creating and copying a worksheet
• Copying data with parameters
• Worksheet properties
• Write data to spreadsheet
• Deleting data from a spreadsheet
• Bound script in Tables
• Custom functions with formulas
• Using functions

DriveApp

• Accessing files
• Accessing a folder
• Creating a folder
• Create a file in a folder
• Listing file data in a spreadsheet
• Delete a file
• Copy files
• Copy a folder

GmailApp

• Send Email
• Create a snippet
• Add attachment
• Send email from HTML template
• Send multiple emails together from a spreadsheet

Computer and Windows skills and practice. Completion of the Computer and Windows Basics course, or knowledge of the course.