Job and Internship Tracker for Google Sheets
Job and Internship Tracker for Google Sheets — a ready-to-use text prompt with customizable fields (graduationDate, major, interests) for Career & Productivity. Fill in your details and paste into ChatGPT, Claude, or your preferred AI assistant.
How to use it
- Fill in graduationDate, major, interests below (or keep the suggested defaults).
- Copy the generated prompt.
- Paste it into ChatGPT, Claude, or your preferred AI assistant.
Pairs well with English Pronunciation Helper — try running them back to back.
Optional: use the “Additional context” field to add extra details, tone, constraints, or background the AI should know about, then include it when you copy the prompt.
Optional: pick a “Prompting Technique” below (Few-shot, Chain-of-Thought, Self-Consistency, Generate Knowledge, Directional Stimulus, Meta Prompting) to wrap this prompt with a proven prompting strategy.
The base 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}
- ${major}
- ${interests}
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"Want it filled in and enhanced? Use the builder →
Related prompts
English Pronunciation Helper
English Pronunciation Helper — a ready-to-use text prompt with customizable fields (Mother Language) for Career & Productivity. Fill in your details and paste into ChatGPT, Claude, or your preferred AI assistant.
Career Counselor
Career Counselor — a ready-to-use text prompt with customizable fields (Your first request) for Career & Productivity. Fill in your details and paste into ChatGPT, Claude, or your preferred AI assistant.
Self-Help Book
Self-Help Book — a ready-to-use text prompt with customizable fields (Your first request) for Career & Productivity. Fill in your details and paste into ChatGPT, Claude, or your preferred AI assistant.
Aphorism Book
Aphorism Book — a ready-to-use text prompt with customizable fields (Your first request) for Career & Productivity. Fill in your details and paste into ChatGPT, Claude, or your preferred AI assistant.