Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Apps Script Coding Examples V2 Create a custom function to calculate the average of a range of cells:Custom Sheet FormulaAutomatically send an email reminder based on a specific date:Send email reminder AutomationCreate a custom menu in Google Sheets to run a script:Custom Sheet UI MenuUse the Google Drive API to create a new folder:Create new … Read more
Apps Script Coding Examples Sending an email using Gmail service function sendEmail() { const rep = “example@example.com”; const sub = ‘Hello World’; const message = ‘Hi, Laurence’; GmailApp.sendEmail(rec, sub, message); } function mySender2() { const rep = “example@example.com”; const sub = ‘Hello World’; const message = ‘Hi, Laurence’; MailApp.sendEmail(rep,sub,message); } This script uses the Gmail … Read more
Mastering Google Apps Script Introduction to Google Apps Script: Explanation of Google Apps Script and its benefits Google Apps Script is a scripting language based on JavaScript that allows users to automate tasks and create custom functionality in Google Workspace (formerly known as G Suite) applications such as Google Sheets, Google Docs, Google Slides, and … Read more
How to add focus to a cell within Google Sheets using Apps Script You can add focus to a specific cell within a Google Sheets spreadsheet using Apps Script by using the setActiveRange method of the Range object. This method sets the specified range as the active range in the spreadsheet, which will give it … Read more
Google Apps Script Interview Questions What is Google Apps Script and how does it work? Answer: Google Apps Script is a cloud-based scripting language that allows you to automate tasks in Google Sheets, Docs, and other Google products. It is based on JavaScript and provides a way to extend the functionality of Google products by … Read more
Free Google Apps Script Coding guide download Google Apps Script is a cloud-based platform that allows users to extend Google’s G Suite of productivity tools with custom code. It is a JavaScript-based scripting language that runs on Google’s servers and provides a seamless way to automate tasks, integrate various Google services, and build custom applications. … Read more
Apps Script Coding Examples V4 Google Apps Script is a scripting platform that lets you extend Google Workspace by adding custom functionality to your Google Sheets, Docs, Forms, and Gmail. Google Apps Script is a cloud-based scripting language that provides easy ways to automate tasks across Google products and third-party services. Read Data from from … Read more
Apps Script Coding Examples Google Apps Script is a scripting platform that lets you extend Google Workspace by adding custom functionality to your Google Sheets, Docs, Forms, and Gmail. Google Apps Script is a cloud-based scripting language that provides easy ways to automate tasks across Google products and third-party services. Top Tips for Google Apps … Read more
10 tips to help you improve your Google Apps Script coding:
Bullet code copy example of how you can copy a bulleted list from one Google Document to another using Google Apps Script: // Function to copy the bulleted list from one document to another function copyBulletedList() { // Get the source document const sourceDoc = DocumentApp.getActiveDocument(); // Get the list items from the source document … Read more