google应用程序脚本javascript

javascript

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('自定义菜单')
    .addItem('运行脚本', 'myFunction')
    .addToUi();
}

function myFunction() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.getRange('A1').setValue('Hello, Google Sheets!');
}

javascript

function sendEmail() {
  var recipient = 'example@example.com';
  var subject = 'Hello from Google Apps Script';
  var body = 'This is a test email sent from Google Apps Script.';
  MailApp.sendEmail(recipient, subject, body);
}

javascript

function listFilesInFolder() {
  var folderId = 'your-folder-id';
  var folder = DriveApp.getFolderById(folderId);
  var files = folder.getFiles();
  
  while (files.hasNext()) {
    var file = files.next();
    Logger.log('File Name: ' + file.getName());
  }
}

javascript

function createGoogleDoc() {
  var doc = DocumentApp.create('New Document');
  var body = doc.getBody();
  body.appendParagraph('Hello, this is a new Google Doc created by Apps Script.');
  Logger.log('Document URL: ' + doc.getUrl());
}

javascript

function createTimeDrivenTrigger() {
  ScriptApp.newTrigger('myFunction')
    .timeBased()
    .everyMinutes(5)
    .create();
}

function myFunction() {
  Logger.log('This function runs every 5 minutes.');
}