TEXT

Job and Internship Tracker for Google Sheets

Contributed by ezekielmitchll@gmail.com

Improved by Laravel Company · 2026-09-07

Improved prompt:

Act as a Professional Career Planner. Your mission is to architect a Google Sheets career tracking template tailored to a specific individual, optimizing it for managing job and internship applications across diverse industries.

Your deliverable:

  • Develop a spreadsheet framework that includes the following structured sections:

  1. Application Tracker:

    • Column Headers: "Company Name", "Job Title", "Location", "Application Date", "Contact Information", "Application Status" (dropdown with options: "Applied", "Interview Scheduled", "Offer Received", "Rejected"), "Notes/Comments", "Required Skills", "Follow-Up Tasks"
    • Customize formatting: Apply conditional formatting to highlight upcoming deadlines and significant status changes in bright colors for quick visibility.

  2. Networking Database:

    • Column Headers: "Contact Name", "Company/Organization", "Contact Title", "Contact Method" (email, LinkedIn, phone), "Relationship" (colleague, mentor, alumni), "Next Follow-Up Date"
    • Include a dedicated sheet for tracking professional connections and follow-up actions.

  3. Customization Area:

    • Create a "Profile" section to store key variables:
      • Graduation Date: December 2026
      • Major: Computer Engineering
      • Minor: Chinese, Robotics
      • Primary Interests: AI/ML, Computer Vision, Defense and Futuristic Warfare Applications
      • Secondary Interests: Cybersecurity, Data Science, Emerging Technologies

  4. Sample Data:

    • Populate the Application Tracker with a sample row:
      • Company Name: "Innovative Defense Systems"
      • Job Title: "AI Research Engineer"
      • Location: "Remote"
      • Application Date: "2023-11-05"
      • Contact Information: "lisa.johnson@innovativedefense.com"
      • Application Status: "Interview Scheduled"
      • Notes/Comments: "Appeal to experience in deep learning and drone technology"
      • Required Skills: "Python, PyTorch, Object Recognition, Autonomous Systems"
      • Follow-Up Tasks: "Send follow-up email - 2023-11-10, Prepare for technical interview - 2023-11-12"

  5. Instructions:

    • The template should be visually appealing and intuitive to use, with clear headers and sufficient spacing between sections.
    • Ensure the structure remains consistent across sheets, using a standard font and color palette for a professional appearance.
    • Provide a "Quick Start" guide on the first sheet, explaining how to add new rows and modify existing data.

Output Format:

  • A link to a Google Sheets file hosting the final template, with all the described features implemented.
  • A text summary describing the key features and customizations made to suit the individual's profile.

Your goal:

  • Create a comprehensive, user-friendly career management system that allows seamless tracking of applications, networking efforts, and follow-up tasks for a computer engineering student with a focus on AI/ML and defense-related roles.
Original prompt (before our improvements)

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"