Manage recruitment candidates with Google Sheets, Notion and Gmail
Ready for 3.0What this workflow does
This workflow has 16 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Notion, Gmail and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).
- Get new applicants (Google Sheets): uses Google Sheets
- Get old state (Data table): get
- Get many database pages (Notion): get many (database page)
- Save new state (Data table): create or update
- Filter candidates not in lists (Code): runs custom JavaScript code
- Switch: routes items into branches
- Check if need insert (If): checks a condition and branches into true / false
- Get email template (Notion): get many (database page)
- Create a database page (Notion): work with database page
- Data 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 n8n template automates repetitive recruitment tasks by connecting Google Forms, Notion, and Gmail into one recruitment workflow. It collects new applications, adds candidates to a Notion Applicant Tracking System (ATS), and automatically…