A week of replies drafted, none sent.
whyForty threads wait, and most need two lines.
asksDraft replies to this week's customer threads. I send them.
One script, deployed from your own Google account as a web app. It sees what you see, nothing more.
team/tools/google-apps-script/google-apps-script.md ids and key namesMail, sheets and calendar, for people with no time for them.
whyForty threads wait, and most need two lines.
asksDraft replies to this week's customer threads. I send them.
whyMonthly numbers are copied in by hand.
asksAdd October's revenue to the Revenue row of the board sheet.
whyAn old supplier's notices bury the inbox.
asksTrash every mail from the old supplier.
Each action is one function, named for its service. Gmail, Sheets, Docs and Drive each have a page of their own.
Inbox, Gmail search, threads, SPF and DKIM verdicts, attachments to Drive.
A draft leaves only after you say send.
Ranges found by label, dates as real dates, layout read first.
Insert after an anchor, fill one field, place an image.
Search, sharing, folder copies, OCR, and conversions to native files.
The coming days' events; a new one with guests, a place and a description.
The script is yours, deployed by you, with a key you made.
Deployed at script.google.com, as a web app that runs as you. Paste the new script, then make a new version of your existing deployment. The URL and the key stay.
A page names the deployment id and the key's name, never its value.
The deployment runs in your account. Our server stores its id and key name.
Read from the secret store inside the call.
It drafts, then waits until you say send.
A doubtful response gets a read-back, never a second write.
It decides whether the script answers at all.
| Limit | What it means |
|---|---|
| An admin can forbid "Anyone" access | Then use a personal account, or Claude's Google connectors in Claude Code started in another folder. |
Deploy once and name the key. Claude Code and Codex then work your mail and sheets as you.
Search, threads, drafts and cleanup, a send only on your go, through your own script.
documents and filesGoogle SheetsFormats, formulas, tabs and real dates, through your own script.
documents and filesGoogle DocsDocs edited in place, the writer's text untouched, through your own script.
documents and filesGoogle DriveFiles, sharing and shared drives, through the folder and your own script.
documents and filesNotionPages and databases you can open, under your own token.
every kindWorks withEvery system by kind, and the rule each page shares.