Overview
Recruiters waste hours crafting search strings and sifting LinkedIn manually. This workflow automates Boolean query generation from your candidate brief, scrapes LinkedIn profile URLs via Google Search, applies optional precision filtering, and writes clean, deduplicated candidate lists directly into your Google Spreadsheet for instant access and auditability.
The Impact
- Slash manual Boolean building. Let LLM generate optimized LinkedIn site queries from your job specs.
- Extract at scale. Crawl and deduplicate hundreds of LinkedIn URLs automatically via Google Search.
- Filter smartly. Enable precision filtering to keep only highly relevant candidate links.
- Archive seamlessly. Write structured candidate data into Google Sheets with timestamped tabs.
Who This Is For
- Recruitment Teams batch-scraping passive LinkedIn candidates for multiple roles.
- Talent Intelligence mapping market supply and competitor talent pools by tech and location.
- Freelance Headhunters automating lead list creation from client job descriptions.
- Recruitment Ops centralizing candidate URLs for bulk screening or ATS import.
How It Works
- Boolean Query Generation
- LLM converts your candidate description into a concise, high-impact LinkedIn Boolean search string.
- Google Search & Extraction
- Run deterministic Google searches with primary and fallback queries, then extract, normalize, and deduplicate LinkedIn profile URLs from results.
- Optional Precision Filtering
- Filter candidate URLs by scoring keyword relevance and context to keep only the most pertinent profiles when enabled.
- Sheet Creation & Population
- Create a timestamped sheet tab, write predefined headers, and append candidate rows one-by-one with controlled pacing.
- Run Summary & Diagnostics
- Aggregate run stats, including counts, filtering mode, and any issues, returning a clear summary and final outputs.
What You'll Need
Before using this template, make sure you have:
- A Google Spreadsheet prepared to store results (blank is fine). The workflow manages sheet tabs automatically.
- Google OAuth credentials authorized to create sheets and write rows in your Google Drive.
- A clear candidate description or job posting text including titles, skills, and location.
- Spreadsheet ID extracted from your Google Sheet URL.
How to Use
- Step 1. Prepare Inputs
- Step 2. Configure Parameters
- Step 3. Run the Workflow
- Step 4. Monitor Progress
- Step 5. Verify Results
Paste your ideal candidate description and provide the Google Spreadsheet ID for results storage.
Set optional parameters like sheet tab prefix, max results limit, search locale, delay between writes, and enable/disable precision filtering.
The workflow will generate Boolean queries, crawl LinkedIn URLs, filter them if enabled, and write structured candidate data to your sheet.
Observe the incremental writing of candidate rows with pacing to avoid API rate limits.
Check your Google Spreadsheet for the new sheet tab with candidate URLs and metadata. Review the summary and diagnostics for completeness.