How to Track Job Applications from Gmail to Google Sheets with N8n

Workflows > New Workflow

Create New Workflow

Start a fresh N8n workflow for your application tracker. This workflow will monitor Gmail and extract applicant data.

1. 1Click 'New Workflow' in the top right corner
2. 2Name it 'Job Application Tracker' in the workflow title field
3. 3Click the gray '+' node to add your first step

Node Library > Triggers > Gmail

Add Gmail Trigger

Set up the Gmail trigger to monitor for new emails. This will fire every time an email hits your inbox matching specific criteria.

1. 1Click the '+' node and search for 'Gmail'
2. 2Select 'Gmail Trigger' from the results
3. 3Choose 'Message Received' as the trigger event
4. 4Click 'Create New Credential' to connect your Gmail account

Gmail Node > Parameters > Credential

Connect Gmail Account

Authenticate with your Gmail account to allow N8n to read incoming emails. You'll need to authorize N8n through Google's OAuth flow.

1. 1Click 'OAuth2 API' in the credential dropdown
2. 2Click 'Connect my account' and complete Google OAuth
3. 3Return to N8n and click 'Test' to verify connection
4. 4Save the credential with name 'HR Gmail Account'

Gmail Trigger > Parameters > Additional Fields

Configure Email Filters

Set up subject line filters to catch only job application emails. This prevents the workflow from processing every email in your inbox.

1. 1In the Gmail trigger, scroll to 'Additional Fields'
2. 2Click 'Add Field' and select 'Query'
3. 3Enter: subject:(application OR apply OR resume OR "job interest")
4. 4Toggle 'Include Attachments' to true for resume links

Node Library > Data Transformation > Code

Add Data Extraction Node

Insert a Code node to parse email content and extract applicant details. This processes the raw email data into structured fields.

1. 1Click the '+' after Gmail trigger and search 'Code'
2. 2Select 'Code' node from the results
3. 3Set Language to 'JavaScript'
4. 4Paste the extraction code in the code editor

Code Node > JavaScript Code Editor

Configure Data Extraction Code

Add JavaScript code to pull name, email, and other details from email content. This handles parsing both plain text and HTML emails.

1. 1Clear the default code in the editor
2. 2Copy the extraction script from the pro tip section
3. 3Click 'Execute Node' to test the parsing logic
4. 4Verify extracted fields appear in the output panel

Drop this into an n8n Code node.

// Email parsing code for applicant data extraction
const emailData = $input.first().json;
const subject = emailData.subject || '';

// Email parsing code for applicant data extraction
const emailData = $input.first().json;
const subject = emailData.subject || '';
const body = emailData.textPlain || emailData.textHtml || '';
const senderName = emailData.from?.name || emailData.from?.email?.split('@')[0] || 'Unknown';

// Extract resume links from body
const resumeMatch = body.match(/(https?:\/\/(?:drive\.google\.com|dropbox\.com|\.+\.(pdf|doc|docx)))/i);
const resumeLink = resumeMatch ? resumeMatch[0] : '';

// Extract position from subject or body
const positionMatch = subject.match(/(?:for|position|role)\s+(.+?)(?:\s|$)/i) || body.match(/applying for\s+(.+?)(?:\s|\.)/i);
const position = positionMatch ? positionMatch[1].trim() : '';

return [{
  json: {
    applicant_name: senderName,
    applicant_email: emailData.from?.email || '',
    received_date: new Date(emailData.date).toLocaleDateString('en-US'),
    resume_link: resumeLink,
    email_subject: subject,
    position_name: position
  }
}];

Node Library > Productivity > Google Sheets

Connect Google Sheets

Add Google Sheets node to write application data to your tracking spreadsheet. This creates a new row for each applicant.

1. 1Click '+' after the Code node and search 'Google Sheets'
2. 2Select 'Google Sheets' from the app list
3. 3Choose 'Append' as the operation
4. 4Click 'Create New Credential' for Google Sheets access

Google Sheets Node > Credential Configuration

Authenticate Google Sheets

Connect your Google account to enable spreadsheet writing. This uses the same OAuth process but with Sheets permissions.

1. 1Select 'Google Sheets OAuth2 API' credential type
2. 2Click 'Connect my account' and authorize Sheets access
3. 3Test the connection and save as 'HR Sheets Access'
4. 4Return to the node configuration

Google Sheets Node > Parameters > Document Selection

Select Target Spreadsheet

Choose which Google Sheets file and worksheet to update. The spreadsheet should already exist with proper column headers.

1. 1In Document ID field, click the dropdown to browse spreadsheets
2. 2Select 'Job Applications Tracker' (or your spreadsheet name)
3. 3Set Sheet Name to 'Applications' or your worksheet name
4. 4Choose 'A1' as the Data Start Row

Google Sheets Node > Parameters > Values to Send

Map Data Fields

Connect the extracted email data to your spreadsheet columns. This tells N8n which parsed values go in which columns.

1. 1Scroll to 'Values to Send' section
2. 2Click 'Add Value' four times for each column
3. 3Map Name to {{ $node.Code.json.applicant_name }}
4. 4Map Email to {{ $node.Code.json.applicant_email }}
5. 5Map Date to {{ $node.Code.json.received_date }}
6. 6Map Resume Link to {{ $node.Code.json.resume_link }}

Workflow Toolbar > Execute Workflow

Test Complete Workflow

Run the full workflow with a real application email to verify data flows correctly. This catches any mapping or parsing issues.

1. 1Click 'Execute Workflow' button in the top toolbar
2. 2Watch each node execute and check for green success indicators
3. 3Open your Google Sheets to verify new row was added
4. 4Confirm all fields populated with correct applicant data

Workflow Header > Activation Toggle

Activate Workflow

Turn on the workflow to start monitoring for new applications automatically. This switches from manual testing to live automation.

1. 1Click the toggle switch in top right to 'Active'
2. 2Confirm activation in the popup dialog
3. 3Verify 'Active' status appears next to workflow name
4. 4Save the workflow with Ctrl+S or Cmd+S