Apps Script Code Examples

Simple Google Apps Script Sheet Addon Code snippet

by

Google Apps Script add-ons are a type of script that extends the functionality of Google Docs, Sheets, and Forms. They are created using Google Apps Script and can be published and shared with other users. Here’s an example of a Google Apps Script add-on code: function onOpen() {var ui = SpreadsheetApp.getUi();var menu = ui.createMenu(‘My Custom … Read more

Custom Menu UI with Apps Script

by

To add a custom menu UI in Google Apps Script, you can use the addMenu(name, subMenus) method of the Ui class. Here is an example of how to add a custom menu UI in Google Sheets: function onOpen() { var ui = SpreadsheetApp.getUi(); var menu = ui.createMenu(‘My Custom Menu’); menu.addItem(‘Menu Item 1’, ‘menuItem1’); menu.addItem(‘Menu Item … Read more

Google Apps Script Coding Examples

by

Google Apps Script coding examples Add a new column to a Google Sheet This code will add a new column to a Google Sheet. function addColumn() {  // Get the sheet object.  var sheet = SpreadsheetApp.getActiveSpreadsheet();  // Get the current sheet name.  var sheetName = sheet.getName();  // Get the column index of the last column. … Read more

Google Apps Script Examples 8

by

Google Apps Script Examples 8 Example 1: Create a new Google FormExample 2: Send an email notification to the userExample 3: Create a Google SheetExample 4: Get the current timeExample 5: Get the user’s locationExample 6: Update Google Sheets from FormsExample 7: Generate Docs from Sheets DataExample 9: Send email notifications from SheetsExample 10: Generate … Read more

Google Apps Script Examples 7

by

Google Apps Script Examples 7 Example 1: Create a new Google Slides presentationExample 2: Send an email notification to the userExample 3: Create a Google Drive fileExample 4: Get the current timeExample 5: Create Google Forms from SheetsExample 6: Track Changes to Google SheetExample 7: Generate Slides from Sheets data Example 1: Create a new … Read more

Google Apps Script Examples 6

by

Google Apps Script Examples 6 Example 1: Add a new column to a Google SheetExample 2: Sort the rows in a Google SheetExample 3: Filter the rows in a Google SheetExample 4: Create a pivot table in a Google SheetExample 5: Sending Emails with AttachmentsExample 6: Merge Multiple sheets into one Example 1: Add a … Read more

Google Apps Script Examples 5

by

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

Google Apps Script Examples  4

by

Google Apps Script Examples  4 Example 1: Create a new Google Slides presentationExample 2: Send an email notification to the userExample 3: Create a Google Drive fileExample 4: Get the current time Example 1: Create a new Google Slides presentation This code will create a new Google Slides presentation. function createPresentation() {   // Create a … Read more

Google Apps Script Examples 3

by

Google Apps Script Examples 3 Example 1: Add a new column to a Google SheetExample 2: Sort the rows in a Google SheetExample 3: Filter the rows in a Google SheetExample 4: Create a pivot table in a Google Sheet Example 1: Add a new column to a Google Sheet This code will add a … Read more

Google Apps Script Examples 2

by

Google Apps Script Examples 2 Example 1: Create a 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 Google Form This code will create a new Google Form. function createForm() {   // Create a new Google Form.   var … Read more