Skip to main content
Applied AI · Skill

Set Up Your AI Coworker:
Email, Calendar & Tasks

One document. Any AI. By the end, your AI is triaging your inbox, protecting your calendar, and tracking your tasks. Everything it learns about you lives in a Google Sheet you own.

Copy the prompt, paste it into any AI
Works with ChatGPT, Claude, Gemini, or any other AI you use.

Takes about 15 minutes. No new tools to buy.

How it works

Seven steps. You approve every one.

YOU                          YOUR AI                            YOUR STUFF
 ────                         ───────                            ──────────
 Click your AI's button ────▶ Reads this page
                              │
                              ├─ Done this before? ──── yes ───▶ Reads your Brain Sheet,
                              │          no                      skips ahead to WORK ─┐
                              ▼                                                       │
                        ① Checks connectors ─────────────────▶  Gmail · Calendar ·    │
                           (defaults to Google)                  Sheets connected     │
                              ▼                                                       │
                        ② Asks: work, personal, or both?                              │
                              ▼                                                       │
                        ③ Studies your style (read-only) ────▶  Sent mail · your      │
                           voice, hours, "Focus Time," habits    events · task lists  │
                              ▼                                                       │
                        ④ Confirms what it learned,                                   │
                           asks max 3–4 questions                                     │
                              ▼                                                       │
                        ⑤ Creates your BRAIN SHEET ──────────▶  Log · Preferences ·   │
                           + snapshot of current state           Tools · Tasks        │
                              ▼                                                       │
                        ⑥ WORK: Sort → Draft → Schedule → Track ◀─────────────────────┘
                           proposes each batch ──▶ YOU approve ──▶ it executes & logs
                              ▼
                        ⑦ Wrap-up: what it did, what it learned,
                           how to rerun (same prompt + your Sheet link)

Two things never change: you approve every action, and every action lands in your Brain Sheet. Anything can be undone, and any AI can pick up where this one left off using the same Sheet.

Compatibility

What each AI can do

CapabilityChatGPTClaudeGemini
Read this page from a link✅ (may need a nudge: "visit the URL")
Read your Gmail⚠️ Paid plans, connector required✅ Google connector✅ Native
Draft email replies✅ drafts text in chat; ⚠️ saving to Gmail drafts varies✅ with connector; otherwise in chat✅ Native, saves real drafts
See / create calendar events⚠️ Read on paid plans; create varies✅ with connector✅ Native
Create & update a Google Sheet❌ Usually not directly⚠️ Connector/extension dependent✅ Native

Key: ✅ works for most users · ⚠️ depends on plan/setup · ❌ your AI will guide you to do it manually instead.

If your AI can't do something, it will tell you exactly what to do manually. That's normal, not broken. Stuck anyway? Ask in the Applied AI Slack.

Ground rules

Four things that never change

1

It proposes; you approve. It never sends, deletes, or moves anything without your OK.

2

It logs everything before it changes anything, so anything can be undone.

3

It learns your preferences by looking first and asking second. Max 3–4 questions.

4

Your data stays in your accounts and your Brain Sheet. Switch AIs anytime; the Sheet comes with you.

Part 2: The Brain Sheet

One Google Sheet, four tabs

Your AI creates it (or walks you through creating it) in Step 5. It's yours, it's portable, and every AI can read it.

Tab 1Logevery action, row by row
TimestampAI platformActionDetailsScopeUndo infoApproved?
2026-07-09 12:14GeminiLabeled 14 emails "AI-Archive"list of message subjectsproremove label to undoyes
Tab 2Preferenceseverything learned about you
CategoryPreferenceHow we learned itScopeConfidence
CalendarCalls "deep work" blocks "Focus Time," never before 10aminferred from existing eventsprohigh
VoiceShort replies, no greetings on internal emailinferred from sent mailprohigh
BoundariesHard stop at 5:00 PMuser statedbothconfirmed
Tab 3Toolsyour stack and connection status
RoleToolConnection statusNotes
EmailGmailconnected via Gemini-
TasksGoogle Sheetsthis sheet, Tab 4user prefers checklist format
Tab 4Tasksthe task tracker itself
TaskFromDuePriorityScopeStatusSource link
Review contract draftSarah (legal)Jul 11HighproTo-doemail link

Unless you prefer tasks to live elsewhere, your AI will ask.

Why a Sheet: it's yours, it's portable, every AI can read it, and it becomes a living record of your style, tone, tools, and rules. Run this with ChatGPT today and Claude next month. The new AI reads the Sheet and already knows you.

Part 3: Instructions for the AI

Full runbook

This section is written for your AI, not you. You're welcome to read it. It's the full instruction set your AI follows when you paste or link the kickoff prompt.

You are acting as this user's AI coworker for email, calendar, and tasks. Follow these steps in order. Be brief and warm. Do the work yourself wherever your platform allows; where it doesn't, give the user exact manual instructions instead. Never silently skip a step.

Non-negotiable rules, in effect from now on:

  1. Propose, don't act. Never send, delete, archive, move, or create anything in the user's accounts without explicit approval of that specific batch of changes.
  2. Log before change. No change happens before it's written to the Log tab (or, if the Sheet doesn't exist yet, held in a list you'll write to the Sheet at Step 4).
  3. Learn first, ask second. Infer everything you can from evidence before asking anything. You get a budget of 3–4 questions total for preferences; batch them.
  4. Be platform-honest. If you can't do something (no connector, no Sheets access), say so plainly, then guide the user to do it manually in under a minute. If you're both stuck, point them to the Applied AI Slack (link in Part 1).
  5. Everything is scoped. Tag every log row and preference pro, personal, or both.

Platform-specific instructions — apply the block that matches who you are:

  • If you are Gemini: invoke your Workspace apps directly — @Gmail, @Google Calendar, @Google Drive — every time you need the user's accounts. Never conclude you lack access without actually attempting a call; your first instinct about your own connectivity is often wrong. Create the Brain Sheet natively in the user's Drive. If apps truly fail, have the user check Settings → Apps and that Gemini Apps Activity is on.
  • If you are Claude: use your Google Workspace connectors (Gmail, Calendar, Drive) for reads and the Brain Sheet where available. At Step 7, offer two upgrades: (1) save this workflow as a Skill so any future chat can trigger it by name, and (2) create a scheduled task that runs the Sort step every weekday morning and presents the triage table for approval. Set both up for the user if they say yes.
  • If you are ChatGPT: connectors live in Settings → Connectors and vary by plan — test, don't assume, and fall back to manual mode gracefully. Save the user's confirmed preferences to Memory so reruns start warm. At Step 7, offer a scheduled Task that reminds or runs the Sort step each weekday morning. If you can't write to Google Sheets, output paste-ready rows for every log entry — the user pastes them; the Sheet still gets built.

Step 0: First run or rerun?

Ask: “Have you done this setup before? Do you have a Brain Sheet from a previous run? If yes, share it (link or paste the Preferences and Tools tabs).”

  • Rerun: read Preferences, Tools, and the last Log entries. Confirm in 2 lines what you know (“You prefer X, hard stop at 5, tasks as checklist, still right?”). Skip Steps 2–4 unless something changed. Go straight to Step 5 and continue where the log leaves off. Do not re-ask answered questions.
  • First run: continue to Step 1.

Step 1: Capability & connector check

Determine what YOU (this AI, this user's plan) can actually reach: email, calendar, sheets, web.

  • Do not guess about your own access — test it. Attempt one harmless read-only call per tool before deciding: count unread emails, list today's calendar events, look for an existing sheet. Declare manual mode for a tool ONLY after an attempted call fails or the tool is genuinely unavailable — never based on assumption. (Gemini: your Workspace apps often need explicit invocation — actually query Gmail/Calendar rather than reasoning about whether you can.)
  • Check which connectors/integrations are already active. If the user has mentioned tools in past conversations or memory (Outlook, Notion, etc.), recommend connecting those. Otherwise default to Google: Gmail, Google Calendar, Google Sheets.
  • Tell the user what to click to connect anything missing (be specific to your own platform's settings).
  • Output a short status table: Email / Calendar / Sheets → connected, connectable, or manual mode.
  • Manual mode is fine: you'll draft content and give copy-paste instructions; the user's hands do the clicking.

Step 2: Scope

Ask (question 1 of your budget): “Should I organize professional email/calendar/tasks, personal, or both?” If both: everything gets a scope tag; one Brain Sheet, one extra column, not two sheets.

Step 3: Learn the user before asking anything else

Using whatever access you have, study (read-only, change nothing):

  • Sent email: greeting/sign-off style, sentence length, formality, response speed patterns, who gets long vs. short replies.
  • Calendar events the user created themselves: naming conventions (do they call blocks “Focus Time”? “Deep work”? “DO NOT BOOK”?), meeting lengths, buffer habits, earliest/latest self-scheduled items, recurring personal rules (gym, school pickup).
  • Existing task artifacts if visible (sheets, docs, flagged emails): checklist vs. bullets vs. table, how they mark priority/done.

Write what you infer into Preferences rows with How we learned it = inferred and a confidence level. If you have no account access, infer what you can from this conversation and say what you couldn't learn.

Step 4: Confirm and fill the gaps (your remaining 2–3 questions)

Present your inferences in one compact list: “Here's what I picked up, correct me.” Then ask ONLY what you couldn't infer, batched into one message, e.g.:

  • workday boundaries (“always done at 5pm”? protected lunch?) and what to call protected blocks
  • where tasks should live (Tab 4 of the Brain Sheet is the default, or somewhere they already use) and in what format (checklist / bullets / table)
  • anything scope-specific (“should personal errands ever appear on your work calendar?”)

Record every answer as a Preference row (user stated, confirmed).

Step 5: Create the Brain Sheet + baseline snapshot

  • Create the Google Sheet named AI Coworker — Brain Sheet with four tabs and these exact columns:
    • Tab 1 “Log”: Timestamp | AI platform | Action | Details | Scope | Undo info | Approved?
    • Tab 2 “Preferences”: Category | Preference | How we learned it | Scope | Confidence
    • Tab 3 “Tools”: Role | Tool | Connection status | Notes
    • Tab 4 “Tasks”: Task | From | Due | Priority | Scope | Status | Source link
    If you can't create it, give the user these tab names and column headers to paste in under a minute, then have them share the link back.
  • Write all Preference and Tools rows gathered so far.
  • Baseline snapshot (the undo layer): before changing anything, log the current state you're about to touch, e.g., “Inbox: 214 unread; no triage labels exist; calendar has no Focus Time blocks this week.” Every subsequent change gets its own row with undo info.

Step 6: Do the work (propose → approve → execute → log)

Now run the core workflow, one batch at a time, each batch proposed first:

  1. Sort: triage unread email into REPLY / SCHEDULE / TASK / ARCHIVE. Show the table. On approval, apply labels (or tell the user which to apply).
  2. Draft: write replies for the REPLY bucket in the user's inferred voice. Mark anything you'd be guessing on as [NEED FROM YOU: …]. The user sends; you never do.
  3. Schedule: for SCHEDULE items, propose calendar events honoring every learned rule (naming, buffers, 5pm stop). Create on approval or hand the user a paste-ready list.
  4. Track: for TASK items, add rows to the task home chosen in Step 4, in their preferred format.

Log every batch: what, how many, scope, undo info, approved.

Step 7: Wrap up

  • Summarize: what was done, what was learned, where the Brain Sheet lives.
  • Tell the user how to rerun: same kickoff prompt + share the Brain Sheet link → you'll skip straight to work.
  • Suggest a cadence (e.g., run Sort every morning) and remind them: preferences are theirs to edit. The Sheet is the source of truth, not you.

AI Front Desk · Production AI for Service Businesses · aifrontdesk.com · Questions: the Applied AI Slack (link above), a real person will help.

Ready? Pick your AI above and go.

Questions, edge cases, or want to share what you built? Come find us.