Track your work with Claude.
No spreadsheets. No setup hell.

I'm setting up a personal work tracker. My tracker folder is at:
[PASTE YOUR FOLDER PATH — e.g. C:\Users\yourname\Documents\Work Tracker\]

The files in that folder are:
- data.json — the one you update each session (Claude reads and rewrites this)
- index.html — the display shell, never needs to change
- tools/parse_tasks.py + tools/encrypt_data.py — the generator and the password-gate encryptor
- work-tracker-pipeline-friend.skill — the architecture reference for this whole system

Before we start, please check four things:
0. VERSION CHECK: open index.html and confirm its second line says "KIT_VERSION: 2026-07-01.2". Also check the VERSION file from the starter zip. Then, if you have web access, fetch https://shadiaalkhaledi-dot.github.io/AIworkflow/work-tracker-guide.html and confirm no newer KIT_VERSION is mentioned there. If my files are missing the stamp, show an older version, or the live guide lists a newer one, STOP and tell me — I need to re-download work-tracker-starter.zip from that page before we set anything up.
1. Do I have a Cowork folder selected that points to the folder above? If not, remind me to add it in the Claude desktop app (Cowork panel → select folder) before continuing.
2. Is there a work-tracker-pipeline-friend.skill file in this folder? If so, read it now (or tell me to attach it and say "install this skill" if you can't read .skill files directly) — it explains the tagging conventions and generator logic so you don't have to guess at them each session.
3. Does data.json have a real Apps Script URL in the "apiUrl" field, or does it still say "PASTE_YOUR_APPS_SCRIPT_URL_HERE"? If it's still a placeholder, remind me to set up Google Sheets + Apps Script (see Step 6 of the setup guide) and paste the URL before our first real session. We can still do the onboarding interview now, but Quick Capture won't work until that's set.

Now, interview me about my work so you can fill in data.json properly. Ask me one topic at a time:

1. What is my project or role — what am I responsible for?
2. What are the main workstreams or programs I'm tracking? (e.g. different building packages, client files, product areas)
3. Who are the key people I work with — names, roles, and what I need from them?
4. What are the open items currently on my plate — what's in progress, what's blocked, what am I waiting on?
5. What meetings or decisions happened recently that I should capture?
6. Are there any notes from Microsoft Copilot, Teams, or email that I want to pull in?

After the interview, write a complete data.json and save it to my tracker folder. Then tell me how to upload it to GitHub so my tracker site updates.

Work session check-in. My tracker folder is at:
[YOUR FOLDER PATH — e.g. C:\Users\yourname\Documents\Work Tracker\]

My live tracker site is at: [YOUR GITHUB PAGES URL]

If you have work-tracker-pipeline-friend.skill installed or available in this folder, use it as your reference for the tagging conventions (status/court/horizon/action/cat/disc) so things stay consistent as this grows.

Please read the current data.json and then ask me:
- What happened since last time?
- Anything new that's blocking me?
- Any items I can mark done?
- Any new items to add?
- Any meetings or decisions to capture?

After I fill you in, update data.json to reflect today's state — new items, completed items, updated notes, and a "what we sorted out today" summary. Set meta.generated to today's date.

Then, if I've set a site password: re-encrypt with tools/encrypt_data.py (data.json → data.enc.json) and give me data.enc.json to upload to GitHub — never the plain data.json. If I haven't set a password yet, give me data.json as before.

var LOG_HEADER = ['Timestamp', 'Type', 'Program', 'Package', 'ItemRef', 'Text', 'Synced'];

function getSheet() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Log');
  if (!sheet) {
    sheet = ss.insertSheet('Log');
    sheet.appendRow(LOG_HEADER);
    sheet.setFrozenRows(1);
  }
  return sheet;
}

function doPost(e) {
  var sheet = getSheet();
  var data = JSON.parse(e.postData.contents);

  if (data.action === 'edit') {
    return handleEdit(sheet, data);
  }

  sheet.appendRow([
    new Date(), data.type || '', data.program || '', data.pkg || '',
    data.itemRef || '', data.text || '', 'N'
  ]);
  return ContentService.createTextOutput(JSON.stringify({ok: true}))
    .setMimeType(ContentService.MimeType.JSON);
}

function handleEdit(sheet, data) {
  var row = Number(data.row);
  if (!row || row < 2 || row > sheet.getLastRow()) {
    return ContentService.createTextOutput(JSON.stringify({ok: false, error: 'Invalid row'}))
      .setMimeType(ContentService.MimeType.JSON);
  }
  sheet.getRange(row, 2, 1, 5).setValues([[
    data.type || '', data.program || '', data.pkg || '', data.itemRef || '', data.text || ''
  ]]);
  return ContentService.createTextOutput(JSON.stringify({ok: true}))
    .setMimeType(ContentService.MimeType.JSON);
}

function doGet(e) {
  var sheet = getSheet();
  var action = e.parameter.action || 'pending';

  if (action === 'markSynced') {
    var rows = JSON.parse(e.parameter.rows || '[]');
    rows.forEach(function(r){ sheet.getRange(r, 7).setValue('Y'); });
    return ContentService.createTextOutput(JSON.stringify({ok: true, marked: rows.length}))
      .setMimeType(ContentService.MimeType.JSON);
  }

  var values = sheet.getDataRange().getValues();
  var out = [];
  for (var i = 1; i < values.length; i++) {
    if (String(values[i][6]) === 'N') {
      out.push({row: i+1, ts: values[i][0], type: values[i][1],
        program: values[i][2], pkg: values[i][3], itemRef: values[i][4], text: values[i][5]});
    }
  }
  return ContentService.createTextOutput(JSON.stringify(out))
    .setMimeType(ContentService.MimeType.JSON);
}

function out(data) {
  return ContentService.createTextOutput(JSON.stringify(data))
    .setMimeType(ContentService.MimeType.JSON);
}