Task Management Tool - Elijah L Fennell

// ================================================================
// TASK MANAGER — Google Apps Script Bridge v4.2
// Built by Elijah Fennell — elijahlfennell.com
// Setup guide: elijahlfennell.com/tools/task-management/
// ================================================================
// SETUP (one time only):
//   1. In your Google Sheet: Extensions → Apps Script
//   2. Replace all existing code with this entire file
//   3. Project Settings → Script Properties → Add property:
//        Name: API_KEY   Value: choose any password, e.g. “mykey2026”
//   4. Click Deploy → New deployment → Web app
//      Execute as: Me | Who has access: Anyone
//   5. Copy the Web App URL → paste into Task Manager → Sync tab
// ================================================================
// CHANGES FROM v4.1:
//   – Added uploadPhotos action: receives up to 3 compressed base64
//     photos per task, saves them to a Drive folder named
//     “Task Manager Photos”, returns direct-view URLs. Used by the
//     photo attachment feature — keeps the sheet itself small since
//     only links are stored, never raw image data.
//   – Added Photo_URLs column.
// ================================================================
// CHANGES FROM v1.0:
//   – Added addTask action: appends a single task without overwriting
//     the sheet. Used by manager assignment workflow.
//   – Added formatHeader helper used by both writeTasks and appendTask.
// ================================================================

const SHEET_NAME = ‘Tasks’;
const PHOTO_FOLDER_NAME = ‘Task Manager Photos’;

const HEADERS = [
  ‘ID’,’Title’,’Area’,’Category’,’Tag’,’Priority’,’Importance’,’Type’,
  ‘Status’,’Status_Pct’,’Project’,’Assigned_To’,’Due_Date’,
  ‘Added_DateTime’,’Completed_DateTime’,’Updated_DateTime’,
  ‘TTC_Hours’,’TTC_Formatted’,’Week_Added’,’Year_Added’,’Notes’,’Photo_URLs’
];

// Maps internal HTML tool task fields → sheet column headers
const TO_SHEET = {
  id:’ID’, title:’Title’, area:’Area’, cat:’Category’, tag:’Tag’,
  pri:’Priority’, importance:’Importance’, type:’Type’, status:’Status’,
  statusPct:’Status_Pct’, project:’Project’, assignedTo:’Assigned_To’,
  dueDate:’Due_Date’, addedDT:’Added_DateTime’, completedDT:’Completed_DateTime’,
  updatedDT:’Updated_DateTime’, notes:’Notes’, photoUrls:’Photo_URLs’
};

// Reverse: sheet column header → internal field
const FROM_SHEET = Object.fromEntries(
  Object.entries(TO_SHEET).map(([k,v]) => [v,k])
);

// ── Auth ──────────────────────────────────────────────────────────
function getApiKey() {
  return PropertiesService.getScriptProperties().getProperty(‘API_KEY’) || ”;
}
function auth(key) {
  const stored = getApiKey();
  return stored.length > 0 && key === stored;
}
function out(data) {
  return ContentService.createTextOutput(JSON.stringify(data))
    .setMimeType(ContentService.MimeType.JSON);
}
function deny() {
  return out({success: false, error: ‘Invalid or missing API key’});
}

// ── GET handler ───────────────────────────────────────────────────
// Usage: ?key=YOUR_KEY&action=ping|getTasks
function doGet(e) {
  try {
    const p = e.parameter || {};
    if (!auth(p.key || ”)) return deny();
    const action = p.action || ‘getTasks’;
    if (action === ‘ping’) {
      return out({
        success: true,
        message: ‘Task Manager connected ✓’,
        sheet: SpreadsheetApp.getActiveSpreadsheet().getName(),
        timestamp: new Date().toISOString()
      });
    }
    if (action === ‘getTasks’) {
      return out({success: true, tasks: readTasks()});
    }
    return out({success: false, error: ‘Unknown action: ‘ + action});
  } catch(err) {
    return out({success: false, error: err.toString()});
  }
}

// ── POST handler ──────────────────────────────────────────────────
// Body (text/plain): JSON string { key, action, tasks?, task? }
//
// Actions:
//   pushTasks — full sync: clears sheet and rewrites all tasks
//               (HTML tool merges sheet data first before calling this)
//   addTask   — appends a single task row without touching existing rows
//               Used by manager assignment: sends a task to this sheet
//               without overwriting the employee’s data
function doPost(e) {
  try {
    const body = JSON.parse((e.postData || {}).contents || ‘{}’);
    if (!auth(body.key || ”)) return deny();
    const action = body.action || ‘pushTasks’;

if (action === ‘pushTasks’) {
      const count = writeTasks(body.tasks || []);
      return out({
        success: true,
        count: count,
        message: count + ‘ tasks synced to Google Sheets’
      });
    }

// addTask: append one task without clearing the sheet
    // The HTML tool sends a timestamp-based ID to avoid conflicts
    // with the employee’s sequential IDs
    if (action === ‘addTask’) {
      const task = body.task;
      if (!task || !task.title) {
        return out({success: false, error: ‘No valid task provided’});
      }
      const id = appendTask(task);
      return out({
        success: true,
        message: ‘Task “‘ + task.title + ‘” added to sheet’,
        id: id
      });
    }

// uploadPhotos: receives up to 3 base64-encoded compressed photos
    // for one task, saves each to Drive, returns direct-view URLs.
    // The sheet itself only ever stores these URLs, never raw image
    // data, so the spreadsheet stays small regardless of photo volume.
    if (action === ‘uploadPhotos’) {
      const photos = body.photos || [];
      if (!photos.length) {
        return out({success: false, error: ‘No photos provided’});
      }
      const urls = photos.map(function(p, i) {
        return savePhotoToDrive(p, body.taskId || ‘task’, i);
      });
      return out({success: true, urls: urls});
    }

return out({success: false, error: ‘Unknown action: ‘ + action});
  } catch(err) {
    return out({success: false, error: err.toString()});
  }
}

// ── Read all tasks from the sheet ─────────────────────────────────
function readTasks() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheetByName(SHEET_NAME);
  if (!sheet || sheet.getLastRow() < 2) return [];

const data = sheet.getRange(1, 1, sheet.getLastRow(), sheet.getLastColumn()).getValues();
  const headers = data[0].map(h => h.toString().trim());
  const tasks = [];

for (let i = 1; i < data.length; i++) {
    const row = data[i];
    if (!row[0] && !row[1]) continue;
    const task = {};
    headers.forEach((h, j) => {
      const field = FROM_SHEET[h] || h.toLowerCase().replace(/ /g, ‘_’);
      const val = row[j];
      task[field] = (val !== null && val !== undefined) ? val.toString() : ”;
    });
    if (task.id) task.id = parseInt(task.id) || task.id;
    tasks.push(task);
  }
  return tasks;
}

// ── Write all tasks to sheet (full overwrite) ─────────────────────
// The HTML tool merges sheet data before calling this (V4 smart push),
// so manager-assigned tasks are already in the task array by the time
// this function runs. This function itself is unchanged from v1.0.
function writeTasks(tasks) {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  let sheet = ss.getSheetByName(SHEET_NAME);
  if (!sheet) sheet = ss.insertSheet(SHEET_NAME);
  sheet.clearContents();

sheet.getRange(1, 1, 1, HEADERS.length).setValues([HEADERS]);
  if (!tasks.length) return 0;

const rows = tasks.map(t => {
    const ttc = calcTTC(t.addedDT, t.completedDT);
    return HEADERS.map(h => {
      if (h === ‘TTC_Hours’)     return ttc.hours;
      if (h === ‘TTC_Formatted’) return ttc.formatted;
      if (h === ‘Week_Added’)    return weekNum(t.addedDT);
      if (h === ‘Year_Added’)    return t.addedDT ? t.addedDT.slice(0,4) : ”;
      const field = FROM_SHEET[h];
      const val = field ? t[field] : t[h];
      return (val !== null && val !== undefined) ? val.toString() : ”;
    });
  });

sheet.getRange(2, 1, rows.length, HEADERS.length).setValues(rows);
  formatHeader(sheet, HEADERS.length);
  sheet.setFrozenRows(1);

const widths = [6,38,12,14,12,8,10,14,14,10,18,14,12,22,22,22,10,14,9,9,40,50];
  widths.forEach((w, i) => sheet.setColumnWidth(i+1, w*7));

applyStatusFormatting(sheet, rows.length + 1);
  return tasks.length;
}

// ── Append a single task row (does not clear the sheet) ───────────
// Used by the manager assignment workflow. Ensures manager-assigned
// tasks land in the employee’s sheet without destroying existing data.
// Returns the ID used for the appended task.
function appendTask(task) {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  let sheet = ss.getSheetByName(SHEET_NAME);
  if (!sheet) sheet = ss.insertSheet(SHEET_NAME);

// Create headers if sheet is empty
  if (sheet.getLastRow() === 0) {
    sheet.getRange(1, 1, 1, HEADERS.length).setValues([HEADERS]);
    formatHeader(sheet, HEADERS.length);
    sheet.setFrozenRows(1);
  }

const ttc = calcTTC(task.addedDT, task.completedDT);
  const row = HEADERS.map(h => {
    if (h === ‘TTC_Hours’)     return ttc.hours;
    if (h === ‘TTC_Formatted’) return ttc.formatted;
    if (h === ‘Week_Added’)    return weekNum(task.addedDT);
    if (h === ‘Year_Added’)    return task.addedDT ? task.addedDT.slice(0,4) : ”;
    const field = FROM_SHEET[h];
    const val = field ? task[field] : task[h];
    return (val !== null && val !== undefined) ? val.toString() : ”;
  });

sheet.getRange(sheet.getLastRow() + 1, 1, 1, HEADERS.length).setValues([row]);
  return task.id;
}

// ── Helpers ───────────────────────────────────────────────────────
function formatHeader(sheet, cols) {
  const r = sheet.getRange(1, 1, 1, cols);
  r.setBackground(‘#185FA5’)
   .setFontColor(‘#FFFFFF’)
   .setFontWeight(‘bold’)
   .setFontSize(9)
   .setFontFamily(‘Arial’);
}

function applyStatusFormatting(sheet, lastRow) {
  if (lastRow < 2) return;
  const statusRange = sheet.getRange('I2:I' + lastRow);
  const rules = [
    SpreadsheetApp.newConditionalFormatRule()
      .whenTextEqualTo('Done')
      .setBackground('#E1F5EE').setFontColor('#1D9E75')
      .setRanges([statusRange]).build(),
    SpreadsheetApp.newConditionalFormatRule()
      .whenTextEqualTo('Blocked')
      .setBackground('#EEEDFE').setFontColor('#7F77DD')
      .setRanges([statusRange]).build(),
    SpreadsheetApp.newConditionalFormatRule()
      .whenTextEqualTo('Archived')
      .setBackground('#E5E7EB').setFontColor('#9CA3AF')
      .setRanges([statusRange]).build()
  ];
  sheet.setConditionalFormatRules(rules);
}

// ── Photo storage ─────────────────────────────────────────────────
// Decodes a base64 JPEG (already compressed client-side by the HTML
// tool before it ever reaches here), saves it into a dedicated Drive
// folder, sets it shareable, and returns a direct-view URL suitable
// for use in an <img decoding="async" src="..."> tag. The sheet only ever stores this
// URL string — never the image data itself.
function savePhotoToDrive(base64Data, taskId, index) {
  try {
    // Strip the “data:image/jpeg;base64,” prefix if present
    const clean = base64Data.replace(/^data:image\/\w+;base64,/, ”);
    const bytes = Utilities.base64Decode(clean);
    const blob = Utilities.newBlob(bytes, ‘image/jpeg’,
      ‘task_’ + taskId + ‘_’ + index + ‘.jpg’);

const folder = getOrCreatePhotoFolder();
    const file = folder.createFile(blob);
    file.setSharing(DriveApp.Access.ANYONE_WITH_LINK, DriveApp.Permission.VIEW);

// Direct-view URL format — embeds cleanly in <img> tags, unlike
    // the default Drive “view” link which opens a preview page instead
    return ‘https://drive.google.com/uc?export=view&id=’ + file.getId();
  } catch (err) {
    return ‘ERROR: ‘ + err.toString();
  }
}

function getOrCreatePhotoFolder() {
  const folders = DriveApp.getFoldersByName(PHOTO_FOLDER_NAME);
  if (folders.hasNext()) return folders.next();
  return DriveApp.createFolder(PHOTO_FOLDER_NAME);
}

// ================================================================
// TASK MANAGER — Master Team Aggregator v4.2
// Built by Elijah Fennell — elijahlfennell.com
// Setup guide: elijahlfennell.com/tools/task-management/
// ================================================================
// PURPOSE:
//   Pulls tasks from multiple individual team member sheets into
//   one combined view. Run this from your MASTER sheet only.
//
// SETUP:
//   1. Create a new Google Sheet (your Master/Manager sheet)
//   2. Extensions → Apps Script
//   3. Paste this entire file, replacing all existing code
//   4. Edit TEAM_MEMBERS below with each person’s Sheet ID
//      Sheet ID is in the URL: docs.google.com/spreadsheets/d/SHEET_ID/edit
//   5. Save → Run pullAllTasks once to authorize permissions
//   6. After that, use the Team Tasks menu in your Master sheet
//
// OPTIONAL AUTO-REFRESH:
//   Triggers → Add Trigger → pullAllTasks → Time-driven → Every hour
// ================================================================

// ── Configure your team here ──────────────────────────────────────
const TEAM_MEMBERS = [
  { name: ‘Elijah’, sheetId: ‘PASTE_SHEET_ID_HERE’ },
  { name: ‘Mike’,   sheetId: ‘PASTE_SHEET_ID_HERE’ },
  { name: ‘Sarah’,  sheetId: ‘PASTE_SHEET_ID_HERE’ },
  // Add more: { name: ‘Name’, sheetId: ‘SHEET_ID’ },
];
// ─────────────────────────────────────────────────────────────────

const TASKS_SHEET  = ‘Tasks’;
const MASTER_SHEET = ‘All Tasks’;
const DASH_SHEET   = ‘Team Dashboard’;

const ALL_COLS = [
  ‘User’,’ID’,’Title’,’Area’,’Category’,’Tag’,’Priority’,’Importance’,
  ‘Type’,’Status’,’Status_Pct’,’Project’,’Assigned_To’,’Due_Date’,
  ‘Added_DateTime’,’Completed_DateTime’,’Updated_DateTime’,
  ‘TTC_Hours’,’TTC_Formatted’,’Week_Added’,’Year_Added’,’Notes’,’Photo_URLs’
];

// ── Menu ──────────────────────────────────────────────────────────
function onOpen() {
  SpreadsheetApp.getUi()
    .createMenu(‘Team Tasks’)
    .addItem(‘Pull all tasks now’, ‘pullAllTasks’)
    .addSeparator()
    .addItem(‘Rebuild dashboard’, ‘buildDashboard’)
    .addItem(‘Pull + rebuild (full refresh)’, ‘fullRefresh’)
    .addToUi();
}
function fullRefresh() { pullAllTasks(); buildDashboard(); }

// ── Pull all tasks from every team member’s sheet ─────────────────
function pullAllTasks() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  let master = ss.getSheetByName(MASTER_SHEET);
  if (!master) master = ss.insertSheet(MASTER_SHEET);
  master.clearContents();
  master.getRange(1, 1, 1, ALL_COLS.length).setValues([ALL_COLS]);

const allRows = [];
  const errors  = [];

TEAM_MEMBERS.forEach(member => {
    try {
      const src   = SpreadsheetApp.openById(member.sheetId);
      const sheet = src.getSheetByName(TASKS_SHEET);
      if (!sheet || sheet.getLastRow() < 2) {
        Logger.log(member.name + ': no tasks found');
        return;
      }
      const data    = sheet.getRange(1, 1, sheet.getLastRow(), sheet.getLastColumn()).getValues();
      const headers = data[0].map(h => h.toString().trim());

for (let i = 1; i < data.length; i++) {
        const row = data[i];
        if (!row[0] && !row[1]) continue;
        const rowMap = {};
        headers.forEach((h, j) => { rowMap[h] = row[j] !== null ? row[j].toString() : ”; });
        const user   = rowMap[‘User’] || member.name;
        const outRow = ALL_COLS.map(col => col === ‘User’ ? user : (rowMap[col] || ”));
        allRows.push(outRow);
      }
    } catch(err) {
      const msg = ‘Could not read ‘ + member.name + ‘: ‘ + err.toString();
      Logger.log(msg);
      errors.push(msg);
    }
  });

if (allRows.length > 0) {
    master.getRange(2, 1, allRows.length, ALL_COLS.length).setValues(allRows);
  }

formatHeader(master, ALL_COLS.length);
  master.setFrozenRows(1);

const widths = [12,6,38,12,14,12,8,10,14,14,10,18,14,12,22,22,22,10,14,9,9,40,50];
  widths.forEach((w, i) => master.setColumnWidth(i+1, w*7));
  applyStatusFormatting(master, allRows.length + 1);

const summary = ‘Pulled ‘ + allRows.length + ‘ tasks from ‘ + TEAM_MEMBERS.length + ‘ team members.’ +
    (errors.length ? ‘\n\nErrors:\n’ + errors.join(‘\n’) : ”);
  SpreadsheetApp.getUi().alert(summary);
}

// ── Build team dashboard ──────────────────────────────────────────
function buildDashboard() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  let dash = ss.getSheetByName(DASH_SHEET);
  if (!dash) dash = ss.insertSheet(DASH_SHEET, 1);
  dash.clearContents();

dash.getRange(‘A1’).setValue(‘Team Task Manager — Dashboard’)
      .setFontSize(14).setFontWeight(‘bold’).setFontColor(‘#185FA5’);
  dash.getRange(‘A2’).setValue(‘Last refreshed: ‘ + new Date().toLocaleString())
      .setFontSize(9).setFontColor(‘#6B7280’).setFontStyle(‘italic’);

const mRow   = 4;
  const labels = [‘Member’,’Total’,’Open’,’Done’,’Blocked’,’Overdue’,’Completion %’];
  dash.getRange(mRow, 1, 1, labels.length).setValues([labels]);
  formatHeader(dash, labels.length, mRow);

TEAM_MEMBERS.forEach((m, i) => {
    const r    = mRow + 1 + i;
    const uRef = “‘” + MASTER_SHEET + “‘!A:A”;
    const sRef = “‘” + MASTER_SHEET + “‘!J:J”;
    const dRef = “‘” + MASTER_SHEET + “‘!N:N”;
    dash.getRange(r, 1).setValue(m.name).setFontWeight(‘bold’);
    dash.getRange(r, 2).setFormula(‘=COUNTIF(‘ + uRef + ‘,”‘ + m.name + ‘”)’);
    dash.getRange(r, 3).setFormula(‘=COUNTIFS(‘ + uRef + ‘,”‘ + m.name + ‘”,’ + sRef + ‘,”<>Done”,’ + sRef + ‘,”<>Archived”)’);
    dash.getRange(r, 4).setFormula(‘=COUNTIFS(‘ + uRef + ‘,”‘ + m.name + ‘”,’ + sRef + ‘,”Done”)’);
    dash.getRange(r, 5).setFormula(‘=COUNTIFS(‘ + uRef + ‘,”‘ + m.name + ‘”,’ + sRef + ‘,”Blocked”)’);
    dash.getRange(r, 6).setFormula(‘=COUNTIFS(‘ + uRef + ‘,”‘ + m.name + ‘”,’ + sRef + ‘,”<>Done”,’ + sRef + ‘,”<>Archived”,’ + dRef + ‘,”<"&TEXT(TODAY(),"YYYY-MM-DD"),' + dRef + ',"<>“&””)’);
    dash.getRange(r, 7).setFormula(‘=IFERROR(D’ + r + ‘/B’ + r + ‘,”—”)’).setNumberFormat(‘0%’);
    dash.getRange(r, 1, 1, labels.length).setBackground(i % 2 === 0 ? ‘#E6F1FB’ : ‘#FFFFFF’);
  });

const totRow = mRow + 1 + TEAM_MEMBERS.length;
  dash.getRange(totRow, 1).setValue(‘TOTAL’).setFontWeight(‘bold’);
  for (let c = 2; c <= 6; c++) {
    const col = String.fromCharCode(64 + c);
    dash.getRange(totRow, c).setFormula('=SUM(' + col + (mRow+1) + ':' + col + (totRow-1) + ')').setFontWeight('bold');
  }
  dash.getRange(totRow, 7).setFormula('=IFERROR(D' + totRow + '/B' + totRow + ',"—")')
      .setNumberFormat('0%').setFontWeight('bold');
  dash.getRange(totRow, 1, 1, labels.length).setBackground('#D6E8F7');
  [18,10,10,10,10,10,14].forEach((w,i) => dash.setColumnWidth(i+1, w*7));

SpreadsheetApp.getUi().alert(‘Team Dashboard rebuilt.’);
}

// ── Helpers ───────────────────────────────────────────────────────
function formatHeader(sheet, cols, row) {
  row = row || 1;
  sheet.getRange(row, 1, 1, cols)
       .setBackground(‘#185FA5’).setFontColor(‘#FFFFFF’)
       .setFontWeight(‘bold’).setFontSize(9).setFontFamily(‘Arial’);
}

function applyStatusFormatting(sheet, lastRow) {
  if (lastRow < 2) return;
  const statusCol = ALL_COLS.indexOf('Status') + 1;
  const range     = sheet.getRange(2, statusCol, lastRow - 1, 1);
  sheet.setConditionalFormatRules([
    SpreadsheetApp.newConditionalFormatRule().whenTextEqualTo('Done')
        .setBackground('#E1F5EE').setFontColor('#1D9E75').setRanges([range]).build(),
    SpreadsheetApp.newConditionalFormatRule().whenTextEqualTo('Blocked')
        .setBackground('#EEEDFE').setFontColor('#7F77DD').setRanges([range]).build(),
    SpreadsheetApp.newConditionalFormatRule().whenTextEqualTo('Archived')
        .setBackground('#E5E7EB').setFontColor('#9CA3AF').setRanges([range]).build()
  ]);
}

Free Tool

Task Manager — Setup Guide

Download the files below and follow the setup steps to get your task manager running — individually or across a whole team.

Download Files

Download the files below, then follow Individual Setup or Team Setup to get everything running. The HTML tool works immediately with no setup — just open it.

Ready-to-use files

🌐

taskmanager.html — The Main Tool

The full task manager. Works offline and online with no install required. Add tasks, track progress, sync to Google Sheets, and export CSV — all from your browser. Works on desktop and mobile.

⭐ Recommended — Use via URL

Visit the tool directly in your browser. Works on any device including phone. Bookmark it or Add to Home Screen on mobile to use like an app. No download, no install.

Open Task Manager

Opens in your browser — bookmark it for quick access

Alternative — Download File

Download the HTML file for offline desktop use. Note: Downloaded HTML files do not work when opened on a phone — use the URL method above for mobile access.

Download .html

Desktop only — open in Chrome, Safari, or Edge

📊

Individual Sheet Template

Pre-formatted Google Sheets template for one person — live dashboard, drop-down status menus, conditional formatting, and aging formulas. This is where you import your CSV data and where the Apps Script sync writes to.

⭐ Recommended

Opens directly in Google Sheets — no upload, no conversion. One click and it’s yours.

Open in Google Sheets

You’ll be prompted to make your own copy

Alternative

Downloads as .xlsx. To use Apps Script sync you must upload to Google Drive → open → File → Save as Google Sheets.

Download .xlsx

👥

Master Team Template

Pre-built manager sheet. Paste master-aggregator.gs into this sheet’s Apps Script and it will pull tasks from all individual sheets into one combined view with a per-person dashboard. Only needed for team use.

⭐ Recommended

Opens directly in Google Sheets — already the right format for pasting the Apps Script.

Open in Google Sheets

You’ll be prompted to make your own copy

Alternative

Downloads as .xlsx. Upload to Google Drive → open → File → Save as Google Sheets before adding the Apps Script.

Download .xlsx

Using the tool on your phone

Don’t download the HTML file on your phone — mobile browsers block local HTML files as a security measure. Instead, visit the tool directly via its URL and bookmark it. Works in any mobile browser with no install needed.

Visit the tool URL in your phone’s browser
Chrome, Safari, or Edge work best

Tap the browser menu → Add to Home Screen
It will appear as an app icon on your phone

Tap the home screen icon to open — works offline after the first visit

Your tasks sync between phone and desktop via Push / Pull in the Sync tab

DuckDuckGo browser has restrictions that prevent some JavaScript tools from running. Use Chrome, Safari, or Edge for the best experience.

Google Apps Scripts

Apps Scripts cannot be downloaded as files — they live inside Google Sheets. Click Copy below, open your Google Sheet → Extensions → Apps Script → delete all existing code → paste.

Code.gs — Individual sync script

Paste into each person’s Google Sheet. Handles push/pull sync between the HTML tool and their sheet.

master-aggregator.gs — Team script

Paste into your Master / Team Google Sheet. Pulls tasks from all individual sheets into one combined view with per-person dashboard.

CSV Column Reference — 22 columns

ID Auto-increment integer

User Task owner name

Title Task description

Area Work / Personal / custom

Category MA / Office / etc.

Tag #prodev / #house / etc.

Priority 1=High 2=Med 3=Low

Importance 1=Critical 2=Normal

Type Task / Note / Time Tracking

Status Open / Done / Blocked

Status_Pct 0–100% complete

Project Project name

Assigned_To Who is doing the task

Due_Date YYYY-MM-DD

Added_DateTime Full timestamp

Completed_DateTime Full timestamp

Updated_DateTime Full timestamp

TTC_Hours Hours to complete

TTC_Formatted Xd Yh Zm

Week_Added ISO week number

Year_Added YYYY

Notes Free text

Individual Setup — Personal Task Manager

The tool works offline immediately — no setup needed. Google Sheets sync is optional. Start using it now and connect your sheet later.

Open the task manager

Visit the tool URL in your browser or download taskmanager.html and open it. Bookmark it immediately. On mobile — visit the URL and use Add to Home Screen.

Works on phone and desktop. Data syncs between devices via Google Sheets.

Set your name

Settings tab → enter your name. This stamps your name on every task — important when tasks are combined in a team view.

Create your Google Sheet

Go to sheets.google.com → create a blank sheet → name it My Tasks. This is your task database.

Paste and deploy Code.gs

In your Google Sheet: Extensions → Apps Script. Delete all existing code and paste Code.gs from the Getting Started tab.

Set your API key:

Project Settings (gear icon) → Script Properties → Add property
Name: API_KEY Value: any password e.g. mykey2026

Deploy as web app:

Deploy → New deployment → Web app
Execute as: Me | Access: Anyone
Click Deploy → copy the Web App URL

Save your Web App URL and API key — you need both.

Connect the tool to your sheet

Sync tab in the task manager → paste Web App URL + API key → Save config → Test connection. Green = connected.

You’re ready

Add tasks, use the dashboard, check things off. Push to Sheets to save. Pull from Sheets to restore on any device.

Ctrl+S exports CSV · Enter saves a task · Space toggles complete

Daily Workflow

Add task→ Complete it→ Push to Sheets→ Review dashboard

Team Setup — Manager View

Each team member completes Individual Setup first. The manager then sets up the Master sheet to pull everyone’s tasks into one combined view — filterable by person, area, and status.

Everyone completes Individual Setup

Each team member needs their own HTML tool + Google Sheet + Apps Script. Make sure each person has set their name in Settings.

Create the Master Sheet

Create a new blank Google Sheet — the manager’s sheet, separate from individual sheets. Name it Team Task Manager.

Paste master-aggregator.gs

In the Master Sheet: Extensions → Apps Script. Replace all code with master-aggregator.gs from the Getting Started tab. Edit the team list at the top of the script:

const TEAM_MEMBERS = [
  { name: 'Elijah', sheetId: 'PASTE_SHEET_ID' },
  { name: 'Mike',   sheetId: 'PASTE_SHEET_ID' },
];

Sheet ID = bold part in the URL: docs.google.com/spreadsheets/d/THIS_PART/edit

Authorize and run

Run → pullAllTasks. Google asks to authorize — click Allow (one-time). A ⚙ Team Tasks menu then appears in your sheet.

Your Google account needs view access to each team member’s sheet. Ask each person to share theirs with you.

Use the Team Tasks menu

Pull all tasks now — imports from every sheet
Rebuild dashboard — refreshes per-person metrics
Pull + rebuild — does both at once

Set a time trigger in Apps Script to auto-pull every hour.

Adding a new team member

New person completes Individual Setup
They share their sheet with your Google account
Add their entry to TEAM_MEMBERS in the master script → Save → Run Pull All

Assigning Individual Tasks

This is a different feature from the Master Sheet above. The Master Sheet gives you a read-only combined view of everyone’s tasks. Assign Tasks lets you actively send a task to one person’s sheet.

Open Assign Tasks in the Sync tab

In the HTML tool: Sync tab → Assign Tasks. Add each team member’s name, their Apps Script URL, and their API key — the same three things they used in their own Individual Setup.

Assign a task

When adding or editing a task, set Assign to to a team member’s name. A purple Send button appears on that task card.

Send it

Click Send on the task card, or use Send all assigned tasks to team in Assign Tasks to push every assigned task at once. The task is added directly to their sheet — their existing tasks are never overwritten.

Adding Photos to a Task

Useful for the same reason as Assign Tasks — if you assign someone a task with a photo attached, they see it immediately on their phone the moment the task syncs.

Attach photos when adding a task

In the Add tab, click Add photo to attach up to 3 photos. They’re compressed automatically and show up right on the task card immediately — no sync required to see them yourself.

Photos travel with Push to Sheets

The next time you push, each photo is uploaded into a folder named Task Manager Photos that’s created automatically in your own Google Drive. Only a link is stored in the sheet — never the photo itself — so the sheet stays small.

Photos show up for whoever pulls or merges

If a task with photos is pulled or merged on another device, the photo displays using the Drive link automatically — no re-uploading needed.

Do not attach photos containing confidential information or sensitive documentation. Photos are stored in your Google Drive with “anyone with the link can view” sharing — appropriate for everyday work photos, not for anything sensitive.

Frequently Asked Questions

Mobile browsers (Chrome, Safari, DuckDuckGo) block local HTML files as a security measure — this is normal and not a bug. The solution: visit the tool via its website URL instead of downloading it. Open the URL in Chrome or Safari on your phone → tap the menu → Add to Home Screen. It works exactly like an app.

Your local tasks are permanently wiped. Always push to Google Sheets or export CSV before clearing browser data. If you forgot, pull from Sheets to restore everything — that’s the point of the sync.

Yes — push from one device, pull on the other. Both will have identical tasks. Sync is always a manual push/pull so you stay in control of what gets written to your sheet.

Your tasks pass through Google’s servers only when you push or pull. At rest, data lives in your browser and your own private Google Sheet. No third parties have access. The API key prevents anyone from reading your sheet even if they know your Apps Script URL.

Push: Sends all local tasks to Google Sheets, replacing whatever was there. Use this to save.

Pull: Gets all tasks from Google Sheets and replaces your local data. Use this to restore on a new device.

Merge: Gets tasks from Sheets and adds only new IDs to your local list — your existing local tasks stay untouched.

Desktop: Chrome, Firefox, Edge, or Safari all work perfectly.

Mobile: Chrome or Safari are the best choices. DuckDuckGo and some privacy browsers have JavaScript restrictions that can prevent the tool from running correctly.

Yes — upload taskmanager.html to any web server. No backend, database, or server config required. Works on A2 Hosting, GitHub Pages, Netlify, or any static host. 100% client-side HTML and JavaScript.

Master Sheet: A read-only combined view. You pull everyone’s tasks into one sheet to see them all in one place.

Assign Tasks: An active feature inside the HTML tool. You assign a task to a person and send it directly into their own sheet.

For the Master Sheet: they complete Individual Setup → share their Google Sheet with your email → you add their entry to TEAM_MEMBERS in master-aggregator.gs → Save → run Pull All Tasks.

For Assign Tasks (task assignment): add their name, Apps Script URL, and API key in the Sync tab → Assign Tasks section of the HTML tool.