Google PD Infrastructure Professional Learning Series

Automate Your District's PD Workshops Using Google Apps Script Professional Learning Series

Session Descriptions - Each session builds upon the last for a complete understanding of using Google Apps Scripts to automate your district's or organization's professional workshop series.

Each session will be 90 minutes in length, and will begin at 12:00 Noon, EDT. See the session dates below.

• Session 1: Data Collection and Preparation
  This session focuses on building a Google Form to register participants for your professional development workshop. You will prepare the Google Sheet that collects responses, create a Google Doc template for the mail merge, and learn to use the QUERY function to organize the registration data.

• Session 2: Scripting and Automation
  In this session, you will build the core automation tools. Key tasks include:

  • Reviewing the individual components of a Google Apps Script.

  • Creating a custom user menu in Google Sheets.

  • Writing the main mail merge function and its helper functions.

  • Generating personalized PDF documents from your template.

  • Automating the process of emailing the PDFs to registrants.

• Session 3: Integration, Testing, and Enhancement
  This final session will focus on putting all the components together. You will test the complete end-to-end workflow by sending a final registration document to a test participant. You will also learn to use Google's AI tool, Gemini, to modify and enhance the Google Apps Script for more sophisticated functions.

The support materials for each session will be available within the Practical Educational Pathways website.