Family Tree

1. Open your Google Sheet.
2. Go to Extensions → Apps Script.
3. Replace any existing code with the script below and click Save.
4. Click Deploy → New deployment.
5. Choose type: Web app. Set "Execute as: Me" and "Who has access: Anyone".
6. Click Deploy, authorize, then copy the Web app URL.
7. Paste that URL into the "Apps Script URL" field on the setup screen.

function doPost(e) {
  try {
    const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
    const data = JSON.parse(e.postData.contents);
    const values = sheet.getDataRange().getValues();

    function findRow(id) {
      for (let i = 1; i < values.length; i++)
        if (String(values[i][0]) === String(id)) return i + 1;
      return -1;
    }

    if (data.action === 'updateSpouse') {
      const row = findRow(data.id);
      if (row === -1) return ok({ success: false, error: 'ID not found' });
      sheet.getRange(row, 6).setValue(data.spouse);
      return ok({ success: true });
    }

    if (data.action === 'updateParent') {
      const row = findRow(data.id);
      if (row === -1) return ok({ success: false, error: 'ID not found' });
      // col 4 = parent1, col 5 = parent2
      sheet.getRange(row, data.slot === 'parent2' ? 5 : 4).setValue(data.parentId);
      return ok({ success: true });
    }

    if (data.action === 'updatePerson') {
      const row = findRow(data.id);
      if (row === -1) return ok({ success: false, error: 'ID not found' });
      sheet.getRange(row, 2).setValue(data.firstName);
      sheet.getRange(row, 3).setValue(data.lastName);
      sheet.getRange(row, 7).setValue(data.picture || '');
      sheet.getRange(row, 8).setValue(data.comments || '');
      return ok({ success: true });
    }

    if (data.action === 'deletePerson') {
      const row = findRow(data.id);
      if (row === -1) return ok({ success: false, error: 'ID not found' });
      sheet.deleteRow(row);
      return ok({ success: true });
    }

    // Default: append new person row
    sheet.appendRow([
      data.id, data.firstName, data.lastName,
      data.parent1 || '', data.parent2 || '',
      data.spouse  || '', data.picture || '', data.comments || ''
    ]);
    return ok({ success: true });
  } catch (err) {
    return ok({ success: false, error: err.toString() });
  }
}

function ok(obj) {
  return ContentService
    .createTextOutput(JSON.stringify(obj))
    .setMimeType(ContentService.MimeType.JSON);
}

function doGet(e) {
  return ok({ status: 'ok' });
}

1. Go to console.cloud.google.com and create a new project (or pick an existing one).
2. In the left menu go to APIs & Services → Library. Search for Google Sheets API and enable it.
3. Go to APIs & Services → Credentials. Click Create Credentials → OAuth client ID.
4. Choose application type Web application.
5. Under Authorised JavaScript origins add http://localhost:3000.
6. Click Create and copy the Client ID (ends in .apps.googleusercontent.com).
7. Paste it into the Google Client ID field on the setup screen, then load your tree and click Sign in with Google.

You only need to sign in once per session. The sheet must still be set to Anyone with link can view for reading.