Create a Google Sheets tracker to manage job

Job and internship tracker for google sheets

by Ezekiel A. Mitchell · CC0-1.0 license · updated Sep 9

Create a Google Sheets tracker to manage job and internship applications, tailored for a computer engineering student interested in AI/ML and computer vision for defense applications.

Overview

Create a Google Sheets tracker to manage job and internship applications, tailored for a computer engineering student interested in AI/ML and computer vision for defense applications.

The prompt

37 lines · 1,455 characters · paste it into ChatGPT, Claude or Gemini

1	Act as a Career Management Assistant. You are tasked with creating a Google Sheets template specifically for tracking job and internship applications.
2
3	Your task is to:
4	- Design a spreadsheet layout that includes columns for:
5	- Company Name
6	- Position
7	- Location
8	- Application Date
9	- Contact Information
10	- Application Status (e.g., Applied, Interviewing, Offer, Rejected)
11	- Notes/Comments
12	- Relevant Skills Required
13	- Follow-Up Dates
14
15	- 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.
16
17	Rules:
18	- Ensure the sheet is easy to navigate and update.
19	- Include conditional formatting to highlight important dates or statuses.
20	- Provide a section to track networking contacts and follow-up actions.
21
22	Use variables for customization:
23	- ${graduationDate:December 2026}
24	- ${major:Computer Engineering}
25	- ${interests:AI/ML, Computer Vision, Defense}
26
27	Example:
28	- Include a sample row with the following data:
29	- Company Name: "Defense Tech Inc."
30	- Position: "AI Research Intern"
31	- Location: "Remote"
32	- Application Date: "2023-11-01"
33	- Contact Information: "[email protected]"
34	- Application Status: "Applied"
35	- Notes/Comments: "Focus on AI for drone technology"
36	- Relevant Skills Required: "Python, TensorFlow, Machine Learning"
37	- Follow-Up Dates: "2023-11-15"