// ================================================================
// TASK MANAGER — Google Apps Script Bridge v1.0
// Built by Elijah Fennell — elijahlfennell.com
// ================================================================
// 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 HTML tool settings
// ================================================================

const SHEET_NAME = ‘Tasks’;

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’
];

// Maps internal task object 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’
};

// 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? }
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’});
    }
    return out({success:false, error:’Unknown action: ‘ + action});
  } catch(err) {
    return out({success:false, error:err.toString()});
  }
}

// ── Read tasks from 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 tasks to sheet ──────────────────────────────────────────
function writeTasks(tasks) {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  let sheet = ss.getSheetByName(SHEET_NAME);
  if (!sheet) sheet = ss.insertSheet(SHEET_NAME);
  sheet.clearContents();

// Header row
  sheet.getRange(1, 1, 1, HEADERS.length).setValues([HEADERS]);

if (!tasks.length) return 0;

// Data rows
  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);

// Formatting
  const hdr = sheet.getRange(1, 1, 1, HEADERS.length);
  hdr.setBackground(‘#185FA5’);
  hdr.setFontColor(‘#FFFFFF’);
  hdr.setFontWeight(‘bold’);
  hdr.setFontSize(9);
  hdr.setFontFamily(‘Arial’);
  sheet.setFrozenRows(1);

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

// Status conditional formatting
  const rules = sheet.getConditionalFormatRules();
  const statusRange = sheet.getRange(‘I2:I’ + (rows.length + 1));
  const doneRule = SpreadsheetApp.newConditionalFormatRule()
    .whenTextEqualTo(‘Done’).setBackground(‘#E1F5EE’).setFontColor(‘#1D9E75’).setRanges([statusRange]).build();
  const blockedRule = SpreadsheetApp.newConditionalFormatRule()
    .whenTextEqualTo(‘Blocked’).setBackground(‘#EEEDFE’).setFontColor(‘#7F77DD’).setRanges([statusRange]).build();
  sheet.setConditionalFormatRules([doneRule, blockedRule]);

return tasks.length;
}

// ── Helpers ───────────────────────────────────────────────────────
function calcTTC(added, completed) {
  if (!added || !completed) return {hours:”, formatted:”};
  try {
    const ms = new Date(completed) – new Date(added);
    if (ms < 0) return {hours:”, formatted:”};
    const hours = parseFloat((ms/3600000).toFixed(2));
    const d = Math.floor(hours/24);
    const h = Math.floor(hours%24);
    const m = Math.floor((ms%3600000)/60000);
    return {hours, formatted: d+’d ‘+String(h).padStart(2,’0’)+’h ‘+String(m).padStart(2,’0′)+’m’};
  } catch(e) { return {hours:”, formatted:”}; }
}

// ================================================================
// TASK MANAGER — Master Team Aggregator v1.0
// Built by Elijah Fennell — elijahlfennell.com
// ================================================================
// PURPOSE:
//   Pulls tasks from multiple individual team member sheets into
//   one combined view. Run this from your MASTER sheet.
//
// SETUP:
//   1. Create a new Google Sheet (this is your Master sheet)
//   2. Go to Extensions → Apps Script
//   3. Paste this entire file, replacing all existing code
//   4. Edit TEAM_MEMBERS below — add each person’s Sheet ID
//      (Sheet ID is in the URL: docs.google.com/spreadsheets/d/SHEET_ID/copy)
//   5. Save the script
//   6. Run once manually to authorize permissions
//   7. 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 team members as needed:
  // { name: ‘Name’, sheetId: ‘SHEET_ID’ },
];
// ─────────────────────────────────────────────────────────────────

const TASKS_SHEET   = ‘Tasks’;       // Sheet name in individual files
const MASTER_SHEET  = ‘All Tasks’;   // Combined tab in this master file
const DASH_SHEET    = ‘Team Dashboard’;

// All columns from individual sheets + User column
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’
];

// ── 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 ────────────────────────────────────────────────
function pullAllTasks() {
  const ss   = SpreadsheetApp.getActiveSpreadsheet();
  let master = ss.getSheetByName(MASTER_SHEET);
  if (!master) master = ss.insertSheet(MASTER_SHEET);
  master.clearContents();

// Header row
  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; // skip empty rows

// Build a map of this row
        const rowMap = {};
        headers.forEach((h, j) => { rowMap[h] = row[j] !== null ? row[j].toString() : ”; });

// Resolve user: prefer sheet’s User column, fall back to member name
        const user = rowMap[‘User’] || member.name;

// Build output row in ALL_COLS order
        const outRow = ALL_COLS.map(col => {
          if (col === ‘User’) return user;
          return rowMap[col] !== undefined ? rowMap[col] : ”;
        });

allRows.push(outRow);
      }

Logger.log(`${member.name}: ${allRows.length} tasks imported`);
    } catch (err) {
      const msg = `Could not read ${member.name}’s sheet: ${err.toString()}`;
      Logger.log(msg);
      errors.push(msg);
    }
  });

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

// Format header
  formatHeader(master, ALL_COLS.length);
  master.setFrozenRows(1);

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

// Conditional formatting by status
  applyStatusFormatting(master, allRows.length + 1);

// Summary
  const summary = `✓ Pulled ${allRows.length} tasks from ${TEAM_MEMBERS.length} team members.` +
    (errors.length ? `\n\n⚠ Errors:\n${errors.join(‘\n’)}` : ”);
  SpreadsheetApp.getUi().alert(summary);
}

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

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

// Summary metrics header
  const metricsRow = 4;
  const metricLabels = [‘Member’, ‘Total’, ‘Open’, ‘Done’, ‘Blocked’, ‘Overdue’, ‘Completion %’];
  dash.getRange(metricsRow, 1, 1, metricLabels.length).setValues([metricLabels]);
  formatHeader(dash, metricLabels.length, metricsRow);

// Per-member formulas — one row per team member
  TEAM_MEMBERS.forEach((m, i) => {
    const r = metricsRow + 1 + i;
    const name = m.name;
    // Reference the All Tasks sheet for live formulas
    const uRef = `’${MASTER_SHEET}’!A:A`;
    const stRef = `’${MASTER_SHEET}’!J:J`;
    const duRef = `’${MASTER_SHEET}’!N:N`;

dash.getRange(r, 1).setValue(name).setFontWeight(‘bold’);
    dash.getRange(r, 2).setFormula(`=COUNTIF(${uRef},”${name}”)`);
    dash.getRange(r, 3).setFormula(`=COUNTIFS(${uRef},”${name}”,${stRef},”<>Done”,${stRef},”<>Archived”)`);
    dash.getRange(r, 4).setFormula(`=COUNTIFS(${uRef},”${name}”,${stRef},”Done”)`);
    dash.getRange(r, 5).setFormula(`=COUNTIFS(${uRef},”${name}”,${stRef},”Blocked”)`);
    dash.getRange(r, 6).setFormula(
      `=COUNTIFS(${uRef},”${name}”,${stRef},”<>Done”,${stRef},”<>Archived”,${duRef},”<“&TEXT(TODAY(),”YYYY-MM-DD”),${duRef},”<>”&””)`);
    dash.getRange(r, 7).setFormula(`=IFERROR(D${r}/B${r},”—”)`);
    dash.getRange(r, 7).setNumberFormat(‘0%’);

// Alternate row shading
    const bg = i % 2 === 0 ? ‘#E6F1FB’ : ‘#FFFFFF’;
    dash.getRange(r, 1, 1, metricLabels.length).setBackground(bg);
  });

// Totals row
  const totRow = metricsRow + 1 + TEAM_MEMBERS.length;
  const firstData = metricsRow + 1;
  const lastData  = totRow – 1;
  dash.getRange(totRow, 1).setValue(‘TOTAL’).setFontWeight(‘bold’);
  for (let c = 2; c <= 6; c++) {
    const colLtr = String.fromCharCode(64 + c);
    dash.getRange(totRow, c).setFormula(`=SUM(${colLtr}${firstData}:${colLtr}${lastData})`).setFontWeight(‘bold’);
  }
  dash.getRange(totRow, 7).setFormula(`=IFERROR(D${totRow}/B${totRow},”—”)`).setNumberFormat(‘0%’).setFontWeight(‘bold’);
  dash.getRange(totRow, 1, 1, metricLabels.length).setBackground(‘#D6E8F7’);

// Column widths
  [18,10,10,10,10,10,14].forEach((w,i) => dash.setColumnWidth(i+1, w*7));

// Aging section
  const agRow = totRow + 3;
  dash.getRange(agRow, 1).setValue(‘Aging Buckets (All Team — Open Tasks)’).setFontWeight(‘bold’).setFontColor(‘#185FA5’);
  const agHdrs = [‘Bucket’, ‘Count’];
  dash.getRange(agRow+1, 1, 1, 2).setValues([agHdrs]);
  formatHeader(dash, 2, agRow+1);
  const stAll = `’${MASTER_SHEET}’!J:J`;
  const dtAll = `’${MASTER_SHEET}’!O:O`;
  const agBuckets = [
    [‘Fresh 0–3 days’,   `=COUNTIFS(${stAll},”<>Done”,${stAll},”<>Archived”,${dtAll},”<>”&””,${dtAll},”>=”&TEXT(TODAY()-3,”YYYY-MM-DD”))`],
    [‘Recent 4–14 days’, `=COUNTIFS(${stAll},”<>Done”,${stAll},”<>Archived”,${dtAll},”<>”&””,${dtAll},”>=”&TEXT(TODAY()-14,”YYYY-MM-DD”),${dtAll},”<“&TEXT(TODAY()-3,”YYYY-MM-DD”))`],
    [‘Aging 15–60 days’, `=COUNTIFS(${stAll},”<>Done”,${stAll},”<>Archived”,${dtAll},”<>”&””,${dtAll},”>=”&TEXT(TODAY()-60,”YYYY-MM-DD”),${dtAll},”<“&TEXT(TODAY()-14,”YYYY-MM-DD”))`],
    [‘Old 60+ days’,     `=COUNTIFS(${stAll},”<>Done”,${stAll},”<>Archived”,${dtAll},”<>”&””,${dtAll},”<“&TEXT(TODAY()-60,”YYYY-MM-DD”))`],
  ];
  agBuckets.forEach(([lbl, form], i) => {
    const r = agRow + 2 + i;
    dash.getRange(r, 1).setValue(lbl).setFontSize(9);
    dash.getRange(r, 2).setFormula(form).setFontSize(9).setFontWeight(‘bold’)
      .setFontColor(i >= 2 ? ‘#B91C1C’ : ‘#D97706’);
    dash.getRange(r, 1, 1, 2).setBackground(i % 2 === 0 ? ‘#F7F8FA’ : ‘#FFFFFF’);
  });

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

// ── HELPERS ───────────────────────────────────────────────────────
function formatHeader(sheet, cols, row=1) {
  const r = sheet.getRange(row, 1, 1, cols);
  r.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);
  const rules = [
    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(),
  ];
  sheet.setConditionalFormatRules(rules);
}

Free Tool

Task Manager Tool — Setup Guide

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

Open Tools / 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 What’s included 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 What’s included 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

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.

New person completes Individual Setup → shares their Google Sheet with the manager’s email → manager adds their entry to TEAM_MEMBERS in master-aggregator.gs → Save → run Pull All Tasks from the menu.

Task Management Tool