Job hunting can be a complex and overwhelming task.
But, using Google Sheets and FileDrop can make it much easier to keep track of the positions you’re interested in, the applications you’ve sent, and the responses you’ve received.
Organize Your Job Search
Step 1: Setting Up Your Google Sheets
First, you need a Google account. Once logged in, go to Google Sheets and click the “Blank” option to create a new spreadsheet. You can name your document “Job Search Tracker” to clarify things.
Step 2: Creating Your Columns
Consider your spreadsheet a big table with different categories or ‘columns.’ For your job search, here are some essential columns to include:
- Job Title: The position you’re applying for.
- Company Name: The name of the organization.
- Job Posting Link: A direct link to the job listing.
- Application Date: When you applied.
- Follow-Up: A reminder to follow up on your application.
- Interview Date: When your interview is scheduled.
- Status: Where you stand—applied, interviewing, offer received, etc.
- Notes: Any important details or reminders.
Step 3: Filling In Your Job Applications
Once you set up your columns, start filling in the details for each job you apply for. It is your job search’s central hub, so keep it updated with all the latest information.
If you apply for a new job, add it to the sheet. If you hear back about an interview, update us on the status.
Step 4: Using Filters and Sorting
As your spreadsheet fills up, you should examine specific types of jobs or see which applications need follow-up. Google Sheets makes this easy with filters.
Click on the Data menu and then “Create a filter.” This will allow you to filter by any column, showing only the jobs you’ve been interviewed for.
You can also sort your data. For example, you can see the jobs you most recently applied for at the top.
To do so, click on the column header for ‘Application Date,’ then click on the small filter icon that appears and select “Sort Z → A” to get your most recent applications at the top.
Step 5: Keeping It Updated and Handy
The key to this system’s success is keeping it updated. Whenever your job search changes, add it to your spreadsheet. It’s also a good idea to make it a habit to check your job search tracker daily.
Additionally, since Google Sheets is online, you can access it from anywhere—you can check it on your phone before an interview to refresh your memory about the job, for example.
Get a copy of the free Job Search Tracker Template.
Step-by-Step Guide to Using FileDrop with Your Job Search Dashboard
FileDrop makes it easy to attach documents directly to your Google Sheets. Your tailored resume and cover letter can be attached to each job listing on your tracker in the corresponding cell.
Step 1: Install FileDrop
If you don’t have FileDrop yet, you can get it from the Google Workspace Marketplace.
Step 2: Launch FileDrop
Open your job search dashboard in Google Sheets and launch FileDrop from the Add-ons menu.
Step 3. Drag & Drop Files
You can drag and drop your customized resume or any other document into the FileDrop sidebar to upload it directly to the relevant row in your spreadsheet. This way, you can see the versions of resumes you have sent to different companies.
Alternatively, you can use the ‘Add Files from Drive‘ button to link existing documents from your Google Drive.
Video Tutorial
Final Thoughts
Combining Google Sheets for organization and FileDrop for file management creates a powerful tool in your job search arsenal. These tools can help you track where you’ve applied and ensure all necessary files are easily accessible and well-organized.
Time saved on administration means more time for researching companies, networking, and preparing for interviews—the activities that truly matter in your job search.
Frequently Asked Questions
Can I use Google Sheets to track job applications on my mobile device?
The Google Sheets app for iOS and Android allows you to access, edit, and manage your job search spreadsheet from your mobile device. This is especially handy for updating your job search progress on the go.
Can I track my job interview progress with Google Sheets?
You can add columns or create a separate tab within your spreadsheet to track interview dates, feedback, questions to prepare, and follow-up actions. This will help you keep all aspects of your job search organized in one place.
