Job and Internship Tracker for Google Sheets
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"
fill the variables
This prompt has 3 variables. Pro fills them into a ready-to-paste prompt for you — no manual find-and-replace.
{graduationDate:December 2026}{major:Computer Engineering}{interests:AI/ML, Computer Vision, Defense}
Unlock with Pro →when to use it
Community prompt from the open-source awesome-chatgpt-prompts library (CC0 public domain). A proven "Job and Internship Tracker for Google Sheets" starting point — swap in your own specifics and constraints. Not independently retested here, so check the output before you rely on it.
tags
codingcommunitygeneral
source
awesome-chatgpt-prompts · CC0 1.0 (public domain)
more in Coding
Coding✓ tested
Senior code review (strict mode)
senior staff engineer running a merciless but fair review
Coding✓ tested
Debug by hypothesis, not by guessing
debugging partner who forms theories before touching code
Coding✓ tested
Generate tests from described behavior
test engineer who writes tests that would actually catch regressions