Google Sheets + Gmail, faster candidate shortlists
You’ve got candidate data in Google Sheets, decisions in someone’s head, and “I’ll email them later” sitting on a sticky note. Then a great candidate goes cold because the follow-up didn’t happen, or you end up emailing the wrong person from a stale row.
Recruiters feel it first. But HR coordinators and busy founders running hiring on the side deal with the same mess. This Google Sheets Gmail automation turns your shortlist into something you can trust, so strong candidates get next steps fast.
You’ll see how this workflow pulls candidates from a sheet, filters by score, emails qualified people with a Calendly link, and creates ClickUp tasks so your team can move immediately.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Google Sheets + Gmail, faster candidate shortlists
flowchart LR
subgraph sg0["When clicking ‘Execute workflow’ Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking ‘Execute workf..", pos: "b", h: 48 }
n1@{ icon: "mdi:database", form: "rounded", label: "Fetch All Candidate Records", pos: "b", h: 48 }
n2@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filter High-Score Candidates", pos: "b", h: 48 }
n3@{ icon: "mdi:message-outline", form: "rounded", label: "Send Congratulations Email", pos: "b", h: 48 }
n4["<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/clickup.svg' width='40' height='40' /></div><br/>Create Screening Task in Cli.."]
n3 --> n4
n1 --> n2
n2 --> n3
n0 --> n1
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 decision
class n1 database
classDef customIcon fill:none,stroke:none
class n4 customIcon
The Problem: Shortlisting Turns Into Copy-Paste Chaos
Shortlisting sounds simple until you’re doing it at volume. Someone updates scores in a spreadsheet, then you manually scan rows, decide who “makes the cut,” draft emails, paste a scheduling link, and try to remember to log a task for the team. One interruption and you lose your place. Another common failure: the criteria shifts between roles, so two candidates with the same score get different treatment. And when the next person opens the sheet, they have no idea who was contacted or what was promised.
It adds up fast. Here’s where it usually breaks down.
- You spend about 1–2 hours per hiring round just scanning, sorting, and double-checking rows.
- Emails go out late (or not at all), which means qualified candidates book elsewhere.
- Different people write different messages, so your process feels inconsistent and sloppy.
- Tasks aren’t created reliably, so screenings happen when someone remembers.
The Solution: Auto-Shortlist From Sheets, Email, and Queue Screenings
This workflow gives you a repeatable candidate shortlisting system using tools you already know: Google Sheets, Gmail, ClickUp, and a Calendly link. You run it with a single manual trigger when new candidates have been scored. n8n pulls every row from your “Resume store” sheet, checks each candidate against your threshold (by default, score greater than 70), and only then moves the best-fit profiles forward. For each qualified candidate, it sends a personalized “you’re advancing” email through Gmail, including your scheduling link so they can book immediately. At the same time, it creates a screening task in ClickUp and assigns it to the right person, so follow-up isn’t dependent on memory.
The workflow starts with a batch fetch from Google Sheets. Then it filters for high scores and prepares clean candidate details for messaging. Finally, Gmail sends next steps while ClickUp captures the internal work, and Slack can alert the team if something fails.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you review 40 candidates for a role each week. Manually, you might spend about 2 minutes per candidate to check score, copy their email, paste a template, add your Calendly link, and then create a ClickUp task for the shortlist. If 12 people pass the threshold, that’s roughly 80 minutes of repetitive work, plus the inevitable “did I email them?” double-checking. With this workflow, you update scores in Google Sheets, run the manual trigger, and let n8n handle the filtering, emails, and ClickUp tasks in the background. Your time drops to about 10 minutes to sanity-check the sheet and review results.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets for storing candidate names, scores, and emails.
- Gmail to send next-step emails automatically.
- ClickUp API token (get it from ClickUp Settings → Apps).
Skill level: Beginner. You will connect accounts, paste IDs (Space/Folder/List/Assignee), and edit one email template.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
Manual run when scores are ready. You trigger the workflow after your team has added or updated candidate scores in the “Resume store” Google Sheet.
Candidate data is pulled in one batch. n8n fetches all rows from Sheet2, then tidies up the fields it needs (name, email, score, and any summary text you keep for context).
Filtering happens automatically. An If check compares each candidate’s score to your threshold (70 by default). Only the people who pass get processed further, which keeps your ClickUp lists clean and your inbox from blasting everyone.
Emails and tasks are created together. Gmail sends the advancement message with your Calendly link, and ClickUp gets a screening task assigned to the right owner. If a node errors, Slack can notify you so you’re not guessing why a candidate didn’t move.
You can easily modify the score threshold to match the role, or swap the email copy to fit your brand voice. See the full implementation guide below for customization options.
Common Gotchas
- Google Sheets credentials can expire or need specific permissions. If things break, check the n8n credential connection test and your Sheet sharing access 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.
- ClickUp tasks may fail if your Space/Folder/List IDs are wrong or the token lacks access. Double-check IDs in ClickUp and confirm the assignee is a valid user in that workspace.
Frequently Asked Questions
About 30 minutes if you already have your Sheet, Gmail, and ClickUp ready.
No. You’ll mostly connect accounts and edit a couple of fields like the score threshold and email copy.
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 any ClickUp plan limits you have, but the ClickUp API itself typically doesn’t add a separate per-call fee.
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 you probably should. Change the score cutoff in the If filter (the “score > 70” check), then adjust the fields used in the Set/Edit Fields node if your sheet columns differ by role. Common tweaks include different thresholds for junior vs. senior roles, swapping the Calendly link per hiring manager, and changing who ClickUp tasks get assigned to.
Usually it’s an expired OAuth connection in n8n. Reconnect the Gmail credential, then confirm the sending address matches the account you authorized. If your company uses Google Workspace restrictions, the admin may also block third-party access, so the credential will “connect” but sending still fails.
Hundreds per run is normal.
Often, yes, because this kind of workflow benefits from batch processing and conditional logic. Pulling an entire sheet, filtering by threshold, and then branching into email plus task creation is straightforward in n8n without turning every row into a pile of paid “tasks.” Zapier or Make can still work, but you may end up paying more once you scale beyond a tiny shortlist. n8n also gives you the option to self-host, which changes the math completely. Talk to an automation expert if you want a quick sanity check before you build.
This is the kind of hiring busywork you should only set up once. After that, your shortlist moves on time, every time.
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.
