Automated Job Search Tracker using API and Google Sheets - n8n Workflow

Job seekers who want automatic, continuous updates on new roles.
Recruiters building a centralized database of open positions.
Developers looking for robust n8n templates for scheduled data ingestion and API interaction.
Users needing a continuous, reliable n8n workflow for external API monitoring and spreadsheet management.

This powerful n8n workflow provides a set-and-forget solution for tracking specific job openings across the web. Instead of manually checking job boards, this n8n automation queries the Job Search Global API for a specified keyword (e.g., 'Web Developer') every six hours. The core value of this n8n workflow is its reliability: it uses conditional logic to verify API success. If data is successfully retrieved, the listings are appended or updated in a Google Sheet, preventing duplicate entries. If the API fails, the workflow uses an 'Email Send' n8n node to immediately alert the administrator, ensuring quick resolution and maximizing uptime for your job search efforts. This n8n workflow demonstrates best practices in automation scheduling and error handling.

The n8n workflow begins with the Schedule Trigger n8n node, set to run automatically every six hours. First, the Set Search Term n8n node defines the desired keyword (e.g., "Web Developer").

1. API Call: The flow moves to the Fetch Job Listings n8n node, which sends a POST request to the Job Search Global API, including necessary API credentials (RapidAPI Host and Key) and the defined search term.


2. Conditional Check: The Check API Response If n8n node evaluates the API output. It checks if the response status is successful.


3. Success Path (Data Processing): If successful, the Extract Job Data Code n8n node parses the JSON response to isolate the array of job listings. These records are then passed to the Save to Google Sheet1 Google Sheets n8n node, which performs an appendOrUpdate operation using the job title as the unique identifier to ensure no duplicate entries are logged in the spreadsheet.


4. Failure Path (Error Alert): If the API response check fails, the Send Failure Notification Email n8n node executes, sending a pre-formatted email alert to an administrative address. This immediate notification is crucial for maintaining a reliable n8n workflow.

To install this n8n workflow and run this automation, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON and import it into your n8n instance via the 'New' menu -> 'Import from JSON'.


2. Configure Credentials:

1. Customize Search: Adjust the value in the Set Search Term n8n node to reflect the job title you wish to track.


2. Activate: Save the n8n workflow and activate the Schedule Trigger to start the automation.

Schedule Trigger n8n trigger: Initiates the n8n workflow every 6 hours, providing constant, automatic monitoring.
Set Search Term (Set n8n node): Used to inject the constant search query ("Web Developer") dynamically into the subsequent API request body.
Fetch Job Listings (HTTP Request n8n node): Sends a crucial POST request to the RapidAPI endpoint for job data extraction. Configured with required API keys and search parameters.
Check API Response (If n8n node): Controls the core logic flow. It determines whether the API call was successful, branching the n8n workflow to either process data or send a failure alert.
Extract Job Data (Code n8n node): A custom scripting n8n node used to drill down into the complex JSON response structure and isolate the relevant job listings array ($input.first().json.data.data) for easy ingestion into Google Sheets.
Save to Google Sheet1 (Google Sheets n8n node): Handles the final data storage. The operation is set to Append or Update, using the title column as the match criteria to ensure the n8n workflow efficiently manages job entries without creating duplicates.

• Send Failure Notification Email (Email Send n8n node): Activated only on API failure. Sends a descriptive alert email to ensure immediate attention is given to issues with the external service or credentials.