Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Google Apps Script test your knowledge Introduction to Google Apps Script Quiz Google Apps Script, a powerful tool in the arsenal of a modern developer, offers immense flexibility and integration within the Google Workspace. To help learners and professionals alike gauge their understanding and mastery of this versatile platform, we present a comprehensive 100-question quiz. … Read more
Are you tired of messy data in your Google Sheets? Struggling with unorganized lists that need sorting into neat columns? We’ve got you covered! In our latest tutorial, we dive deep into the magical world of Google Sheets and its powerful ‘Split Text to Columns’ feature. 📈✨ 🎥 In this video, you’ll learn: Whether you’re … Read more
In today’s digital age, where efficiency and productivity are paramount, the ability to automate repetitive tasks can be a game-changer. Enter Google Apps Script, an incredibly versatile tool that empowers you to automate and extend the functionality of Google Workspace applications like Google Sheets, Google Docs, and Gmail. In this beginner’s guide, we’ll take a … Read more
Google IO Extended 2023, Toronto Google IO Extended Sat, Aug 12, 9:30 AM (EDT) https://gdg.community.dev/events/details/google-gdg-cloud-toronto-presents-google-io-extended-2023-toronto/ Google Apps Script is a powerful scripting language and development platform that empowers users to extend and customize various Google Workspace (formerly known as G Suite) applications, such as Google Sheets, Google Docs, Gmail, Google Drive, and more. It offers … Read more
Google Sheet Formulas Formula to calculate the average of the values in a given rangeConcatenate two strings and capitalize the first letterCalculate the factorial of a given numberCount the number of occurrences of a given value in a rangeCalculate the distance between two sets of latitude and longitude coordinatesCheck if a given string is a … Read more
Google Apps Script Examples 5 Example 1: Create a new Google FormExample 2: Send an email notificationExample 3: Create a Google SheetExample 4: Get the current timeExample 5: Get the user’s location Example 1: Create a new Google Form This code will create a new Google Form. function createForm() { // Create a new Google … Read more
Ultimate Apps Script Questions with Solutions Guide How can I use Google Apps Script to send emails from a Google Sheet?How can I add a timestamp to a Google Sheet when a cell is edited?How can I retrieve data from an external API using Google Apps Script?How can I delete rows from a Google Sheet … Read more
Apps Script Questions with Solutions and Coding Examples 6 How can I format the font size of a range in a Google Sheet using Google Apps Script?How can I format the boldness of a range in a Google Sheet using Google Apps Script?How can I format the alignment of text in a range in a … Read more
Apps Script Questions with Solutions and Coding Examples 1 How can I create a custom menu in a Google Sheet using Google Apps Script?How can I get the value of a cell in a Google Sheet using Google Apps Script?How can I set the value of a cell in a Google Sheet using Google Apps … Read more
Custom sheet functions using Google Apps Script Function to Calculate Average of a Range function AVERAGE_RANGE(range) { var sum = 0; var count = 0; range.forEach(function(value) { sum += value[0]; count++; }); return sum / count; } Summary: This custom function takes a range of cells as input and returns the average of the values … Read more