Skip to main content
Prompts AI/ML Job Tracker Google Sheets Template

student hr template risk: low

AI/ML Job Tracker Google Sheets Template

Instructs the model to act as a Career Management Assistant and design a Google Sheets template for tracking job and internship applications with specified columns, conditional for…

PROMPT 

Act as a Career Management Assistant. You are tasked with creating a Google Sheets template specifically for tracking job and internship applications.

Your task is to:
- Design a spreadsheet layout that includes columns for:
  - Company Name
  - Position
  - Location
  - Application Date
  - Contact Information
  - Application Status (e.g., Applied, Interviewing, Offer, Rejected)
  - Notes/Comments
  - Relevant Skills Required
  - Follow-Up Dates

- Customize the template to include features useful for a computer engineering major with a minor in Chinese and robotics, focusing on AI/ML and computer vision roles in defense and futuristic warfare applications.

Rules:
- Ensure the sheet is easy to navigate and update.
- Include conditional formatting to highlight important dates or statuses.
- Provide a section to track networking contacts and follow-up actions.

Use variables for customization:
- ${graduationDate:December 2026}
- ${major:Computer Engineering}
- ${interests:AI/ML, Computer Vision, Defense}

Example:
- Include a sample row with the following data:
  - Company Name: "Defense Tech Inc."
  - Position: "AI Research Intern"
  - Location: "Remote"
  - Application Date: "2023-11-01"
  - Contact Information: "[email protected]"
  - Application Status: "Applied"
  - Notes/Comments: "Focus on AI for drone technology"
  - Relevant Skills Required: "Python, TensorFlow, Machine Learning"
  - Follow-Up Dates: "2023-11-15"

INPUTS

graduationDate REQUIRED

User's expected graduation date

e.g. December 2026

major REQUIRED

User's major

e.g. Computer Engineering

interests REQUIRED

User's interests in AI/ML, Computer Vision, Defense

e.g. AI/ML, Computer Vision, Defense

ROLES & RULES

Role assignments

  • Act as a Career Management Assistant.
  1. Ensure the sheet is easy to navigate and update.
  2. Include conditional formatting to highlight important dates or statuses.
  3. Provide a section to track networking contacts and follow-up actions.

EXPECTED OUTPUT

Format
markdown
Constraints
  • include specified columns
  • include conditional formatting
  • include networking section
  • include sample row
  • use variables for customization

SUCCESS CRITERIA

  • Design spreadsheet layout with specified columns
  • Customize template for computer engineering major focusing on AI/ML and computer vision in defense
  • Include conditional formatting
  • Provide networking contacts section
  • Use provided variables
  • Include sample row

FAILURE MODES

  • Omitting required columns
  • Failing to customize for specific major and interests
  • Neglecting conditional formatting
  • Missing networking section
  • Not using variables properly

EXAMPLES

Includes one sample row with data for a job application at Defense Tech Inc.

CAVEATS

Missing context
  • Exact conditional formatting rules (e.g., colors, conditions).
  • Method to deliver or access the actual Google Sheets template (e.g., public link, importable CSV).
Ambiguities
  • Does not specify the output format for the template (e.g., textual description, JSON schema, shareable link).
  • Unclear how to implement 'Provide a section to track networking contacts and follow-up actions' – new sheet, additional columns, etc.?
  • Vague on 'features useful for a computer engineering major...' – what specific customizations beyond listed columns?

QUALITY

OVERALL
0.85
CLARITY
0.90
SPECIFICITY
0.90
REUSABILITY
0.80
COMPLETENESS
0.80

IMPROVEMENT SUGGESTIONS

  • Specify output format: 'Respond with a step-by-step guide to recreate the sheet in Google Sheets, including formulas, data validation, and shareable template link if possible.'
  • Clarify networking section: 'Add a separate sheet named "Networking" with columns for Contact Name, Company, Interaction Date, Follow-Up Date, Notes.'
  • Expand customization: 'Incorporate ${major}, ${interests} into headers or a dashboard summary sheet showing targeted roles.'

USAGE

Copy the prompt above and paste it into your AI of choice — Claude, ChatGPT, Gemini, or anywhere else you're working. Replace any placeholder sections with your own context, then ask for the output.

MORE FOR STUDENT