Apps Script Code Examples

When running apps script try to avoid longer than 5 minutes executions, if you need more processing you should chunk the operation into more manageable pieces. Apps Script services have daily quotas and limitations on some features. If you exceed a quota or limitation, your script throws an exception and execution stops. https://developers.google.com/apps-script/guides/services/quotas Feature Consumer … Read more

Google Apps Script is a scripting language that allows you to automate tasks, extend functionality, and customize Google Workspace (formerly known as G Suite) applications such as Google Sheets, Google Docs, Google Slides, and more. It provides a way to write code and create custom scripts that interact with various Google services and APIs. Within … Read more

Hides one or more consecutive columns starting at the given index. Use 1-index for this method. var ss = SpreadsheetApp.getActiveSpreadsheet();var sheet = ss.getSheets()[0];// Hides the first three columnssheet.hideColumns(1, 3); Here’s an example of how to use sheet.hideColumns in Apps Script to hide specific columns in a Google Sheets spreadsheet: function hideColumnsExample() { // Get the … Read more

To use this code: Remember to adjust the index in getChild() based on your specific requirements and the structure of your document.

o add numbered list items to a Google Docs document using Apps Script, you can use the setListId() and setNestingLevel() methods of the ParagraphHeading element. Here’s an example that demonstrates how to add numbered list items: function addNumberedListToDoc() { var doc = DocumentApp.getActiveDocument(); var body = doc.getBody(); // Create a numbered list var listItems = … Read more

createEventFromDescription Apps Script from a description. Here’s a code snippet that demonstrates how to achieve that: function createEventFromDescription() { var calendarId = ‘YOUR_CALENDAR_ID’; // Replace with your calendar ID var description = ‘Event Description’; // Replace with the description for your event var calendar = CalendarApp.getCalendarById(calendarId); var event = calendar.createEventFromDescription(description); Logger.log(‘Event created: ‘ + event.getTitle()); … Read more

Count the number of occurrences of a given substring in a string function COUNT_SUBSTR(str,sbStr){  let count = 0;  let pos = str.indexOf(sbStr);  while (pos !== -1){    count++;    pos = str.indexOf(sbStr,pos+1);  }  return count; } The provided code defines a function called COUNT_SUBSTR that takes two parameters: str and sbStr. The purpose of this function is … Read more

Here are the top 10 tips for using Google Apps Script: Remember, practice and experimentation are key to mastering Google Apps Script. Don’t be afraid to try new things and build upon your knowledge as you go along. Happy scripting!