Gmail + Google Sheets, resume screening made easy
Resume screening starts simple. Then the inbox fills, PDFs pile up, and “quick review” turns into late-night copy-paste and second-guessing.
HR managers feel it first, but recruiters and startup founders end up doing the same work. This resume screening automation scores candidates, replies to them, and logs everything in one place, so you can move faster without getting sloppy.
This workflow uses n8n to collect applications, extract text from PDF resumes, ask Gemini to evaluate fit by role, then send an acceptance or rejection email via Gmail and record the result in Google Sheets.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Gmail + Google Sheets, resume screening made easy
flowchart LR
subgraph sg0["On form submission Flow"]
direction LR
n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/form.svg' width='40' height='40' /></div><br/>On form submission"]
n1@{ icon: "mdi:cog", form: "rounded", label: "Extract from File", pos: "b", h: 48 }
n2@{ icon: "mdi:robot", form: "rounded", label: "AI Agent", pos: "b", h: 48 }
n3@{ icon: "mdi:robot", form: "rounded", label: "Information Extractor", pos: "b", h: 48 }
n4@{ icon: "mdi:message-outline", form: "rounded", label: "Gmail", pos: "b", h: 48 }
n5@{ icon: "mdi:database", form: "rounded", label: "Google Sheets", pos: "b", h: 48 }
n6@{ icon: "mdi:brain", form: "rounded", label: "Google 2.5 Flash", pos: "b", h: 48 }
n4 --> n5
n2 --> n3
n6 -.-> n2
n6 -.-> n3
n1 --> n2
n0 --> n1
n3 --> n4
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n2,n3 ai
class n6 aiModel
class n5 database
classDef customIcon fill:none,stroke:none
class n0 customIcon
The Problem: Resume Screening Turns Into Inbox Admin
When applications arrive as PDFs, the work isn’t “reading resumes.” It’s everything around it. Download the file, skim it, try to compare it to a role, decide if it’s a yes or no, then write an email that doesn’t sound copy-pasted. Now repeat that 30 more times. If you’re hiring for multiple roles (Executive Assistant, IT Specialist, Manager), context switching makes it worse. Frankly, the slow part is the decision friction and the follow-up, not the PDF itself.
It adds up fast. Here’s where it breaks down in real teams.
- Applicants wait days for a response because the email step gets pushed “until later.”
- Scoring is inconsistent, because one reviewer is stricter and nobody remembers last week’s bar.
- Tracking lives in scattered places (inbox flags, notes, a half-maintained sheet), so reporting becomes a mini project.
- High-volume roles create decision fatigue, and good candidates slip through while you’re busy on admin.
The Solution: Auto-Score Resumes, Email Candidates, Log Outcomes
This n8n workflow turns your application intake into a clean pipeline. An applicant submits a form with their name, email, role, and PDF resume. n8n extracts the text from the PDF, then sends it to a Gemini-powered AI agent that evaluates the resume against the selected role. The AI produces a simple score (0–10), an “Accepted” or “Rejected” status, and a personalized email you can tailor to your tone. From there, Gmail sends the message automatically, and Google Sheets gets a new row with the candidate’s details and the email status. One submission in, one decision out, and a record you can actually use.
The workflow starts at the form submission trigger. Next, it parses the PDF and has Gemini evaluate fit for the job selected in the form. Finally, it sends the appropriate Gmail response and appends the candidate record to your Google Sheet for tracking.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you get 30 applications a week for two roles. Manually, you might spend about 10 minutes per candidate to download, skim, decide, write a reply, and update a tracker, which is roughly 5 hours weekly. With this workflow, the human time is closer to “check the sheet and spot-check edge cases,” maybe 15 minutes a day. Candidates also get same-day responses, which keeps strong applicants warm instead of wandering off.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets for the candidate tracking table.
- Gmail to send acceptance and rejection emails.
- Google Gemini API key (get it from Google AI Studio / Gemini API).
Skill level: Intermediate. You’ll connect Google accounts, add a Gemini key, and tweak prompts and email templates.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
Application form submission triggers the workflow. When a candidate submits their name, email, job role, and PDF resume, n8n starts the run immediately.
The PDF is converted into usable text. The “Extract from File” step pulls the resume content out of the PDF so the AI can evaluate it without you reformatting anything.
Gemini evaluates fit and drafts the response. The AI agent compares the resume to the selected role and generates a score (0–10), an Accepted/Rejected status, plus an email subject and email body you can brand.
Gmail sends, then Google Sheets logs. The workflow emails the candidate and appends a row to your Sheet with the decision, score, contact info, and email status so nothing gets lost.
You can easily modify the acceptance threshold and email tone based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Form Trigger
Set up the intake form that starts the candidate evaluation workflow.
- Add the Form Intake Trigger node as your trigger.
- Set Form Title to
Apply For Executive Assistant at SAMSUNG. - Set Form Description to
Give your Info carefully. - Add form fields exactly as shown: Name (required), Email Address (required), Job dropdown with options
Executive Assistant,IT Specialist,Manager, and a Resume file upload with Accept File Types set to.pdf.
Step 2: Parse the Uploaded Resume
Convert the uploaded PDF into text so the AI can evaluate the candidate.
- Add the Parse Resume File node and connect it to Form Intake Trigger.
- Set Operation to
pdf. - Set Binary Property Name to
Resume.
Step 3: Set Up AI Evaluation
Use Gemini to review the resume and extract structured evaluation data.
- Add the Candidate Review Agent node and connect it to Parse Resume File.
- Set Text to
=Name: {{ $('Form Intake Trigger').item.json.Name }} Job Name: {{ $('Form Intake Trigger').item.json.Job }} Resume: {{ $json.text }}. - Confirm Prompt Type is set to
defineand keep the provided system message for scoring, status, and email generation. - Add the Extract Evaluation Data node and connect it to Candidate Review Agent.
- Set Text to
={{ $json.output }}and define attributes for Score, Status, Mail Subject, and Mail Body. - Ensure Gemini Chat Model is connected as the language model for both Candidate Review Agent and Extract Evaluation Data. Credential Required: Connect your
googlePalmApicredentials in Gemini Chat Model.
Step 4: Configure Email and Sheets Outputs
Send the candidate result email and log the evaluation in Google Sheets. Extract Evaluation Data outputs to Dispatch Email Notice, which then outputs to Append Sheet Record.
- Add the Dispatch Email Notice node and connect it to Extract Evaluation Data.
- Set Send To to
={{ $('Form Intake Trigger').item.json['Email Address'] }}. - Set Subject to
={{ $json.output['Mail Subject'] }}and Message to={{ $json.output['Mail Body'] }}. - Set Email Type to
text. Credential Required: Connect your Gmail credentials in Dispatch Email Notice. - Add the Append Sheet Record node and connect it to Dispatch Email Notice.
- Select your Document and Sheet, and map columns: Job to
={{ $('Form Intake Trigger').item.json.Job }}, Name to={{ $('Form Intake Trigger').item.json.Name }}, Email to={{ $('Form Intake Trigger').item.json['Email Address'] }}, Score to={{ $('Extract Evaluation Data').item.json.output.Score }}, Status to={{ $('Extract Evaluation Data').item.json.output.Status }}, and Email Status toSENT ✅. - Credential Required: Connect your Google Sheets credentials in Append Sheet Record.
Step 5: Test and Activate Your Workflow
Run a full test to confirm emails and sheet updates happen correctly.
- Click Execute Workflow and submit a test entry through Form Intake Trigger with a PDF resume.
- Verify Parse Resume File outputs extracted text and Candidate Review Agent returns the scored evaluation.
- Confirm Dispatch Email Notice sends the email and Append Sheet Record appends a new row with score and status.
- When successful, toggle the workflow to Active to start processing real candidate submissions.
Common Gotchas
- Gmail OAuth credentials can expire or need specific permissions. If things break, check the n8n Credentials panel and your connected Google account security settings first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Gemini prompts that ship “generic” will sound generic. Add your brand voice and acceptance criteria into the Candidate Review Agent prompt early, or you’ll be editing outputs forever.
Frequently Asked Questions
About 45 minutes if your Google and Gemini accounts are ready.
No. You’ll mainly connect accounts and edit a few prompts and email templates.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Gemini API usage, which is billed per token.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, and it’s one of the best tweaks you can make. Add roles to the form dropdown in the Form Intake Trigger, then update the Candidate Review Agent prompt so Gemini knows what “good” looks like for each role. You can also change the acceptance threshold (for example, only accept 8/10 and above) inside the logic that sets Status. Common customizations include adding a “Needs review” middle status, different email templates per role, and a Slack or Teams notification when someone is accepted.
Usually it’s expired OAuth access or the wrong Google account connected. Reconnect the Gmail credential in n8n, confirm the account has permission to send mail, and double-check the “From” address settings in your Gmail node. If it fails only during high volume, you may be hitting Google sending limits for that mailbox. In that case, slow down the runs or use a dedicated hiring inbox.
On n8n Cloud Starter, assume a few thousand workflow runs per month depending on your plan and usage. If you self-host, there’s no execution cap, so it mostly depends on your server and Gemini rate limits. Practically, teams often run this comfortably for dozens of applications a day, then scale up once prompts and thresholds are stable.
Often, yes, because this is more than a two-step “if form then email” zap. You have an AI evaluation step, structured extraction (score, status, subject, body), and conditional logic that you’ll probably want to iterate on. n8n handles branching and customization without nickel-and-diming you for every extra step, and you can self-host if volume grows. Zapier or Make can still be fine if your logic is simple and you don’t care about deeper control. Talk to an automation expert if you want a quick recommendation for your setup.
Once this is running, the busywork fades into the background. Your sheet stays clean, candidates get timely replies, and you can focus on the handful of applications that actually deserve human attention.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
