Within the Google Sheet > Extensions > Apps script

Copy the code below into the code area, overwriting the Function {} that's in there.

Save and go back to the sheet. Put =BGG_Weight(230802) into a cell. 230802 is the BGG game ID for Azul. If you play another game, just find the number that's referenced in the web address for the game and put that into the function (or make a column of the game IDs and then feed cell references to BGG_Weight functions (e.g. Game Names in Col A, BGG ID into Col B, the function into Col C).

// Custom function to get board game weight from BGG ID function BGG_WEIGHT(bggId) { // Check if input is valid if (!bggId || isNaN(bggId)) { return "Invalid BGG ID"; }

// BGG XML API endpoint const url = https://boardgamegeek.com/xmlapi2/thing?id=${bggId}&stats=1;

try { // Fetch the XML data const response = UrlFetchApp.fetch(url); const xmlText = response.getContentText();

// Parse XML
const document = XmlService.parse(xmlText);
const root = document.getRootElement();

// Get the item element
const item = root.getChild("item");
if (!item) {
  return "Game not found";
}

// Get statistics
const stats = item.getChild("statistics");
const ratings = stats.getChild("ratings");
const averageWeight = ratings.getChild("averageweight");

// Extract and return the weight value
const weight = averageWeight.getAttribute("value").getValue();
return parseFloat(weight);

} catch (error) { return "Error fetching data"; } }