The job hunt can suck.
Where do I start?
How do I keep track of stuff?
How do I make sure I’m not doing the same things over and over again?
Those questions crossed my mind earlier today when I tried to help someone build a list of jobs that fit what they were looking for.
I realized how much this process can suck. After only a few minutes, I felt like I was repeating some of the same searches over and over again.
Even with all the different jobs boards and the filters they offer – it’s still a big time suck to keep tabs.
So I asked myself, Can I make something quickly that simplifies this?
Here's a quick explainer video of what I built to organize my job search process.
This quick and easy tool generates a search string for jobs based on title or role type, the job type, when the job was posted, and the location.
After getting frustrated trying to track all of the things I searched, I decided to do something about it. Just in case others could use something similar.
The good news is, I made a template, so you can use it or share it any way you like.
All you have to do is click here to access the Google Sheet.
Feel free to use this template any way you see fit. All you have to do – click file, "make a copy", then rename it and save it to your drive. Then you're on your way!
Oh, and here are a couple other useful tips for using:
If the city or role you're looking for isn't included – just navigate to the tab and add them to the list. (I already added conditional formatting where the cells are empty and formulas for the LOOKUP values).
If the city you're looking for isn't included, just add it to the bottom of the list (in the orange cells).
If the role type or job title you're looking for isn't included, just add it to the bottom of the list (in the orange cells).
And that's it! Feel free to make your own copy. Here's a link to the sheet.
Psssst...but if you don't feel like you know what roles to start searching for, we've also got you covered. Try this free survey tool we built to discover the best roles to launch your career.