Apps Script Code Examples

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!

To select and activate a sheet in Google Sheets using Google Apps Script, you can use the setActiveSheet() method of the SpreadsheetApp class. Here’s an example code snippet that selects the sheet named “Sheet1” and sets it as the active sheet: function selectAndActivateSheet() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName(“Sheet1”); ss.setActiveSheet(sheet); } In … Read more