営業
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.
ボット
新しいボットはありません。初回の手順に従ってください。
プラグイン
初日から入れるものはありません。初回の手順に従ってください。
ルーティン
初回の実行では使いません。まず手動で1回通して確認してください。
プロンプト
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.
初回実行
- 1Read the article at https://x.com/EfficientBots/status/2117416065776972168 (credit @EfficientBots).
- 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.
- 3Connect Google Sheets (Restricted) in Grok Bot; avoid Anyone-with-the-link for real client data.
- 4Paste the sheet link, Shift+Enter, then the author prompt.
- 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 パックには、人気ユースケースのジョブ本文、プロンプト、スケジュール、落とし穴が入っています。