Sync job applicants between Google Sheets and Notion and email stage updates with Gmail
Ready for 3.0What 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).
- [cred] Sheets - read new applicants (Google Sheets): uses Google Sheets
- read the previous stage (Data table): get
- [cred] Notion - read existing candidates (Notion): get many (database page)
- store the new stage (Data table): create or update
- drop candidates already in Notion (Code): runs custom JavaScript code
- route by candidate stage (Switch): routes items into branches
- new candidate? (If): checks a condition and branches into true / false
- [cred] Notion - get the stage template (Notion): get many (database page)
- [cred] Notion - add the candidate (Notion): work with database page
- mark the row processed (Code): runs custom JavaScript code
…plus 3 more steps. See the full node list below.
Services it uses
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)
- Notion Trigger
n8n-nodes-base.notionTrigger - Data table
n8n-nodes-base.dataTable - Switch
n8n-nodes-base.switch - Notion
n8n-nodes-base.notion - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Schedule Trigger
n8n-nodes-base.scheduleTrigger
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…