Ventas
Sheets buffer so the bot skips Closed Won/Lost deals
Sharing the whole sales tracker burns tokens on deals that are already closed.
Qué dolía
@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.
Qué instalar o crear
Data Spec → FILTER buffer tab → connect sheet safely → prompt ONLY Current Pipeline.
Bots
Ningún bot nuevo. Sigue los pasos del primer uso.
Plugins
Ninguno el primer día. Sigue los pasos del primer uso.
Rutinas
Ninguna en el primer uso. Mira primero una pasada manual.
El prompt
Process ONLY Current Pipeline tab (author-quoted)
Quoted from @EfficientBots — as published. Do not invent a second system prompt.
La última línea es nuestra valla de aprobación: 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.
Primer uso
- 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.
Valla de aprobación
Prefer Restricted + Sheets connector; never grant edit or publish without your yes. Prompt is process-ONLY — not a lock.
Qué ajustar
Steal the buffer tab; the bot should never re-read closed deals.
Fuente
Company Structure for Efficient Bots @EfficientBots · Publicación original
Sin afiliación con xAI. No escribimos este prompt. Siguen aplicando las condiciones de las plantillas de terceros.
Paquete Pro
¿Quieres la configuración completa, no solo la idea?
Los paquetes Pro te dan el texto de la tarea, los prompts, los horarios y los tropiezos de los casos de uso más populares.