Grokbot TemplatesGrokbot Templates
All use cases

Sales

Sheets buffer so the bot skips Closed Won/Lost deals

Sharing the whole sales tracker burns tokens on deals that are already closed.

Share

What hurt

@EfficientBots X Article: keep a Google Sheets buffer tab Current Pipeline that FILTERs out Closed Won and Closed Lost, plus a Data Spec tab and a prompt that tells Grok Bot to process ONLY that tab. Fixed formula starts at row 2 so headers/blanks don't leak in. Prefer Sheets connector over "Anyone with the link". Author-quoted prompt + formula. Not affiliated with xAI.

What to install or create

Data Spec → FILTER buffer tab → connect sheet safely → prompt ONLY Current Pipeline.

Bots

  • No new bot. Follow the first-run steps.

Plugins

  • None on day one. Follow the first-run steps.

Routines

  • None on the first run. Watch one manual pass first.

The prompt

Process ONLY Current Pipeline tab (author-quoted)

Quoted from @EfficientBots — as published. Do not invent a second system prompt.

Last line is our approval fence: Never send, post, spend, or buy without my explicit yes.

Here is the live connection link for my sales pipeline sheet. Your task is to process ONLY the rows dynamically filtered within the 'Current Pipeline' tab. Do not spend processing energy evaluating historical archives or finalized accounts. Audit the live Deal Names, active Stages, total Deal Values, and Expected Close Dates. Return a crisp, bulleted revenue performance summary mapping out our highest-value active targets, an analysis of deal congestion points across pipeline stages, and a calculated risk brief identifying accounts with approaching close dates that require immediate follow-up.

Never send, post, spend, or buy without my explicit yes.

First run

  1. 1Read the article at https://x.com/EfficientBots/status/2117416065776972168 (credit @EfficientBots).
  2. 2Add Data Spec + Current Pipeline tabs; paste headers in A1:E1, then in A2: =FILTER('Master Sales'!A2:E, 'Master Sales'!A2:A <> "", ('Master Sales'!D2:D <> "Closed Won") * ('Master Sales'!D2:D <> "Closed Lost")) — rename Master Sales to your tab.
  3. 3Connect Google Sheets (Restricted) in Grok Bot; avoid Anyone-with-the-link for real client data.
  4. 4Paste the sheet link, Shift+Enter, then the author prompt.
  5. 5Optional: save the same prompt as a weekly routine so the bot re-reads the live buffer on a schedule.

Approval fence

Prefer Restricted + Sheets connector; never grant edit or publish without your yes. Prompt is process-ONLY — not a lock.

What to tweak

Steal the buffer tab; the bot should never re-read closed deals.

Source

Company Structure for Efficient Bots @EfficientBots · Original post

Not affiliated with xAI. We did not write this prompt. Third-party template terms still apply.

Browse templates

Browse team blueprints

Pro pack

Want the full setup, not just the idea?

Pro packs give you the job text, prompts, schedules and pitfalls for popular use-cases.

See Pro