IWD 2023 – Dare To Be Ottawa Laurence Svekis Power Up with Google Apps Script

Power Up with Google Apps Script Celebrate International Women’s Day with a full-day event featuring a Google speaker and Google Developer Experts on topics such as leadership, web technologies, Google Cloud Platform, Firebase, data analytics, machine learning, augmented reality and more.

About this event

Join us on April 23 from 11 am-2pm for an exciting full-day event to celebrate International Women’s Day arranged by Women Techmakers and GDG Cloud Ottawa. We have lined up a fantastic lineup of speakers, including a Google speaker and several Google Developer Experts (GDEs), who will share their expertise and insights on a range of topics related to leadership, web technologies, Google Cloud Platform, Firebase, and more.

Our keynote speaker for the day is Cheryl Lin, a Software Developer at Google who will be speaking on Firebase. We are also excited to welcome GDEs from around the world who will be speaking in person at the event, including Laurence Svekis from Toronto,  Ekaba Bisong from Calgary, and Rabimba from Houston. Each of these experts has a wealth of knowledge to share on topics such as leadership, data analytics, machine learning, augmented reality, and web technologies.

We are expecting attendees from different fields at the event, which will be an excellent opportunity for networking, learning, and celebrating the achievements of women in tech. Don’t miss out on this exciting opportunity to connect with fellow professionals and learn from some of the brightest minds in the tech industry. Register today to secure your spot at this must-attend event.


Introduction to Google Apps Script – why use it:

Google Apps Script is a scripting language based on JavaScript that allows users to automate various tasks and workflows within Google Workspace applications. It is a powerful tool for automating repetitive tasks, customizing and extending the functionality of Google Workspace applications, and building lightweight web applications. In this session, we will discuss the benefits of using Google Apps Script, common uses, and how to get started.

How I got started with it – solution workspace made easy:

As a solution workspace, Google Workspace provides an easy way to get started with Google Apps Script. I began using Google Apps Script when working on a project for a University, the request was to capture tweets into a spreadsheet.  No server provided.   I found Apps Script that can query the Twitter API and then return the results into a spreadsheet.   Taking a step further using the sentiment analyst API I could track the sentiment of tweets.  Then as I explored it further it was easy to automate tasks in Google Sheets, such as generating reports and data analysis. Over time, I discovered its potential to integrate with other Google Workspace applications and external APIs, customize and extend the functionality of Google Workspace applications, and build web applications.

Benefits of Apps Script – Users of Apps Script:

Google Apps Script offers several benefits to users, including increased productivity, streamlined workflows, and improved collaboration. Users can automate repetitive tasks, customize and extend the functionality of Google Workspace applications, and build lightweight web applications. Apps Script is used by individuals, small businesses, educational institutions, nonprofits, and IT professionals to automate tasks, manage data, and streamline workflows.

Common uses for Google apps script:

Some of the common uses for Google Apps Script include automating workflows, customizing Google Workspace applications, integrating with external APIs, building web applications, and developing add-ons and extensions. Google Apps Script can be used to automate tasks like sending emails, generating reports, updating spreadsheets, and managing files.

Custom functions in Sheets:

Google Sheets provides the ability to create custom functions using Google Apps Script. Custom functions allow users to extend the functionality of Sheets by creating custom calculations and data analysis tools. These custom functions can be used to automate tasks and streamline workflows in Sheets.

Setting triggers to Automate:

Google Apps Script allows users to set triggers to automate tasks and workflows. Triggers can be set to run scripts automatically based on specific events or schedules, such as when a user opens a document, when a form is submitted, or on a set schedule. This feature allows users to automate repetitive tasks and streamline workflows.

What I’ve learned from my Students:

As an educator, I have learned that Google Apps Script is well received by students of all levels of coding experience.   Users enjoy creating powerful applications , creating custom scripts, functions, and web applications using Google Apps Script.


We will also have a Q&A segment where attendees can ask questions and get more information about using Google Apps Script. Topics may include best practices for scripting, tips and tricks for automating tasks, and strategies for customizing and extending the functionality of Google Workspace applications.