Google-sheets – How to Process Rows of Google Sheet Singly

I have a google sheet with the following headers:

| name   |  prop_id |  number | street | city | state | zip | phone | first_name | last_name | email |
|--------|:--------:|--------:|-------:|-----:|------:|----:|------:|-----------:|-----------:------:|

Ultimately, I want to write a custom function that will will take each row in the sheet and make a Post call to an an API to post a payload.

I want to create a JSON object from each row with the headers as the keys and the corresponding cell as the value.

I have found many solutions/resources for exporting an entire sheets into JSON but I don't want to export, I want to turn each row into a JSON a separate object and use that object as the payload to an API call.

Here's what I've tried so far to get the values from a row of a Google Sheet:

// get current row
function getActiveRow() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var activeRow = sheet.getActiveCell().getRow();

  return activeRow;
}

// get data from row
function getDataRow() {  
  //Get the data to send from the spreadsheet and prep variables
  var sheet = SpreadsheetApp.getActiveSheet();
  var dataRange = sheet.getRange(getActiveRow(), 1, 1, 11);
  var row = dataRange.getValues();
  var headers = sheet.getDataRange().getValues()[0];
  var payload = {};

  return row   
}

When I try to apply this formula to any row after the first row (excluding headers) I get a #NAME? error.

Additionally, even with just working with the first row of data (after the headers) I'm trying to buildout the payload object like so:

payload[headers[0]] = row[0];
return payload;

but am not seeing anything return.

Also, what is the equivalent of console.logging when trying to debug with a google script?