Refresh a Google Sheets Export

=IMPORTDATA("https://api.adriel.com/api/widgetExport/auto?exportKey=YOUR_EXPORT_KEY&v=2")

/**
 * Fetches the latest data from an Adriel dynamic data link and writes it
 * into a tab as values. Unlike IMPORTDATA, the result is not cached by
 * Google Sheets, and a failed fetch keeps the previous data in place.
 */

// 1. Paste the dynamic data link copied from Adriel.
const CSV_URL = "PASTE_YOUR_DYNAMIC_DATA_LINK_HERE";

// 2. Enter the exact name of the tab to write to.
//    Everything on this tab is replaced on each refresh.
const SHEET_NAME = "PASTE_YOUR_TAB_NAME_HERE";

function refreshAdrielData() {
  const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = spreadsheet.getSheetByName(SHEET_NAME);
  if (!sheet) {
    notify_(`Tab "${SHEET_NAME}" was not found. Check SHEET_NAME.`);
    return;
  }

  // A unique timestamp on every request makes sure no cached copy is returned.
  const url = CSV_URL + (CSV_URL.includes("?") ? "&" : "?") + "_ts=" + Date.now();
  const response = UrlFetchApp.fetch(url, { muteHttpExceptions: true });

  if (response.getResponseCode() !== 200) {
    notify_(`Could not load data (HTTP ${response.getResponseCode()}). The previous data was kept.`);
    return;
  }

  const rows = Utilities.parseCsv(response.getContentText("UTF-8"));
  if (rows.length === 0) {
    notify_("The link returned no data. The previous data was kept.");
    return;
  }

  sheet.clearContents();
  sheet.getRange(1, 1, rows.length, rows[0].length).setValues(rows);
  spreadsheet.toast("Data refreshed.", "Adriel", 3);
}

// Adds an Adriel > Refresh data menu when the sheet opens.
function onOpen() {
  SpreadsheetApp.getUi()
    .createMenu("Adriel")
    .addItem("Refresh data", "refreshAdrielData")
    .addToUi();
}

// Shows an alert when run from the menu or editor. Alerts are unavailable
// in time-driven triggers, so the error is thrown instead, which makes
// Google send its trigger failure email.
function notify_(message) {
  try {
    SpreadsheetApp.getUi().alert(message);
  } catch (e) {
    throw new Error(message);
  }
}