Your members in Google Sheets

// Scoutworks → Google Sheets. https://developers.scoutworks.app/recipes/google-sheets

function importMembers() {
  const apiKey = PropertiesService.getScriptProperties().getProperty('SCOUTWORKS_API_KEY');
  if (!apiKey) throw new Error('Add SCOUTWORKS_API_KEY in Project Settings → Script Properties.');

  const rows = [['First name', 'Last name', 'Sections', 'Patrol', 'Joined']];
  let cursor = null;

  do {
    let url = 'https://api-demo.scoutworks.app/api/v1/members?limit=200';
    if (cursor) url += '&cursor=' + encodeURIComponent(cursor);
    const body = fetchScoutworks(url, apiKey);

    body.data.forEach(function (m) {
      rows.push([
        safe(m.firstName),
        safe(m.lastName),
        safe(m.sections.map(function (s) { return s.name; }).join(', ')),
        safe(m.patrol ? m.patrol.name : ''),
        m.joinedAt.slice(0, 10),
      ]);
    });
    cursor = body.nextCursor;
  } while (cursor);

  const book = SpreadsheetApp.getActive();
  const sheet = book.getSheetByName('Members') || book.insertSheet('Members');
  sheet.clearContents();
  sheet.getRange(1, 1, rows.length, rows[0].length).setValues(rows);
}

// Calls the API. Waits and tries again if the rate limit is reached.
function fetchScoutworks(url, apiKey) {
  for (let attempt = 0; attempt < 3; attempt++) {
    const res = UrlFetchApp.fetch(url, {
      headers: { Authorization: 'Bearer ' + apiKey },
      muteHttpExceptions: true,
    });
    const body = JSON.parse(res.getContentText());
    if (res.getResponseCode() === 200) return body;
    if (res.getResponseCode() === 429) {
      Utilities.sleep((body.retryAfter || 30) * 1000);
      continue;
    }
    throw new Error(body.error.code + ': ' + body.error.message);
  }
  throw new Error('Scoutworks is still busy. Try again in a minute.');
}

// Stops a name that starts with = + - or @ from running as a formula.
function safe(value) {
  const text = String(value);
  return /^\s*[=+\-@]/.test(text) ? "'" + text : text;
}