Tommy, here's a free tracker you can set up in about 10 minutes with a Google Sheet. You and your BOTG both work in the same sheet. When you assign a task, they get an email. When they mark it Done, you get an email. Anything overdue gets a reminder every morning. STEP 1: Open a new Google Sheet and rename the bottom tab to: Tasks STEP 2: Type these headers in row 1, one per column (A to H): Task | Property | Due Date | Notes | Assigned To | Status | Created | Completed STEP 3: Select the Status column, go to Data > Data validation, and make a dropdown with: Open, In Progress, Done STEP 4: Share the sheet with your BOTG as an Editor. STEP 5: Go to Extensions > Apps Script. Delete everything there, paste in the script below, change the first line to your email, and click Save. STEP 6: In the dropdown at the top, pick "setup", click Run, and approve the permissions. You only do this once. HOW TO USE IT: Fill in a row left to right and put your BOTG's email in "Assigned To" last. That sends them the task. When they set Status to Done, you get an email. ----- COPY EVERYTHING BELOW THIS LINE ----- var OWNER = '
[email protected]'; var SHEET = 'Tasks'; function fmt(d) { return d ? Utilities.formatDate(new Date(d), Session.getScriptTimeZone(), 'MMM d, yyyy') : 'no date'; } function onTaskEdit(e) { var sh = e.range.getSheet(); if (sh.getName() !== SHEET || e.range.getRow() < 2) return; var row = e.range.getRow(); var v = sh.getRange(row, 1, 1, 8).getValues()[0]; var task = v[0], prop = v[1], due = v[2], notes = v[3], who = v[4], status = v[5], created = v[6], done = v[7]; var link = SpreadsheetApp.getActive().getUrl(); if (task && who && !created) { sh.getRange(row, 7).setValue(new Date()); if (!status) sh.getRange(row, 6).setValue('Open'); MailApp.sendEmail(who, 'New task: ' + task, 'Property: ' + prop + '\nDue: ' + fmt(due) + '\nNotes: ' + notes + '\n\nMark it Done here when finished:\n' + link);