How Do I Copy Non-Adjacent Cell Values to a Row for a Log Sheet?

I want to copy three cells, which are non-adjacent (AA9, AA12, and AA15), and paste them on another sheet in a single row, like a log sheet. (A2,B2,C2) I'm using "getLastRow+1" to make this happen. Currently, I'm only able to use getValue and setValue for a single cell (AA9) and after searching for similar examples online, I'm still struggling to make this work.

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Main")
  var destSheet = ss.getSheetByName('Log');

// Get the Cell Values from Main Sheet
  var streak = sheet.getRange('AA9').getValue(); 
// Set the Values on Log Sheet
  destSheet.getRange(destSheet.getLastRow()+1,1).setValue(streak);

I'm struggling to understand how to correctly implement what I want. I essentially want to copy the values in AA9, AA12, and AA15, and paste them (or use setValue) in A2,B2, and C2 on the other sheet.

I'm slowly learning and getting a better understanding of everything, and examples from google searches have gotten me far, but this is a headscratcher for me.

• I've tried using Named Ranges, but I didn't understand how to find the last EMPTY row of that named range.
• I've tried creating an Array for those cells, but didn't understand how to use SetValues correctly (got an error about the number of rows not being equal to the data rows, something like that)

// THIS DIDN"T WORK
  var results = ['AA9','AA12','AA15'];
  var streak = sheet.getRangeList(results).getRanges().map(range => range.getValues());
 destSheet.getRange(destSheet.getLastRow()+1,1).setValues(streak);

• I've also searched google quite a bit, and while the results have helped me script a random number generator (not shown here), I still struggle with more basic tasks.

You can make your latter code example work by using Range.getValue() instead of Range.getValues().

To easily append the values to the destination sheet, use Sheet.appendRow(), like this:

  const sheet = ss.getSheetByName('Main');
  const destSheet = ss.getSheetByName('Log');
  const data = sheet.getRangeList(['AA9', 'AA12', 'AA15'])
    .getRanges()
    .map(range => range.getValue());
  destSheet.appendRow(data);

Try it this way:

function myfunk() {
  const ss = SpreadsheetApp.getActive();
  const sh = ss.getSheetByName('Sheet0');
  const dsh = ss.getSheetByName('Sheet1');
  const [a,,,b,,,c] = sh.getRange("AA9:AA15").getValues().flat();
  dsh.appendRow([a,b,c]);
}

When I use getValues, it works perfectly! But it does throw an error, saying "Exception: The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues.". But again, it does actually work on my spreadsheet.

When I use getValue, it strangely works, and doesn't throw an error, it sets the values appropriately in an appended row, but then loops back around again and repeatedly sets the value in the first cell again, albeit one row down (because it just filled the previous row so it moves down). It's so strange. I can see it do it slowly, it sets the values in the row, a split second later it loops back to the first value, but one row down, and sets that value again. But none of the other ones.

If you can visualize this, it'll post 3 numbers, correctly, appended in the row, then one row down it'll post only 1 number, but leave the other two blank.

Screenshot Example

function log_data() {

  const data = sheet.getRangeList(['AA9','AA12','AA15'])
    .getRanges()
    .map(range => range.getValue());
  destSheet.appendRow(data);

  destSheet.getRange(destSheet.getLastRow()+1,1).setValue(data);
}