I’m trying to write a script that sends the content of one sheet when one particular cell is not empty.
The checking part of the script is working. The email part is working too. I would like to attach the contents of the sheet (ideally in xlsx format, but csv could do if it is simpler) to the email but all the scripts I found online seem to use some Google Drive API and haven’t figured out how to use it.

I commented out the lines that should be doing the exporting and, for now, the script just sends a reminder to manually export the sheet. This I would like to automate.
Also, instead of sending the email to a hard-coded email, I would like to send it to the email address found in a particular cell in the same sheet (I1).

Any help would be appreciated.

Here’s my script:

unction checkAndExport() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheetName = 'Bookings List'; // Replace with the desired sheet name

  var sheet = spreadsheet.getSheetByName(sheetName);
  var checkCell = sheet.getRange('B3'); // Cell to check if it is empty
  var cellValue = checkCell.getValue();

  if (cellValue !== '') {
    // Export sheet data to a CSV string
  //  var outputDocument = DocumentApp.create('My custom csv file name'); 
  //  var content = getCsv();
  //  var textContent = ContentService.createTextOutput(content);
  //  textContent.setMimeType(ContentService.MimeType.CSV);
  //  var blob = Utilities.newBlob(textContent, 'text/csv', sheetName + '.csv');

    // Send an email with the CSV file attached
    var recipientEmail = '[email protected]'; // Replace with actual email address
    var subject = 'Bookings Email reminder';
    var body = 'It is time to send the bookings list to some leader!';

    var options = {
      name: 'Exported Sheet',
    //  mimeType: blob.getContentType(),
      inline: false,
    //  attachments: [blob]
    };