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

1
  1. Boolean Query Generation
  2. LLM converts your candidate description into a concise, high-impact LinkedIn Boolean search string.
2
  1. Google Search & Extraction
  2. Run deterministic Google searches with primary and fallback queries, then extract, normalize, and deduplicate LinkedIn profile URLs from results.
3
  1. Optional Precision Filtering
  2. Filter candidate URLs by scoring keyword relevance and context to keep only the most pertinent profiles when enabled.
4
  1. Sheet Creation & Population
  2. Create a timestamped sheet tab, write predefined headers, and append candidate rows one-by-one with controlled pacing.
5
  1. Run Summary & Diagnostics
  2. 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

  1. Step 1. Prepare Inputs
  2. Paste your ideal candidate description and provide the Google Spreadsheet ID for results storage.

  3. Step 2. Configure Parameters
  4. Set optional parameters like sheet tab prefix, max results limit, search locale, delay between writes, and enable/disable precision filtering.

  5. Step 3. Run the Workflow
  6. The workflow will generate Boolean queries, crawl LinkedIn URLs, filter them if enabled, and write structured candidate data to your sheet.

  7. Step 4. Monitor Progress
  8. Observe the incremental writing of candidate rows with pacing to avoid API rate limits.

  9. Step 5. Verify Results
  10. Check your Google Spreadsheet for the new sheet tab with candidate URLs and metadata. Review the summary and diagnostics for completeness.

FAQs

How does the workflow generate Boolean search queries from my candidate description?
It uses an LLM-powered node "Generate LinkedIn Boolean Query" to convert your job or candidate description into a concise, valid LinkedIn site-restricted Boolean search string optimized for Google Search.
What is the purpose of the precision filtering option?
When enabled, precision filtering scores candidate URLs for relevance based on keyword presence and context, filtering out less pertinent profiles to improve quality over quantity.
How does the workflow handle writing data to Google Sheets without hitting rate limits?
It uses a delayed loop controlled by the "Delay Between Writes" node, spacing out row appends to avoid API throttling while ensuring complete data transfer.
What if the LLM fails to produce a valid JSON search plan?
The "Parse Search Plan" node falls back to building a default LinkedIn site query from your candidate description to ensure the search proceeds without interruption.
Can I customize the sheet tab name where results are saved?
Yes, provide a prefix via the "SheetTitlePrefix" parameter; the workflow appends a timestamp to avoid conflicts and ensure unique sheet tabs.
Was This Page Helpful?

More Workflows for Inspiration

✒️
YouTube Podcast Summary and Save to Sheets
Automate podcast transcript capture, summary generation, and archiving to Google Sheets instantly.
Learn more >
💬
Workspace Default Flow
Automate conversation start logic to flexibly switch AI modes and optimize response accuracy.
Learn more >
🔍
WordPress Post AI Auto-Categorizer
Automatically assign primary categories to WordPress posts using AI, saving time and ensuring consistency.
Learn more >