Resolve a column of links in Google Sheets with Apps Script

Store it in Script Properties (Project Settings → Script Properties → saveapi_key). A key in a cell travels with every copy and export of the sheet.

UrlFetchApp with the Authorization header and muteHttpExceptions so an error response is parsed instead of thrown — the JSON body carries error.code, which is what you want to write into the sheet.

// Apps Script — Extensions → Apps Script
function resolve(link) {
  const key = PropertiesService.getScriptProperties().getProperty("saveapi_key");
  const res = UrlFetchApp.fetch(
    "https://api.saveapi.org/v1/download?url=" + encodeURIComponent(link),
    { headers: { Authorization: "Bearer " + key }, muteHttpExceptions: true },
  );
  return JSON.parse(res.getContentText());
}

Read the range once, loop, write two cells per row: the media URL and OK, or empty and the error code. The sleep keeps a long column under the key's per-minute limit — 10 on the free tier, 60 on Pro.

// A ustunidagi havolalar → B ustuniga media URL, C ga natija kodi
function resolveColumn() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const rows = sheet.getRange(2, 1, sheet.getLastRow() - 1, 3).getValues();

  rows.forEach((row, i) => {
    if (!row[0] || row[1]) return;              // bo'sh yoki allaqachon yechilgan
    const data = resolve(row[0]);
    const out = data.success
      ? [data.medias[0].url, "OK"]
      : ["", data.error.code];
    sheet.getRange(i + 2, 2, 1, 2).setValues([out]);
    Utilities.sleep(6000);                      // bepul tarif: 10 so'rov/daqiqa
  });
}

A custom =SAVEAPI(A2) recalculates whenever the sheet does, and each recalculation is a billed request. Run resolving as an action (a menu item or a button), skip rows that already have a result, and the sheet costs credits once per link.

1.5 credits per successful resolve, 0.1 for a private or deleted link, nothing for a timeout. A column of 500 links is about 750 credits — inside the free 1,000.