Glassdoor offers a wealth of open positions across the globe. And for many of us, it's the first stop in our job hunt.
But, let's be honest, sifting through countless listings can be overwhelming.
So, is there a way to streamline the job-hunting process?
Absolutely. And that’s exactly what Clay is for.
Clay established itself not just as a powerful prospecting tool but also as a useful platform for job seekers. And I’m excited to share with you how the entire process is done, from scraping job listings to finding the contact details of hiring managers.
I’ll also show you how easy it is to write a cover letter using ChatGPT. By the end, you should get results like this:
Steps to Find Open Jobs in Glassdoor
1) Install Instant Data Scraper
We’ll be using Instant Data Scraper for this task.
Just head over to the Chrome Web Store, type in ‘Instant Data Scraper,’ and click ‘Add to Chrome.’
2) Scrape Target Companies from Glassdoor
Go to Glassdoor and enter a job role you want to apply.
For instance, I went for ‘software engineer’ and added ‘New York’ as the location. When you search, you'll see a list of companies hiring for that role.
You can also add filters to refine your search, like entering a job type, the date the job was posted, and the salary range. For this tutorial, we’ll keep things simple and skip the filter options.
Next, click on the Instant Data Scraper icon in your toolbar.
A small window pops up. Here, I’ve set a delay between 1 to 20 seconds (feel free to experiment with different delays to get more accurate results). The delays mimic how we scroll, making it less likely for sites to ban our IP.
Don't forget to choose the infinite scroll option to grab all the details.
Once you've got everything set, tap 'Start Crawling'. This should fill up your table with data in real time.
When it's done, pick how you want to save the data. For this example, I went with a CSV file.
3) Import Your Data to Clay
Open your Clay dashboard and create a new table.
You’ll be asked what kind of list you’re adding. Let’s go for ‘Companies.’ Next, click ‘Browse’ to upload the CSV file. Then, you can add your data to a new table or an existing table (I went with a new blank table).
Note: You can also skip this process and just proceed to create a blank table. Then, simply tap the ‘import’ button at the bottom of your page to upload your file.
Now, your table should show all the info from Glassdoor. Delete the details you don’t need and rename the columns if needed.
4) Find Company Domains
Company domains are important for finding the right people to contact, in this case, the hiring managers.
But, our current list doesn't have that. So, we’ll need to enrich our list.
Right-click on the table and select ‘Add Enrichment.’
Select ‘Get Domain from Company Name’ by Clearbit.
In the settings, let’s use Clay’s API. Then, select the company name as input.
Click ‘Continue to Add Fields.’ In the next settings, you have the option to add data to your table. Let’s skip this part.
Save the settings and run the tool.
Check the output on your table. You should now see the domains for each company.
5) Find Each Company’s Decision Maker
To identify the decision makers in each company, start a new enrichment.
When the window appears, select 'Find Contacts at Company.'
Use the domain as the 'Company Identifier.’
Since our goal is job hunting, we’ll need to input specific job titles into the 'Job Title Keywords' field. Here are a few keywords you can use (feel free to add more):
- Human Resources Director
- Talent Acquisition Director
- Human Resources Manager
- Talent Acquisition Manager
- Head of Recruitment
Proceed by clicking "Continue to Add Fields". From there, select the data you'd like to see in your table, such as names, titles, and LinkedIn URLs.
After the enrichment, you'll see the results.
Keep in mind that our enrichment tool might not capture all the information. Some companies use other job titles for their recruitment team. So, consider adding keywords like "hiring manager", "recruiter", or "HR specialist".
If you're still missing some info, it could be due to the tool's limitations or because certain details are not shared publicly.
Go ahead and clean your table or sort the rows to get a clear view of the results.
Tip: If you want to display more details about your lead, simply click on the row, select a result from the list, and hover your mouse over the data you're interested in. Then, click 'Add as column.'
6) Find the Email Address of Decision Makers
Let’s enrich our table further. In the open window, go to the ‘Waterfall’ tab and select ‘Work Email.’
In the settings, you should see all the available tools to find email addresses.
For this tutorial, let’s stick with the default settings with Clay Enrichments, Datagma, and Hunter as email providers.
In the input fields, add the contact’s name, company name, and company domain.
Lastly, use Debounce to validate all email addresses.
Click save and run.
Check your table. You should now have the work emails of your target leads.
7) Use ChatGPT to Write a Cover Letter
Now you have the work emails of hiring managers, next up is a standout cover letter.
But think about it - writing a unique letter for each company? That's a lot, especially if you're reaching out to more than 20.
Thankfully, you don’t have to do that. We can use Clay’s AI integration to write a cover letter in no time. Simple add a new enrichment and click 'Use AI' from the pop-up.
But here’s the trickiest part - writing a good prompt to generate the right output.
Here, you have to be creative and specific in giving instructions to AI. At first, your message might sound off. So, tweak your prompt and add more specific instructions. With a few adjustments, you should generate the right message.
Here’s a sample ChatGPT prompt I’ve created. It’s not perfect. But you can use it as a starting point.
Assume you are a software engineer with 5 years of industry experience and you're currently looking for a job. Write a cover letter under 200 words. Every message you write follows the message template.
Your message template:
Start with Dear /Hiring Manager Name
First Line: [mention your interest in applying to their company, and why you want to work for them]
Second line: [mention that you've finished your computer science degree from New York University][mention that you took your internship from Microsoft][mention some of the projects you've done, like the Giggawhat Design Suite and Smart Navigation for mobile]
Third line: [mention about your experiences working for XYZ Company. mention how you've helped implement a new software review system that improved efficiency by 55% for the team. mention the positive feedback about the software and how it helped potential customers and partners]
Fourth line: [add details about your availability for an interview]
End of template.
Once you run the integration, you should see the personalized cover letter for each company in a separate column.
Here’s a sample output written by AI:
[Subject line: Experienced Software Engineer Seeking Opportunities at Your Esteemed Company]
Dear Paul Anderson,
I am writing to express my interest in applying to your influential organization, which has long been at the forefront of technological innovation. I am drawn to your firm's commitment to using technology as a tool to solve complex problems and inspire positive change.
As a Computer Science graduate from New York University and a former intern at Microsoft, my experience spans various projects. One notable example is the Giggawhat Design Suite and the development of Smart Navigation for mobile, both of which garnered favorable responses for their efficiency and user-friendly interfaces.
The majority of my industry experience was gained at XYZ Company, where I implemented a novel software review system that boosted our team's efficiency by 55%. The software was well-received by both our clients and collaborators, contributing significantly to our business's growth and customer satisfaction.
I am available to discuss my background and potential fit with your team at your earliest convenience.
That’s A Wrap!
You've just taken a big step forward in your job search journey.
Honestly, knowing how to scrape promising job listings from Glassdoor and finding company decision-makers using Clay should give you an edge.
Plus, crafting personalized cover letters with a little help from ChatGPT makes job hunting a breeze.
With Clay, the sky's the limit for you. You've got the tools, the know-how, and hopefully, a sprinkle of excitement to venture out there and get that job you've been dreaming of.
Before you go, we've got a bunch of other tutorials that feature Clay’s capabilities. Feel free to check them out:
- Customize Email First Lines Based on LinkedIn Posts With Clay
- Add Personalized City/ Location Images in Emails With Clay
- Find Contacts Based on Job Title With Clay (Unlock Business Potential)
If you have any questions, please let me know in the comments. Happy job hunting!