Automated job applications & status tracking with LinkedIn, Indeed & Google Sheets

Apply to jobs automatically from Google Sheets with status tracking Who's it for Job seekers who want to streamline their application process, save time on repetitive tasks, and never miss following up on applications. Perfect for anyone managing multiple job applications across different platforms. What it does This workflow automatically applies to jobs from a Google Sheet, tracks application status, and keeps you updated with notifications. It handles the entire application lifecycle from submission to status monitoring. Key features: - Reads job listings from Google Sheets with filtering by priority and status - Automatically applies to jobs on LinkedIn, Indeed, and other platforms - Updates application status in real-time - Checks application status every 2 days and notifies you of changes - Sends email notifications for successful applications and status updates - Prevents duplicate applications and manages rate limiting How it works The workflow runs on two main schedules: Daily Application Process (9 AM, weekdays): 1. Reads your job list from Google Sheets 2. Filters for jobs marked as "Not Applied" with Medium/High priority 3. Processes each job individually to prevent rate limiting 4. Applies to jobs using platform-specific APIs (LinkedIn, Indeed, etc.) 5. Updates the sheet with application status and reference ID 6. Sends confirmation email for each application Status Monitoring (Every 2 days at 10 AM): 1. Checks all jobs with "Applied" status 2. Queries job platforms for application status updates 3. Updates the sheet if status has changed 4. Sends notification emails for status changes (interviews, rejections, etc.) Requirements - Google account with Google Sheets access - Gmail account for notifications - Resume stored online (Google Drive, Dropbox, etc.) - API access to job platforms (LinkedIn, Indeed) - optional for basic version - n8n instance (self-hosted or cloud) How to set up Step 1: Create Your Job Tracking Sheet Create a Google Sheet with these exact column headers: | JobID | Company | Position | Status | AppliedDate | LastChecked | ApplicationID | Notes | JobURL | Priority | |--------|---------|----------|--------|--------------|--------------|----------------|-------|---------|----------| | JOB001 | Google | Software Engineer | Not Applied | | | | | https://careers.google.com/jobs/123 | High | | JOB002 | Microsoft | Product Manager | Not Applied | | | | | https://careers.microsoft.com/jobs/456 | Medium | Column explanations: - JobID: Unique identifier (JOB001, JOB002, etc.) - Company: Company name - Position: Job title - Status: Not Applied, Applied, Under Review, Interview Scheduled, Rejected, Offer - AppliedDate: Auto-filled when application is submitted - LastChecked: Auto-updated during status checks - ApplicationID: Platform reference ID (auto-generated) - Notes: Additional information or application notes - JobURL: Direct link to job posting - Priority: High, Medium, Low (Low priority jobs are skipped) Step 2: Configure Google Sheets Access 1. In n8n, go to Credentials → Add Credential 2. Select Google Sheets OAuth2 API 3. Follow the OAuth setup process to authorize n8n 4. Test the connection with your job tracking sheet Step 3: Set Up Gmail Notifications 1. Add another credential for Gmail OAuth2 API 2. Authorize n8n to send emails from your Gmail account 3. Test by sending a sample email Step 4: Update Workflow Configuration In the "Set Configuration" node, update these values: - spreadsheetId: Your Google Sheet ID (found in the URL) - resumeUrl: Direct link to your resume (make sure it's publicly accessible) - yourEmail: Your email address for notifications - coverLetterTemplate: Customize your cover letter template Step 5: Customize Application Logic For basic version (no API access): The workflow includes placeholder HTTP requests that you can replace with actual job platform integrations. For advanced version (with API access): - Replace LinkedIn/Indeed HTTP nodes with actual API calls - Ad