Scripty Script

Google Apps Script Sheet Creator

Written by

Geoff

in

,

This script logs a greeting, creates a new Google Sheet with a timestamped title, and appends sample text to it while logging the document URL

Click to view script… 
function myTestScript() {
  // Log a simple greeting message
  Logger.log("Hello, Google Apps Script!");

  // Get and log the active user's email address
  var userEmail = Session.getActiveUser().getEmail();
  Logger.log("Active user: " + userEmail);

  // Create a new Google Sheet with a unique name based on the current date and time
  var spreadsheet = SpreadsheetApp.create("Test Spreadsheet " + new Date());
  var sheet = spreadsheet.getActiveSheet();

  // Append some rows to the sheet
  sheet.appendRow(["This spreadsheet was created by a test script in Google Apps Script."]);
  sheet.appendRow(["Active user email:", userEmail]);

  // Log the URL of the created spreadsheet so you can easily open it
  Logger.log("Spreadsheet created: " + spreadsheet.getUrl());
}

More posts