Copy a Google Ads final URL suffix script skeleton that reads verified link state first.

// Link Peeler final URL suffix sync skeleton.
// Adapt CONFIG before running in a Google Ads Scripts account.

var CONFIG = {
  VERIFIED_ROWS_URL: "https://your-link-peeler.example/api/verified-rows",
  API_KEY: "replace-with-read-token",
  DRY_RUN: true
};

function main() {
  var rows = fetchVerifiedRows();
  rows.forEach(function(row) {
    if (row.conclusion !== "valid" || !row.finalUrlSuffix) {
      Logger.log("skip row " + row.rowId + " because conclusion=" + row.conclusion);
      return;
    }

    Logger.log("ready campaign=" + row.campaignName + " suffix=" + row.finalUrlSuffix);

    if (!CONFIG.DRY_RUN) {
      // Replace this block with your team's campaign lookup and update logic.
      // Keep failed or stale rows out of the mutation set.
    }
  });
}

function fetchVerifiedRows() {
  var response = UrlFetchApp.fetch(CONFIG.VERIFIED_ROWS_URL, {
    method: "get",
    headers: { "Authorization": "Bearer " + CONFIG.API_KEY },
    muteHttpExceptions: true
  });

  if (response.getResponseCode() >= 300) {
    throw new Error("Link Peeler state request failed: " + response.getContentText());
  }

  return JSON.parse(response.getContentText()).rows || [];
}