Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script is a powerful tool that enables you to automate and enhance your Google Workspace applications, including Google Sheets. In this blog post, we will walk through an exercise to write a script that finds and highlights all cells in a Google Sheet that contain a specific keyword. Additionally, we will explore the … Read more
Google Apps Script is a powerful tool that allows you to automate tasks and create custom functionalities within Google Workspace. In this blog post, we will walk through an exercise to write a script that creates a Google Form with three questions: one multiple choice, one short answer, and one paragraph question. Additionally, we will … Read more
Google Apps Script is a powerful tool that enables you to automate tasks within Google Workspace, including Google Calendar. In this blog post, we will guide you through an exercise to write a script that adds a new event to your Google Calendar with a title, description, start time, and end time. Additionally, we will … Read more
Google Apps Script is a versatile tool that allows you to automate various tasks within the Google Workspace ecosystem. One useful application is converting Google Docs to PDF files and saving them to a specific Google Drive folder. In this blog post, we will walk through an exercise to write a script that accomplishes this … Read more
Google Apps Script allows you to automate tasks within your Google Workspace applications. One powerful feature is the ability to create time-driven triggers that execute functions at specific times or intervals. In this blog post, we will walk through an exercise to create a time-driven trigger that runs a specific function daily at a given … Read more
Google Apps Script is a powerful tool that allows you to automate tasks and integrate with various services directly from your Google Workspace applications. In this blog post, we will walk through an exercise where we write a script to fetch weather data from an external API and display it in a Google Sheet. This … Read more
Creating web applications can seem daunting, but with Google Apps Script, you can build and deploy simple yet powerful web apps with ease. In this blog post, we will walk through the steps to create a simple web app that collects user input and stores it in a Google Sheet. By the end of this … Read more
Debugging and troubleshooting are crucial for JavaScript developers to identify and fix code issues. This blog post covers techniques using console.log(), browser developer tools, breakpoints, the debugger statement, and try…catch blocks. Understanding these methods helps improve code quality and user experience by resolving common syntax, runtime, and logical errors.
Destructuring assignment is a powerful feature in JavaScript introduced with ES6 (ECMAScript 2015). It allows you to unpack values from arrays or properties from objects into distinct variables in a more concise and readable manner. This guide will help you understand how to effectively use destructuring assignment in your JavaScript code, complete with examples and … Read more
ECMAScript 6 (ES6), also known as ECMAScript 2015, introduced a host of new features that significantly improved JavaScript. These features made the language more powerful, expressive, and easier to work with. In this blog post, we’ll explore some of the most important ES6+ features, complete with examples to illustrate their usage. Let and Const ES6 … Read more