Human Resources · HR Professionals

AI Agent for HR Candidate Evaluation with LinkedIn Data in CSV/XLSX

Monitors CSV/XLSX uploads, fetches LinkedIn data via Apify, scores each candidate with GPT-4.1, generates Hebrew explanations, formats sheets, and alerts on errors.

How it works
1 Step
Upload & Ingest
2 Step
Enrichment & Scoring
3 Step
Output & Monitoring
Submit a CSV/XLSX; the AI agent stores it in Google Drive and creates a new Sheet with RTL formatting.

Overview

End-to-end automation from upload to decision-ready results.

The AI agent converts your candidate list into a decision-ready evaluation. It enriches profiles with LinkedIn data and context, scores candidates on a 0-100 scale, and explains each score in Hebrew. It outputs a neatly formatted sheet with filters, sorting, and clear decision signals for recruiters.


Capabilities

What AI Agent for HR Candidate Evaluation does

Performs end-to-end candidate evaluation in one workflow.

01

Convert CSV/XLSX to Google Sheet with RTL formatting

02

Fetch up to 3 recent LinkedIn posts per candidate via Apify

03

Evaluate each candidate against job requirements using GPT-4.1 and a transparent rubric

04

Generate Hebrew explanations for each score

05

Sort results by score and apply professional formatting

06

Monitor for errors and send alerts when issues occur

Why you should use AI Agent for HR Candidate Evaluation

Before adopting this AI agent, HR teams faced manual data handling, inconsistent scoring, and delays in decision-making. After adoption, you get standardized scoring, LinkedIn-enriched candidate context, Hebrew explanations, batch processing, and proactive error alerts.

Before
Manages data manually across scattered CSV/XLSX files.
Scores inconsistently across evaluators.
Delays hiring decisions due to slow reviews.
Lacks LinkedIn context for accurate assessments.
Requires manual formatting and reporting.
After
Standardizes scoring with a transparent rubric.
Enriches profiles with LinkedIn data automatically.
Generates Hebrew explanations for each score.
Sorts results and applies polished formatting.
Notifies admins of errors promptly.
Process

How it works

A simple 3-step flow from upload to decision-ready results.

Step 01

Upload & Ingest

Submit a CSV/XLSX; the AI agent stores it in Google Drive and creates a new Sheet with RTL formatting.

Step 02

Enrichment & Scoring

For each candidate, fetch LinkedIn posts via Apify, compare against job requirements, and compute a 0-100 score using GPT-4.1.

Step 03

Output & Monitoring

Format the sheet, apply filters and sorting, generate Hebrew explanations, and alert admins of any errors.


Example

Example workflow

One realistic scenario demonstrates task, time, and outcome.

Task: evaluate 15 candidates for a data analyst role from a CSV. Time to process: approximately 5–7 minutes. Outcome: a Google Sheet sorted by score (0-100) with Hebrew explanations for each candidate, ready for review.

HR Google Drive & SheetsApifyOpenAI GPT-4.1Gmail AI Agent flow

Audience

Who can benefit

One supporting sentence.

✍️ HR Managers

Standardize evaluation and accelerate shortlisting across teams.

💼 Recruitment Agencies

Scale consistent client scoring for multiple roles.

🧠 Hiring Managers

Access data-driven insights to speed decisions.

Talent Acquisition Analysts

Maintain auditable scoring with LinkedIn context.

🎯 SMB HR Teams

Handle higher volumes without increasing headcount.

📋 Team Leads (Hebrew-speaking organizations)

Provide Hebrew explanations for stakeholders preparing offers.

Integrations

One supporting sentence.

Google Drive & Sheets

Stores inputs, creates a new Sheet, and applies RTL formatting to match Hebrew data.

Apify

Fetches up to 3 recent LinkedIn posts per candidate to inform evaluation.

OpenAI GPT-4.1

Calculates scores, generates Hebrew explanations, and enforces the scoring rubric.

Gmail

Sends error alerts and notification emails to admins.

Applications

Best use cases

Six practical scenarios where the AI agent adds value.

Evaluate large candidate batches for software roles.
Standardize evaluation for multiple client projects in agencies.
Provide data-backed insights for hiring managers.
Process high-volume applications quickly without sacrificing quality.
Maintain consistent scoring across different job families.
Deliver Hebrew-language explanations for internal stakeholders.

FAQ

FAQ

Common questions and practical answers.

The AI agent accepts CSV and XLSX inputs. It converts them into a Google Sheet with RTL formatting to preserve Hebrew data and layout. The workflow handles both formats automatically, so you can upload whichever you already have. If a file contains extra columns, you can map them during setup. The system processes candidates sequentially, but it scales to larger batches by batching the work.

No coding skills are required. The solution is template-based and config-driven: you provide the CSV/XLSX, connect Google Drive/Sheets, Apify, and OpenAI, and you’ll manage credentials. The platform handles the orchestration and error alerts. You can adjust the scoring rubric and language settings through the UI or configuration files. Advanced users can customize integration points if needed.

LinkedIn data is scraped through Apify within rate limits and usage policies. The AI agent uses a robust scoring rubric but treats LinkedIn data as contextual input rather than a singular decision factor. You get a score plus a Hebrew explanation that reflects the data quality. You should review flagged items and update URLs when needed.

Yes. The scoring rubric is configurable (weights like 50/25/15/10) and can be adjusted to align with job requirements. You can tune which signals matter most (experience, activity signals, or relevance to roles). Any changes apply consistently across all candidates in a batch. You can also save multiple rubric presets for different roles.

The agent supports Hebrew by default and can switch to other languages. Hebrew explanations are generated to provide context about why a score was assigned. You can enable bilingual reporting if needed. Translation settings can be adjusted per job or per client.

Errors are logged and surfaced via email alerts to admins. The agent continues processing other candidates where possible and retries failed steps where appropriate. You’ll see error details in the sheet and can trigger a quick remediation flow. The system also sends a summary of issues after each batch run.

Cost is approximately $0.05 per candidate, depending on the exact data pull and post count used. The pricing is designed for batch processing of typical recruitment pipelines. You’ll see the per-candidate cost in your usage report. This makes it easy to budget for high-volume hiring. The system optimizes prompts and post fetch to maximize value.


AI Agent for HR Candidate Evaluation with LinkedIn Data in CSV/XLSX

Monitors CSV/XLSX uploads, fetches LinkedIn data via Apify, scores each candidate with GPT-4.1, generates Hebrew explanations, formats sheets, and alerts on errors.

Use this template → Read the docs