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 ap…
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"How to use this prompt
- 1
Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.
- 2
Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.
- 3
Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.
Techniques in this prompt
Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.
Learn this techniqueRecommended models
Build on this prompt
Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.
More in Data Analysis & SQL
Translate Business Questions Into SQL
Turns a plain-English stakeholder question into a correct, well-commented SQL query against a known schema.
Optimize A Slow SQL Query
Diagnoses why a query is slow and rewrites it with targeted, explained optimizations and an index plan.
Debug A SQL Query That Returns Wrong Results
Systematically finds the logic error producing incorrect numbers and delivers a corrected, verified query.
Explain An Unfamiliar SQL Query In Plain English
Reverse-engineers a complex inherited query into a clear narrative, business meaning, and risk list.