Templates / Sync job applicants between Google Sheets and Notion and email stage updates with Gmail

Sync job applicants between Google Sheets and Notion and email stage updates with Gmail

Ready for 3.0

by Atharva Ashtekar ✓ · 0 views · created 2026-10-14 · HR

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 16 nodes and runs on a schedule (every second) (plus 2 other triggers). Along the way it connects Notion, Gmail and Google Sheets.

How it runs

Trigger: On a schedule (every second) (plus 2 other triggers).

  1. [cred] Sheets - read new applicants (Google Sheets): uses Google Sheets
  2. read the previous stage (Data table): get
  3. [cred] Notion - read existing candidates (Notion): get many (database page)
  4. store the new stage (Data table): create or update
  5. drop candidates already in Notion (Code): runs custom JavaScript code
  6. route by candidate stage (Switch): routes items into branches
  7. new candidate? (If): checks a condition and branches into true / false
  8. [cred] Notion - get the stage template (Notion): get many (database page)
  9. [cred] Notion - add the candidate (Notion): work with database page
  10. mark the row processed (Code): runs custom JavaScript code

…plus 3 more steps. See the full node list below.

Services it uses

NotionGmailGoogle Sheets

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (10)

From the author

Quick overview This workflow syncs new job applicants from Google Sheets into a Notion candidates database on a schedule, and sends stage-based emails via Gmail when a candidate’s Notion status changes using email templates stored in a separate Notion…

Excerpt from Atharva Ashtekar's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.