What remote ops covers
Remote ops is the operational layer under a distributed team. It is not the product work itself. It is the status updates, reminders, handoffs and small decisions that let people in different places and hours keep moving without waiting for each other.
Big companies give this to an operations team or a program manager with dedicated software. At a company of five or fifty it usually lands on a founder, an office manager or whoever set up the project tracker, and the tools are the ones already paid for: a Google Sheet, Slack, Notion and a shared calendar.
When it works nobody notices. When it does not, people ask "where are we on this?" in three channels, a reminder goes out twice, a handoff is missed by an hour because of a clock change, and a decision sits open for a week because nobody said when it closes.
Where it usually goes wrong
- Status lives in chat
- Updates are scattered across threads, so the only way to get the full picture is a meeting. A weekly digest built from the tracker replaces the round of "any updates?" messages.
- Blocked work hides in a long list
- A tracker with 200 rows does not show the five that are stuck. A filtered view, or a daily post of just the blocked items, puts them in front of the people who can unblock them.
- Reminders repeat or never arrive
- Simple scripts send the same reminder every time they run. The fix is to record what was sent, which takes a few lines of code and is easy to leave out.
- Times are converted by hand
- Someone adds or subtracts hours in their head, and twice a year daylight saving makes the answer wrong. Storing times in UTC and converting per person fixes it once.
- Decisions have no deadline
- An async decision without a closing date becomes a meeting. A log with an explicit "respond by" date tells everyone when the decision closes.
How these guides help
Each guide solves one of these problems inside software you already use, with a formula or a short script rather than a new subscription. You get the answer at the top, a small sample table to try it on, the code to copy, and a list of what it needs: which sheet tabs, which columns, which permissions Google will ask for.
Every guide ends with a check note that says how it was verified. Formulas and templates are checked against their sample data. Scripts are syntax-checked and reviewed against the published API documentation; none of the scripts in this topic has been run in a live account yet, and each note says so, so try them on a copy first.
The 11 guides
Status without the status meeting
Turn the tracker your team already updates into something people read: a weekly digest, a Notion report page, or a short daily list of what is blocked.
- Turn Google Sheets Status Updates into an Async Weekly DigestUse Apps Script to group dated Google Sheets updates by project and create a Google Docs digest for a reporting window you choose.Google Sheets, script, added
- Automate a Weekly Report Page in Notion for Remote TeamsCreate a dated Notion report from this week's Google Sheets updates with Apps Script, stored credentials, and a weekly publication marker.Notion, script, added
- Show Only Blocked Tasks in a Google Sheets Project TrackerList unfinished tasks with blockers in a separate Google Sheets output area while keeping the original project tracker visible.Google Sheets, formula, added
- Post a Daily Blocked-Tasks Summary from Google Sheets to SlackUse Apps Script to find unfinished tasks with blockers in Google Sheets, post one daily Slack message, and skip the report when no tasks qualify.Slack, script, added
- Show Project Progress from Related Tasks in Notion with a RollupLink a Notion Projects database to Tasks with a two-way relation, then show each project's percent of Done tasks and keep the counts for honest totals.Notion, template, added
Reminders and deadlines
Get due dates out of the tracker and in front of people, once, where they will see them, and ask for the weekly update without chasing anyone.
- Send One Daily Task Reminder from Google Sheets Without Repeat EmailsEmail tomorrow's unfinished Google Sheets tasks in one daily digest, then save a recipient-and-date marker to limit repeat reminders.Google Sheets, script, added
- Sync Google Sheets Task Deadlines to a Google CalendarSync Sheets deadlines to Google Calendar with Apps Script, save event IDs to prevent duplicates, and schedule one-way updates with a time-driven trigger.Google Sheets, script, added
- Calculate Days Until Due and Flag Overdue Tasks in NotionA Notion formula property that turns a Due date into Overdue, Due today, or Due in N days, and stays blank when there is no date or the task is Done.Notion, formula, added
- Set Up a Recurring Weekly Check-In Reminder in SlackUse the Slack /remind command to post a weekly async check-in prompt in a channel, with a reply template and the reminder phrasings that repeat correctly.Slack, template, updated
Time zones and decisions
Handoff times that are right for everyone, and a written way to decide things without getting everyone online.
- Convert UTC Handoff Times to Local Time in Google SheetsUse a custom function in Google Sheets to display UTC handoff timestamps in named local time zones, with daylight saving applied.Google Sheets, script, added
- Set Up an Async Decision Log with an Explicit Response DeadlineBuild a Google Sheets decision log with named owners, review cutoffs, objection tracking, and manual rules for closing each decision.Google Sheets, template, added
Questions
Do I need to know how to code?
Not for the formula guides: you paste a formula into a cell. The script guides use Google Apps Script, which opens from Extensions > Apps Script in any Google Sheet. You paste the code, set the values the guide lists, and approve the permissions Google asks for. Reading the code before you run it is a good habit, and the scripts are kept short enough to do that.
Why build this in a spreadsheet instead of a project management app?
Many small teams already track work in a sheet, and a few formulas or a short script can take it a long way before another per-seat subscription is worth it. If you do move later, a tracker with one row per task and clear owner, status and due date columns imports into most project tools.
Will a script send messages as me?
The reminder guide sends email and the Slack guide posts to a channel. The digest guide only creates a Google Doc, the calendar guide writes events to a calendar you choose, and the Notion guide creates a page. Scripts run under the Google account that installs them, and the scheduled ones stop when you delete their trigger. Each guide lists the permissions involved before you start.