Easiest Way to Integrate Moz to Google Spreadsheets Using Free Apps Script

function fetchMozMetrics() {
  var accessId = "YOUR_MOZ_ACCESS_ID";
  var secretKey = "YOUR_MOZ_SECRET_KEY";
  var targetUrl = "https://www.google.com";

  // Construct the authentication header
  var token = Utilities.base64Encode(accessId + ":" + secretKey);
  var headers = {
    "Authorization": "Basic " + token,
    "Content-Type": "application/json"
  };

  // Construct payload
  var payload = {
    "targets": [targetUrl],
    "metrics": ["domain_authority", "page_authority", "external_links", "mozrank", "moztrust"]
  };

  var options = {
    "method": "post",
    "headers": headers,
    "payload": JSON.stringify(payload),
    "muteHttpExceptions": true
  };

  try {
    var response = UrlFetchApp.fetch("https://lsapi.seomoz.com/v2/url_metrics", options);
    var data = JSON.parse(response.getContentText());

    if (data && data.results && data.results.length > 0) {
      var metrics = data.results[0];
      var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

      // Write headers if first row
      if (sheet.getLastRow() === 0) {
        sheet.appendRow(Object.keys(metrics));
      }

      // Write metric values
      var row = Object.values(metrics);
      sheet.appendRow(row);

      Logger.log("Metrics saved to sheet.");
    } else {
      Logger.log("No metrics found in response: " + response.getContentText());
    }
  } catch (e) {
    Logger.log("Error fetching Moz metrics: " + e);
  }
}