المبيعات
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.
التشغيل الأول
- 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 وصف الوظيفة والنصوص التوجيهية والجداول والمزالق لحالات الاستخدام الشائعة.