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

Job and Internship Tracker for Google Sheets

chatgpt • career jobs • 22 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?