Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
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!
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
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
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
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
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
Sure, here’s an example of how to set up a time-driven trigger in Google Apps Script to automate a function: Create triggers with code or manually in the interface function myFunction() {// Your code here} function createTrigger() {ScriptApp.newTrigger(‘myFunction’).timeBased().everyMinutes(30) // Set the frequency here.create();}This code defines a function called myFunction() that contains the code you want … Read more
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
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 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