getHelp.gs

function contactPartner() {
  try {
    // Constants
    const userEmail = Session.getUser().getEmail();
    const docId = SpreadsheetApp.getActiveSpreadsheet().getId();
    const sheetLink = `https://docs.google.com/spreadsheets/d/${docId}/edit`;
    const subject = `Assistance Request - ${userEmail}`;
    let body = `Hi DoiT Team,\n\n${userEmail} has requested assistance with the Security Checklist for Workspace Admins. Please do your best to help them.`;
    const recipient = "workspace-security@doit.com";

    // Create a radio button prompt
    const ui = SpreadsheetApp.getUi();
    const response = ui.alert(
      'Send Email',
      'Are you sure you want to send an email to DoiT International to request assistance?',
      ui.ButtonSet.YES_NO
    );
    
    if (response !== ui.Button.YES) {
      return; // User canceled, do nothing
    }

    // Display a radio button prompt
    const includeLink = ui.alert(
      'Include Link to Spreadsheet',
      'Include a link to your spreadsheet in the email?',
      ui.ButtonSet.YES_NO
    );
    
    if (includeLink === ui.Button.YES) {
      body += `\n\nA link to the customer's Security Checklist is included below: \n${sheetLink}`;
    }

    // Send the email using MailApp service
    MailApp.sendEmail({
      to: recipient,
      subject: subject,
      body: body,
    });

    // Display a message to the user
    ui.alert(`Email Sent! \n\nDoiT may request viewer access to assist you.`);
    
    // Log confirmation
    console.log("Email Sent successfully.");
  } catch (error) {
    // Log any errors
    console.error("Error: " + error.toString());

    // Display troubleshooting suggestions
    const ui = SpreadsheetApp.getUi();
    if (error.message.includes("Required permissions: https://www.googleapis.com/auth/userinfo.email")) {
      ui.alert("Error: You do not have permission to access user information. Please enable the required permission and try again.");
    } else {
      ui.alert("Error sending email. Please check your internet connection and try again. If the problem persists, contact support at workspace-security@doit.com.");
    }
  }
}