Google Apps Script для Gmail: примеры использования и автоматизация

/**
 * @function getInboxMessages
 * @description Gets a list of inbox messages.
 * @return {GmailThread[]} An array of GmailThread objects.
 */
function getInboxMessages(): GmailThread[] {
  const threads: GmailThread[] = GmailApp.getInboxThreads();
  Logger.log(threads.length); // Logs the number of threads in the inbox.
  return threads;
}

/**
 * @function labelSender
 * @description Labels emails from a specific sender.
 * @param {string} senderEmail The email address of the sender to label.
 * @param {string} labelName The name of the label to apply.
 */
function labelSender(senderEmail: string, labelName: string): void {
  const threads: GmailThread[] = GmailApp.search(`from:${senderEmail}`);
  if (threads.length > 0) {
    const label: GmailLabel = GmailApp.createLabel(labelName);
    label.addToThreads(threads);
  }
}

// Example usage:
// labelSender("sales@example.com", "Sales");

/**
 * @function sendAutoReply
 * @description Sends an automatic reply to unread emails.
 * @param {string} replyText The text of the auto-reply.
 */
function sendAutoReply(replyText: string): void {
  const threads: GmailThread[] = GmailApp.search('is:unread');
  threads.forEach(thread => {
    const message: GmailMessage = thread.getMessages()[0];
    const sender: string = message.getFrom();
    const subject: string = message.getSubject();

    // Avoid replying to auto-replies to prevent loops.
    if (subject.indexOf('Auto:') === -1) {
      message.reply(replyText);
      thread.markRead();
    }
  });
}

// Example usage:
// sendAutoReply("Thank you for your email. I will be out of office until...");

/**
 * @function extractOrderNumber
 * @description Extracts an order number from an email body using a regular expression.
 * @param {string} emailBody The body of the email to search.
 * @return {string | null} The order number if found, otherwise null.
 */
function extractOrderNumber(emailBody: string): string | null {
  const regex: RegExp = /Order Number: (\d+)/;
  const match: RegExpMatchArray | null = emailBody.match(regex);
  if (match && match.length > 1) {
    return match[1];
  }
  return null;
}

// Example usage:
// const orderNumber = extractOrderNumber(GmailApp.getInboxThreads()[0].getMessages()[0].getBody());

/**
 * @function deleteOldEmails
 * @description Deletes emails older than a specified number of days.
 * @param {number} days The number of days after which to delete emails.
 */
function deleteOldEmails(days: number): void {
  const cutoffDate: Date = new Date();
  cutoffDate.setDate(cutoffDate.getDate() - days);
  const threads: GmailThread[] = GmailApp.search(`before:${cutoffDate.getFullYear()}-${cutoffDate.getMonth() + 1}-${cutoffDate.getDate()}`);
  threads.forEach(thread => {
    thread.moveToTrash();
  });
}

// Example usage (delete emails older than 30 days):
// deleteOldEmails(30);

/**
 * @function sendPersonalizedEmail
 * @description Sends a personalized email to a recipient.
 * @param {string} recipientEmail The email address of the recipient.
 * @param {string} recipientName The name of the recipient.
 */
function sendPersonalizedEmail(recipientEmail: string, recipientName: string): void {
  const subject: string = `Hello ${recipientName}!`;
  const body: string = `Dear ${recipientName},

Thank you for your interest in our product.

Sincerely,
The Example Team`;

  GmailApp.sendEmail(recipientEmail, subject, body);
}

// Example usage:
// sendPersonalizedEmail("user@example.com", "John Doe");

/**
 * @function sendMailMerge
 * @description Sends a mail merge based on data from a Google Sheet.
 */
function sendMailMerge(): void {
  const ss: GoogleAppsScript.Spreadsheet.Spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  const sheet: GoogleAppsScript.Spreadsheet.Sheet = ss.getActiveSheet();
  const dataRange: GoogleAppsScript.Spreadsheet.Range = sheet.getDataRange();
  const data: any[][] = dataRange.getValues();

  // Assumes the first row contains headers: Email, Name, ...
  for (let i = 1; i < data.length; i++) {
    const email: string = data[i][0]; // Email address
    const name: string = data[i][1];   // Recipient name
    const subject: string = `Personalized Email for ${name}`;
    const body: string = `Dear ${name},

This is a personalized email.

Sincerely,
The Example Team`;

    GmailApp.sendEmail(email, subject, body);
  }
}

/**
 * @function sendSheetUpdateNotification
 * @description Sends a notification email when a Google Sheet is updated.
 * @param {GoogleAppsScript.Events.SheetsOnChangeEvent} e The event object.
 */
function sendSheetUpdateNotification(e: GoogleAppsScript.Events.SheetsOnChangeEvent): void {
  const sheetName: string | undefined = e.range?.getSheet().getName();
  const user: string | undefined = Session.getActiveUser()?.getEmail();
  const subject: string = `Google Sheet Updated: ${sheetName}`;
  const body: string = `The Google Sheet '${sheetName}' was updated by ${user}.`;

  GmailApp.sendEmail("notification@example.com", subject, body);
}

/**
 * @function saveAttachmentsToDrive
 * @description Saves attachments from Gmail to Google Drive.
 * @param {string} folderName The name of the folder on Google Drive to save attachments to.
 */
function saveAttachmentsToDrive(folderName: string): void {
  const threads: GmailThread[] = GmailApp.getInboxThreads();
  threads.forEach(thread => {
    const messages: GmailMessage[] = thread.getMessages();
    messages.forEach(message => {
      const attachments: GoogleAppsScript.Gmail.GmailAttachment[] = message.getAttachments();
      attachments.forEach(attachment => {
        const folder: GoogleAppsScript.Drive.Folder = DriveApp.getFolderById("YOUR_FOLDER_ID"); // Replace with your folder ID
        folder.createFile(attachment);
      });
    });
  });
}