Render mockups with Google Sheets and SudoMock

function storeKey() {
  PropertiesService.getScriptProperties()
    .setProperty('SUDOMOCK_API_KEY', 'sm_your_api_key');
}

const API_URL = 'https://api.sudomock.com/api/v1/renders';

const TEMPLATES = {
  't-shirt': {
    mockup: 'YOUR_MOCKUP_UUID',
    layer: 'YOUR_SMART_OBJECT_UUID',
  },
  mug: {
    mockup: 'YOUR_MOCKUP_UUID',
    layer: 'YOUR_SMART_OBJECT_UUID',
  },
};

function onOpen() {
  SpreadsheetApp.getUi()
    .createMenu('SudoMock')
    .addItem('Render every row', 'renderEveryRow')
    .addToUi();
}

function renderEveryRow() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet()
    .getActiveSheet();
  const rows = sheet.getDataRange().getValues();

  for (let i = 1; i < rows.length; i++) {
    const [designUrl, product, existing] = rows[i];
    if (!designUrl || existing) continue;

    try {
      sheet
        .getRange(i + 1, 3)
        .setValue(renderOne(designUrl, product));
      sheet.getRange(i + 1, 4).setValue('Done');
    } catch (error) {
      sheet.getRange(i + 1, 4).setValue(error.message);
    }
    SpreadsheetApp.flush();
  }
}

function renderOne(designUrl, product) {
  const template = TEMPLATES[String(product).toLowerCase()];
  if (!template) {
    throw new Error('No template mapped for ' + product);
  }

  const response = UrlFetchApp.fetch(API_URL, {
    method: 'post',
    contentType: 'application/json',
    headers: {
      'x-api-key': PropertiesService.getScriptProperties()
        .getProperty('SUDOMOCK_API_KEY'),
    },
    payload: JSON.stringify({
      mockup_uuid: template.mockup,
      smart_objects: [
        {
          uuid: template.layer,
          asset: { url: designUrl, fit: 'crop' },
        },
      ],
      export_options: {
        image_format: 'webp',
        image_size: 1920,
        quality: 90,
      },
    }),
    muteHttpExceptions: true,
  });

  const result = JSON.parse(response.getContentText());
  if (response.getResponseCode() >= 400) {
    throw new Error(result.detail || 'Render failed');
  }
  return result.data.print_files[0].export_path;
}