AI recruiting pipeline: Job to candidate shortlist with Apollo & Airtable

Who’s it for Recruiting agencies, executive search firms, and in-house talent teams that want to automate candidate sourcing and prequalification. Instead of spending hours searching, scoring, and writing outreach, this workflow turns any job description into a ready-to-use shortlist with personalized messages. Youtube Walkthrough []( What it does (How it works) This workflow takes a job description (title, description, and location) and runs a complete recruiting automation pipeline: - Normalize job titles and generate variations to widen search coverage. - Search candidates in Apollo (or your CRM / database of choice). - Remove duplicates to keep clean lists. - Score candidates with AI (0–5) and provide concise reasoning across experience, industry, and seniority. - Enrich LinkedIn profiles (name, title, image, location, experience). - Create structured candidate assessments (summary, alignment, red flags, positives). - Generate outreach messages (email + LinkedIn DM) tailored to the candidate. - Write to Airtable for job/candidate tracking and downstream automation. Everything is plug-and-play, with no manual searching or copy-pasting required. Requirements - n8n (Cloud or self-hosted) - Airtable account + API access - Apollo API or your preferred candidate source - LLM provider: OpenAI or Anthropic - LinkedIn enrichment API (RapidAPI, Apify, etc.) > ⚠️ Do not hardcode API keys in HTTP nodes. Always use Credentials in n8n. Airtable table specifications Create one base (e.g., Candidate Search – From Job Description) with two tables: Jobs Table - Job Title (text) - Job Description (long text) - Job Location (text) - Candidates (linked to Candidates table) Candidates Table - Core fields: Name, LinkedIn URL, Job Title, Location, Image URL, Job Searches (linked) - Assessment fields: Summary Fit Score, Executive Summary, Title Alignment, Skill Alignment, Industry Alignment, Seniority Alignment, Company Type Alignment, Educational Alignment, Potential Red Flags, Positive Signals, Final Recommendation, Next Steps Suggestion - Outreach fields: Email Subject, Email Body, LinkedIn Message How to set up 1. Connect credentials Add Airtable, Apollo/CRM, and OpenAI/Anthropic credentials under n8n Credentials. 2. Create Airtable base/tables Follow the above spec for Jobs and Candidates. Match field names exactly to avoid mapping errors. 3. Configure the trigger The workflow starts from a Form/Webhook node. It captures: - Job Title (required) - Job Description (required) - Location (required) - Target Companies (optional, comma-separated domains) 4. Job title mutation The workflow uses an AI node to normalize the job title and generate up to 5 variations for broader candidate searches. 5. Candidate search Apollo (or your CRM API) is queried with the generated titles and location filters. Results are deduped. 6. AI scoring & structuring Candidates are scored 0–5 with clear reasoning (experience, industry, seniority, general fit). Profiles are formatted into structured JSON for Airtable. 7. LinkedIn enrichment Enrichment API fetches missing data (geo, image, job history). 8. Candidate assessment An AI model produces a full recruiter-ready evaluation (fit summary, strengths, red flags). 9. Outreach generation The workflow drafts a concise cold email (<75 words) and LinkedIn DM (<60 words), consultative in tone. 10. Write to Airtable All jobs and candidates (with assessments and outreach messages) are logged for review and integration. How to customize - Swap Apollo with your CRM (Greenhouse, Bullhorn, etc.). - Adjust scoring prompts to match your niche (sales, engineering, healthcare). - Add custom filters for target companies or industries. - Change outreach tone to align with your brand voice. - Limit by score (e.g., only push candidates with score ≥4). Security & best practices - Store all keys in n8n Credentials (never in nodes). - Use Set nodes to centralize editable variables (title, location, filters). - Always add sticky notes in your workflow explaining steps. - Rename nodes clearly for readability. Troubleshooting - No candidates found? Loosen title variations or broaden location. - Low fit scores? Refine keywords and required skills in scoring prompts. - Airtable errors? Double-check Base ID, Table ID, and field names. - API rate limits? Enable batching/pagination and increase intervals. --- SEO title: Build candidate shortlists from a job description to Airtable with Apollo, AI scoring, and personalized outreach Keywords: recruiting automation, Apollo people search, candidate enrichment, AI scoring, Airtable recruiting CRM, LinkedIn outreach, n8n workflow template