Laurence Svekis
Google Developer Expert for Workspace
Toronto, Canada
Actions
In the mid-2000s, Svekis began teaching web development and programming to others. He found that he had a natural talent for explaining complex concepts in a clear and concise way, and his students quickly came to rely on his expertise and guidance. He created a number of online courses on platforms which have been taken by over 1 million students around the world.
Over the years, Svekis has continued to refine his skills and keep up with the latest developments in web development and programming. He has also become an active member of the web development community, participating in online forums, attending conferences, and collaborating with other developers on open-source projects.
Today, Svekis is widely regarded as one of the leading web development instructors on the internet. He continues to create new courses and tutorials, helping students of all levels to master the skills they need to build dynamic, responsive, and user-friendly websites and applications. His passion for teaching and dedication to the field of web development have made him a respected and influential figure in the tech industry.
Laurence is a best Selling Author - Course Creator - Learn more at https://basescripts.com/
Area of Expertise
Topics
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.
Build with AI Sessionize Event
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