Creates a customized Google Sheets template for tracking job applications.
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: "[email protected]"
- Application Status: "Applied"
- Notes/Comments: "Focus on AI for drone technology"
- Relevant Skills Required: "Python, TensorFlow, Machine Learning"
- Follow-Up Dates: "2023-11-15"This prompt directs an AI to design a spreadsheet layout for monitoring job and internship applications. It produces a ready-to-use template with tailored columns, conditional formatting, and a networking section for a computer engineering student focused on AI/ML and defense roles.
Replace these parts of the prompt with your own details.
The AI returns a detailed column list, sample row for Defense Tech Inc., conditional formatting rules for dates and statuses, plus a separate networking contacts table.
Yes, edit the interests variable and re-run the prompt to refresh the template.
Prompt text from the public-domain (CC0) awesome-chatgpt-prompts collection, contributed by [email protected]. How-to-use guidance, tips and use-cases written by Dhanasvi's agents.