Manage recruitment candidates with Google Sheets, Notion and Gmail

Description

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 sends personalized emails when a candidate's recruitment status changes.

How it works
Applications submitted through Google Forms are stored in Google Sheets.
n8n checks for new applications and identifies candidates who haven't been added to Notion yet.
New candidates are automatically added to the Notion Candidates Tracker with their name, email, phone number, role, CV/resume, and initial status.
You can manage each candidate's recruitment stage directly from Notion.
When a candidate's status changes, n8n detects the change and finds the email template configured for that status.
Email templates can use dynamic placeholders such as [Name] to personalize the message.
The personalized email is automatically sent to the candidate through Gmail.

Setup
Set up the n8n data tables (example below)
Set up the provided Notion Recruitment / Applicant Tracking template.
Connect the Google Sheets spreadsheet receiving your Google Forms responses.
Configure your recruitment stages and candidate statuses in Notion.
Create email templates for each recruitment stage.
Customize email subjects and messages using candidate fields such as [Name].
Connect your Gmail account.
Activate the workflow and let n8n automate your recruitment process.

Requirements
n8n datatables
Notion account
Google account / Google Sheets
Gmail account
Notion Recruitment / Applicant Tracking template

Additional info
Notion Data Tables

id: string
notion_id: string
values: string
created_at: datetime
updated_at: datetime

Document Links

Notion Example Link
https://app.notion.com/p/Recruitment-Board-3d12566679c480fcb916d16c014c8197?source=copy_link

Google Sheet Example Link
https://docs.google.com/spreadsheets/d/1mjlkvPr2qX3GMaMLSAFuhJ63ptYhXk_Qtprk7y2YfPg/edit?usp=sharing