Apps Script Code Examples

Listing contents of paragraphs using Google Apps Script

by

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

Apps Script Doc Lists

by

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

Apps Script createEventFromDescription

by

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

by

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

Top 10 Tips for using Google Apps Script

by

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!

10 Google Sheets formulas and Videos with Example Code

by

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 Video Lessons Source Code

by

Add Columns with Apps Script Sort By Column Index value Filter the rows in a Google Sheet Create a pivot table in a Google Sheets Create a new Google Slides presentation Add Columns with Apps Script function addColumn() {   const ss = SpreadsheetApp.getActiveSpreadsheet();   const sheet = ss.getSheets()[0];   const sheetName = sheet.getName();   sheet.insertColumnBefore(1);   const lastCol = … Read more

How to select a sheet and set it active with google apps script

by

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

IWD 2023 – Dare To Be Ottawa Laurence Svekis Power Up with Google Apps Script

by

Power Up with Google Apps Script Celebrate International Women’s Day with a full-day event featuring a Google speaker and Google Developer Experts on topics such as leadership, web technologies, Google Cloud Platform, Firebase, data analytics, machine learning, augmented reality and more. About this event Join us on April 23 from 11 am-2pm for an exciting … Read more

Translate with one line of code Google Apps Script

by

This code defines a function called translateText() that takes the text you want to translate and the target language as inputs. In this example, the text is “Hello world” and the target language is Spanish. The LanguageApp.translate() method is then