Gmail Export for Recruiters: Build a Candidate Database

Use cases

Gmail Exporter Guide

Recruiters accumulate candidates in their inbox faster than any system can keep up with: replies to job posts, referrals, LinkedIn intros that move to email, follow-ups months later. A simple, private export turns that scattered correspondence into a structured candidate database you fully control. Here's how to build one, keep it organized by role, and stay on the right side of data rules.

Step 1 — Organize candidate emails by role

The cleanest databases start with organized source mail. Two approaches:

• Label per requisition. Create labels like Backend-Req or Designer-Search and tag incoming candidate emails. Then export each label separately.
• Search per role. If you didn't label, search by subject or keyword — subject:application backend or "react developer" — and export each result.

Either way you get one clean file per role. The label workflow is covered in exporting a Gmail label to a spreadsheet.

Step 2 — Export candidates to a CSV

1. Install Gmail Exporter from the Chrome Web Store — free, no account.
2. Open the role's label or search so only those candidate emails show.
3. De-duplicate so each candidate is one row, not one row per message.
4. Export CSV — names, email addresses, dates, and any phone numbers found in signatures.

It runs locally in your browser, so candidate emails aren't uploaded anywhere. The name and phone extraction is detailed in exporting sender names and phone numbers. Always confirm any auto-extracted detail against the candidate's own message before you rely on it.

Step 3 — Turn the export into a pipeline tracker

Open the CSV in Sheets or Excel and add columns to track each candidate's progress:

Filter by Stage to see who needs action today, or sort by Last contact to catch candidates going cold. It's a lightweight applicant tracker you own outright — no per-seat fees, no lock-in.

Spreadsheet vs. a full ATS

Be realistic about the trade-off. For a solo recruiter or a couple of open roles, a structured sheet is fast and flexible. For a team running many reqs with collaboration and automated stages, a proper ATS earns its keep. Even then, a Gmail export is useful: seed a new ATS with your existing candidates, or keep an independent record of correspondence outside the system. For a CRM-style version of this workflow, see how sales teams export Gmail contacts into a CRM — the mechanics are nearly identical.

Build a reusable talent pool

Great candidates who weren't right this time are right next time. Keep a master "talent pool" sheet: every quarter, export your recent candidate labels, de-duplicate against the master, and add new people with the role they fit. Over a year you build a searchable bench you can tap before posting a new job. The de-duplication step is the same one behind removing duplicate contacts from Gmail.

Handle candidate data responsibly

Candidate emails are personal data, so treat the export with care:

• Keep it local and access-controlled — a private spreadsheet, not a widely shared link.
• Mind retention rules. Many jurisdictions limit how long you can hold candidate data without consent; set a review date.
• Honour deletion requests. If a candidate asks to be removed, remove them from the sheet and the source mail.
• Note the source for each candidate so you can show where the data came from.

Because the export is local, you're not adding a third-party processor to the chain — one fewer thing to account for in a privacy review.

Tips

• One file per req keeps roles from blurring together.
• Standardize stage names so filters work cleanly.
• Re-export monthly to fold in new applicants.
• Verify contact details from the candidate's own message before outreach.

Run a follow-up cadence from the sheet

The fastest way candidates go cold is a missed follow-up. Your exported sheet can drive a simple cadence without any extra software. Add two columns — "Last contact" (pre-filled from the export's date) and "Next touch" — and set a rule for yourself: screened candidates get a check-in within three days, anyone in interview stage within a day. Sort by Next touch each morning and the top rows are your call list.

For passive candidates who weren't ready, a lighter cadence works: a quarterly "still interested?" note keeps the relationship warm. Because every row carries the date of last contact, you can instantly see who you haven't spoken to in 90 days and re-engage before a competitor does.

Report on your pipeline at a glance

Once the sheet has a Stage column, it doubles as a reporting tool. A quick count of rows per stage tells you the shape of your funnel — how many applied, screened, interviewed, offered. Tracking those counts week over week shows whether the top of the funnel is healthy or whether candidates are stalling at a particular stage.

• Conversion check: compare applied-to-screened and screened-to-interview ratios to spot where you're losing people.
• Source quality: group by the Source column to see which channels actually produce hires, not just applications.
• Aging: flag candidates who've sat in one stage too long using the Last contact date.

None of this needs a dashboard — a pivot table or a few formulas over the exported data is enough. And because you can re-export and refresh the sheet whenever you like, the numbers stay current. For the contact-hygiene side of keeping that sheet clean across many exports, see removing duplicate contacts from Gmail.