AeroTools
Home AI Prompts Job and Internship Tracker for...

Job and Internship Tracker for Google Sheets

chatgpt career jobs 13 uses
Free
What is this prompt for?

Prepares you for the interview with realistic questions and answers built from your own experience, not from a template.

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

Main use cases:
  • Practising the interview questions that keep coming up
  • Writing a LinkedIn profile worth reading
  • Negotiating an offer with confidence
Benefits and results:
  • A better chance of clearing the first screen
  • A clearer account of your professional strengths
  • More confidence going into the interview
Prompt length: 201 words Reading time: ~2 min Best with: ChatGPT Plus, Claude Pro, Gemini Advanced

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: "john.doe@defensetech.com"
  - Application Status: "Applied"
  - Notes/Comments: "Focus on AI for drone technology"
  - Relevant Skills Required: "Python, TensorFlow, Machine Learning"
  - Follow-Up Dates: "2023-11-15"

Related Prompts

AeroTools

AeroAssistant

Online AI
Hello! I am your official AeroTools AI Assistant. How can I help you use our tools today?