Apps Script Questions with Solutions and Coding Examples 8
How can I send an email from Google Sheets using Google Apps Script?
How can I sort data in Google Sheets using Google Apps Script?
How can I add a new sheet to a Google Spreadsheet using Google Apps Script?
How can I format cells in a Google Spreadsheet using Google Apps Script?
How can I create a custom menu in a Google Spreadsheet using Google Apps Script?
How can I set a trigger to run a function in Google Apps Script?
How can I create a new folder in Google Drive using Google Apps Script?
How can I get the last row of data in a Google Spreadsheet using Google Apps Script?
How can I get the current user’s email address in Google Apps Script?
#GoogleScripts #GoogleAddons #GoogleAutomation #GoogleForms #GoogleDocs #GoogleDrive #GoogleCalendar #GoogleSlides #GoogleAppsScriptTips #GoogleAppsScriptTutorials #GoogleSheets #GAS #AppsScript #JavaScript #Coding #Automation #Productivity #GSuite #GoogleWorkspace #google #email
How can I send an email from Google Sheets using Google Apps Script?
function sendEmail() {
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2; // First row of data to process
var numRows = 1; // Number of rows to process
var dataRange = sheet.getRange(startRow, 1, numRows, 2);
var data = dataRange.getValues();
var emailAddress = data[0][0]; // First column
var message = data[0][1]; // Second column
var subject = “Sending emails from Google Sheets”;
MailApp.sendEmail(emailAddress, subject, message);
}
How can I sort data in Google Sheets using Google Apps Script?
function sortData() {
var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getRange(“A2:B10”); // Range to sort
range.sort({column: 1, ascending: true}); // Sort by column A, ascending
}
How can I add a new sheet to a Google Spreadsheet using Google Apps Script?
function addSheet() {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var newSheet = spreadsheet.insertSheet(“New Sheet”);
newSheet.getRange(“A1”).setValue(“New Sheet”);
}
How can I format cells in a Google Spreadsheet using Google Apps Script?
function formatCells() {
var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getRange(“A1:B10”); // Range to format
range.setFontSize(12).setHorizontalAlignment(“center”).setBorder(true, true, true, true, true, true);
}
How can I create a custom menu in a Google Spreadsheet using Google Apps Script?
function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu(“Custom Menu”)
.addItem(“Sort Data”, “sortData”)
.addItem(“Format Cells”, “formatCells”)
.addSeparator()
.addItem(“Send Email”, “sendEmail”)
.addToUi();
}
How can I set a trigger to run a function in Google Apps Script?
function setTrigger() {
ScriptApp.newTrigger(“myFunction”)
.timeBased()
.atHour(12)
.everyDays(1)
.create();
}
How can I create a new folder in Google Drive using Google Apps Script?
function createFolder() {
var folderName = “New Folder”;
var folder = DriveApp.createFolder(folderName);
Logger.log(“Folder URL: ” + folder.getUrl());
}
How can I get the last row of data in a Google Spreadsheet using Google Apps Script?
function getLastRow() {
var sheet = SpreadsheetApp.getActiveSheet();
var lastRow = sheet.getLastRow();
Logger.log(“Last Row: ” + lastRow);
}
How can I get the current user’s email address in Google Apps Script?
function getUserEmail() {
var userEmail = Session.getActiveUser().getEmail();
Logger.log(“User Email: ” + userEmail);
}