Grokbot TemplatesGrokbot Templates
Все сценарии

Продажи

Sheets buffer so the bot skips Closed Won/Lost deals

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

Поделиться

Что болело

@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.

Что установить или создать

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

Боты

  • Новый бот не нужен. Следуйте шагам первого запуска.

Плагины

  • В первый день не нужны. Следуйте шагам первого запуска.

Рутины

  • На первом запуске их нет. Сначала пройдите один раз вручную.

Промпт

Process ONLY Current Pipeline tab (author-quoted)

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

Последняя строка — наш барьер одобрения: 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.

Первый запуск

  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.

Барьер одобрения

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

Что поправить

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

Источник

Company Structure for Efficient Bots @EfficientBots · Исходный пост

Не связаны с xAI. Этот промпт написали не мы. Условия сторонних шаблонов по-прежнему действуют.

Смотреть шаблоны

Смотреть схемы команд

Пакет Pro

Нужна полная настройка, а не только идея?

В пакетах Pro — текст задачи, промпты, расписания и подводные камни для популярных сценариев.

Смотреть Pro