AgentSkillsCN

automated-job-application-sender

当用户需要使用带有个性化占位符的模板，自动发送求职申请邮件，并在跟踪系统中更新申请状态时，此技能会从模板中生成包含{公司名称}、{职位}等占位符的个性化邮件内容，向指定联系人发送邮件，并更新数据库中的状态字段。触发条件包括“发送求职申请邮件”、“申请职位”、“将状态更新为‘已申请’”、“邮件模板”，或在自动化求职申请流程时。

SKILL.md
--- frontmatter
name: automated-job-application-sender
description: When the user needs to automatically send job application emails using templates with personalized placeholders and update application status in tracking systems. This skill generates personalized email content from templates with {Company Name}, {Position} placeholders, sends emails to specified contacts, and updates status fields in databases. Triggers include 'send job application email', 'apply for position', 'update status to Applied', 'email template', or when automating job application workflows.

Automated Job Application Sender

Purpose

Automatically identify qualifying job opportunities from a tracking database, send personalized application emails using templates, and update the application status.

Core Workflow

  1. •Locate Database: Find the specified Notion database (e.g., "Job Tracker").
  2. •Filter Entries: Query for entries with status "Checking".
  3. •Apply Criteria: Filter candidates based on:
    • •Minimum salary > $3000
    • •Work type: On-site
    • •Position: "software engineer" OR "software manager"
    • •Location within 500 km of a reference point (e.g., UCLA)
  4. •Send Email: For each qualifying entry:
    • •Generate email from template using {Company Name} and {Position} placeholders.
    • •Send to the contact email from the database.
    • •Use subject: "Job Application for {Position}"
  5. •Update Status: Change the entry's status from "Checking" to "Applied".

Key Instructions

  • •Salary Parsing: Extract the minimum salary from "Salary Range" fields (e.g., "$4200 - $4800/mo" → 4200). Handle various formats.
  • •Location Filtering: Use geocoding to get coordinates for company locations and the reference point (UCLA). Calculate distances using the Haversine formula (see scripts/calculate_distance.py).
  • •Template: The default email body is: "Hi {Company Name}, I am Janet Mendoza, I want to apply for the {Position} position..."
  • •Error Handling: If geocoding fails for a location, log it and skip that entry. Ensure email sending and status updates are atomic per entry (send email, then update status).

Required Tools

  • •notion-API-post-search: To find the database/page.
  • •notion-API-post-database-query: To fetch entries with status "Checking".
  • •notion-API-patch-page: To update the status to "Applied".
  • •google_map-maps_geocode: To get coordinates for distance calculations.
  • •emails-send_email: To send the application email.
  • •local-claim_done: To signal task completion.

Configuration Notes

  • •The reference location (UCLA) and distance threshold (500 km) are currently hardcoded in the logic. For flexibility, consider making them parameters.
  • •The email template and sender name ("Janet Mendoza") are fixed. For customization, see assets/email_template.txt.