用 Grok Bot 搭建安全邮件群发助手：Campaign Sender

输入 Excel/CSV 收件人列表 + 邮件模板 → Grok Bot 逐条发送 Gmail 并生成退信报告

给谁

需要向客户或候选人发送批量邮件、但担心 BCC 损害发件人信誉的运营者

你会得到

在 Grok Bot 中创建 Campaign Sender Skill，上传列表后逐条发送真实 Gmail，自动追踪进度、检测退信并输出英文日报

你需要

Gmail

步骤

1. 创建专用 Bot

   打开 Grok Bot，点击 New → Create new Bot，命名为 Campaign Sender。建议保持单一用途，避免与其他任务混用同一个 Bot。

2. 连接 Gmail

   进入 Connect apps，选择 Gmail 并完成授权，绑定你打算用来发件的邮箱地址。来源指出这是该 Bot 唯一需要的权限。

3. 安装 Campaign Sender Skill

   在 Bot 对话中粘贴以下 Skill 指令。粘贴后 Bot 会确认已保存，之后可通过 /Campaign Sender 调用。

   运行提示词 · 来源原文。Grok Bot 的 Skill/指令输入框；保存后通过 /Campaign Sender 调用

   复制提示词

   Save this as a skill called “Campaign Sender”.
   
   When to use: User provides an Excel (.xlsx/.xls) or CSV/TSV recipient list + final subject and body template for sending individual Gmail messages.
   
   Required access: Connected Gmail app. User must upload or provide the spreadsheet. Never store credentials, full recipient data, or campaign content permanently.
   
   Workflow:
   1. Inspect the file. Identify the email column. Report: total rows, blank addresses, obvious syntax failures, and case-insensitive duplicates. Do not do SMTP verification unless asked.
   2. Confirm the connected Gmail sender address.
   3. Render the template as HTML. Preserve links, paragraphs, bold, lists, signatures, and attachments. Replace placeholders only from matching spreadsheet columns.
   4. Create one unaddressed Gmail draft for review. Show sender, subject, recipient count, and any unresolved placeholders.
   5. Get explicit confirmation of the final template AND exact recipient scope before any sending. A vague “send it” is not enough.
   6. Optionally send a test to the authenticated account if requested.
   7. Send one separate Gmail message per row (never BCC/CC the whole list). Reuse the same in-memory subject and MIME payload. Request only message ID and labels.
   8. Maintain an append-only progress record: row number, email, status, Gmail message ID, timestamp, error. Resume by skipping successful rows. Never auto-retry uncertain results.
   9. Stop on quota, auth, policy, or repeated transient errors. Report successful / failed / skipped / uncertain / remaining counts.
   10. After the run finishes or stops, search Gmail only for bounce notices tied to this run’s recipients and campaign subject. Do not mix other campaigns.
   11. Classify bounces and produce the English daily report below.
   
   Automatic daily report (always generate, copy-ready English):
   - Report date
   - Planned / attempted / successfully sent / failed / uncertain / duplicate / skipped counts
   - Completion time in user’s timezone
   - Total bounces and messages with no bounce detected so far
   - Current bounce and non-bounce rates
   - Bounce reasons: address not found / unable to receive, disabled mailbox, mailbox full, temporary delay, spam or policy rejection, other
   - Bounced domains with counts and percentages
   
   Rules:
   - Use Gmail acceptance only for the “sent” count. Do not claim “delivered” unless Gmail provides clear evidence.
   - Keep the report factual and concise. Do not add recommendations, retry advice, or list-cleaning instructions.
   - Preserve spreadsheet order.
   - Skip blank, malformed, duplicate, previously successful, or explicitly excluded addresses and log the reason.
   - Never send until the user explicitly confirms the final template and recipient scope.
   - Respect Gmail/Google Workspace limits. Do not promise fixed daily capacity.
   - Token-efficient: parse spreadsheet once, reuse payload, emit progress every 25–100 messages with counts only, search bounces once at the end.
   
   After saving, confirm the skill is available and list the exact confirmation phrase you will require before any send.

4. 准备收件人列表

   上传一份 Excel 或 CSV 文件，确保包含 email 列。如需个性化，可添加 FirstName、Company 等列，在邮件模板中以 {{FirstName}} 形式引用。

5. 运行群发任务

   上传文件并粘贴邮件主题与正文模板，然后发送运行指令。Bot 会清理列表、展示预览草稿，并等待你的明确确认。只有在收到类似「Confirm send to these 287 recipients with this template」的确认后，才会开始逐条发送。

   运行提示词 · 来源原文。Grok Bot 对话输入框，上传文件并附带主题与正文后发送

   复制提示词

   Run Campaign Sender on this list.

6. 查看日报

   发送完成后，Bot 会生成一份可直接复制的英文日报，包含已发送/失败/跳过数量、退信率、退信原因及退信域名分布。来源强调报告只列数字，不含额外建议。

7. 可选：设置定时任务

   如需定期执行，可向 Bot 发送以下指令，指定 Drive 文件与运行时间。Bot 仍会在发送前等待人工批准。

   运行提示词 · 来源原文。Grok Bot 对话输入框，用于设置周期性任务

   复制提示词

   Every Monday at 9am, run Campaign Sender on this Drive file. Always stop for my approval before sending.

无提示词，按步骤操作即可。