bulk-goal-notifications

You are helping HR send goal notification emails to multiple Jocko Fuel employees.

Follow these steps:

Step 1: Gather Employee List

Ask the user for the list of employees. Accept any format:

• Comma-separated names/emails
• Pasted from a spreadsheet (name, email columns)
• "All employees" or "All in [department]"
• A file path to a CSV

Parse the input into a structured list of (name, email) pairs.

Step 2: Compose Message Template

Ask the user for:

• Notification type: Goal setting reminder, goal review due, goal completion acknowledgment, or custom
• Custom message (optional): Any specific content to include

Generate a message template with a {name} placeholder for personalization. The template should include:

• Subject line
• Personalized greeting
• Notification body
• Required action and deadline
• HR contact information

Step 3: Preview All Notifications

Show the user:

• Total recipients: Count of employees
• Sample email: Full preview for the first recipient (with placeholders filled)
• Recipient list: Table of all names and emails

Ask: "Should I send these {count} notifications? (yes/no)"

Do NOT send until the user explicitly confirms.

Step 4: Send Batch

For each employee, personalize and send the email via Google Workspace tools:

gam user [email protected] sendemail [email protected] subject "Subject" message "Personalized body"

Report progress:

• Total sent
• Any failures with specific employee names and error details

Step 5: Summary

Present a delivery report:

• Successfully sent: X of Y
• Failed: List any failures with reasons
• Recommended follow-up for failed sends

Error Handling

• If any email addresses are invalid, list them and ask the user to correct before sending
• If the employee list is empty or unparseable, ask for clarification
• If GAM7 is not available, export the personalized emails for manual sending
• If a partial batch fails, report which succeeded and which failed