Speaker

Laurence Svekis

Laurence Svekis

Google Developer Expert for Workspace

Toronto, Canada

Actions

Laurence Svekis is a Google Developer Expert (GDE) and Google Champion, recognized for his expertise in Google Workspace and Google Apps Script since 2020. With over 1 million students worldwide taking his courses, Laurence has made a name for himself as one of the internet's leading instructors in web development and programming. He began his teaching journey in the mid-2000s, discovering a natural ability to simplify complex topics and inspire learners of all levels.

A passionate advocate for the latest advancements in technology, Laurence has continually refined his skills, becoming a key contributor to the web development community. He is actively involved in forums, conferences, and open-source collaborations, where his insights and innovative ideas are highly valued.

Laurence’s work doesn’t stop at teaching; he’s a best-selling author and a sought-after speaker, known for his dynamic presentations on Apps Script and web development. His courses and tutorials empower students to create dynamic, responsive, and user-friendly applications, blending his deep technical knowledge with an engaging teaching style.

As a leader in the field, Laurence’s dedication to empowering others through education and his role as a GDE have earned him widespread respect in the tech industry. Learn more at BaseScripts.

Area of Expertise

  • Information & Communications Technology

Topics

  • Web
  • Workspace Developer
  • Web Apps
  • App Development
  • Web3.0
  • Web APIs
  • Web Design
  • Web Frontend
  • Web Development
  • Web Applications
  • Web Performance
  • Web Accessibility
  • Mobile web
  • Modern Web and UX
  • Modern Web
  • modern workplace
  • Future of Work
  • Programming Languages & Frameworks
  • Google Cloud
  • Google Workspace
  • Web Frameworks
  • Intro to Web Frameworks
  • Workshop Design
  • Google Cloud Paltform
  • Google
  • Application Development
  • google cloud platform
  • Office Apps & Services
  • Google Apps Script
  • ● Firebase ● Android ● Android Things / IOT ● Progressive Web App ● Machine learning and AI ● Robotics and Drone Technologies ● Tensorlow

Power Up with Google Apps Script

Presentation about technology, productivity with workspace

Power Up with Google Apps Script

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.

Q&A:

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.

Google Apps Script

Google Apps Script enhances productivity, customizes app functionality, and builds simple web applications. Benefits include streamlining workflows and collaboration. Common uses encompass workflow automation, app customization, API integration, web app creation, and extensions. Triggers automate scripts based on events or schedules. Users of all coding levels enjoy Apps Script's capabilities. The session includes a Q&A on best practices and tips.

Power Up with Apps Script & Gemini AI

The presentation focuses on the capabilities and benefits of using Google Apps Script, a scripting language based on JavaScript that allows for the automation, customization, and integration of various tasks and workflows within Google Workspace applications.

Key Points:
Introduction to Google Apps Script:

Apps Script is a cloud-based tool that enables users to automate tasks like data entry, report generation, and email notifications.
It extends the functionality of Google Workspace applications by creating custom menus, add-ons, and web applications.
It is easy to access and free to use, making it an ideal tool for collaboration and project sharing.
Common Uses:

Automation: Automate repetitive tasks to save time and increase efficiency.
Customization: Create custom functions and user interfaces within Google Sheets.
Integration: Connect Google services and third-party APIs seamlessly.
Practical Examples:

Custom Menus: Demonstrates how to create a custom menu in Google Sheets that triggers specific Apps Script functions.
Custom Functions: Shows how to create custom functions in Sheets, such as calculating the percentage change between two values.
Triggers: Discusses setting up triggers to automate scripts based on specific events or schedules.
Advanced Capabilities:

Mini Project: An example project using Google Apps Script and the Gemini AI to list image files in Google Drive, convert them to Base64, and generate detailed descriptions using the Google Gemini Pro Vision API.
Audience and Benefits:

The presentation highlights that Apps Script is suitable for individuals, small businesses, educational institutions, and IT professionals.
The simplicity and power of Apps Script make it accessible to new coders and those looking to automate tasks without extensive coding experience.
Interactive and Engaging:

Laurence Svekis emphasizes his passion for teaching Apps Script, which is reflected in the engagement and positive feedback from his students, many of whom are working on small automation projects.
Conclusion:

The presentation concludes with resources for further learning and support, including links to Laurence's GitHub, LinkedIn, and personal website.
This presentation provides a comprehensive overview of Google Apps Script, showcasing its potential to streamline workflows, enhance productivity, and enable custom solutions within the Google Workspace ecosystem.

General audience any Google account users
30-45 minutes

AI Summit Vancouver : DevFest Sessionize Event Upcoming

November 2024 Vancouver, Canada

DevFest Florida Tampa 2024 Sessionize Event

October 2024 Tampa, Florida, United States

Build with AI Sessionize Event

April 2024 Surrey, Canada

Laurence Svekis

Google Developer Expert for Workspace

Toronto, Canada

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top