🎣 Automate job searches with Job Search Global API & Google Sheets
⚡ 1,063 views · 🎣 Lead Generation & Enrichment
💡 Pro Tip — Job boards are notoriously hard to scrape — CAPTCHAs, rate limits, constantly changing layouts. ScraperNode has maintained scrapers for Indeed jobs, Glassdoor reviews, and Glassdoor jobs that handle all of that for you.
Description
Job Search Automation with Job Search Global API & Google Sheet Logging
Description: Automate your job search process by querying the Job Search Global API via RapidAPI every 6 hours for a specified keyword like “Web Developer.” This workflow extracts job listings and saves them directly to Google Sheets, with alerts sent for any API failures.
Workflow Overview
-
Schedule Trigger Runs the workflow automatically every 6 hours to ensure up-to-date job listings.
-
Set Search Term Defines the dynamic job keyword, e.g., “Web Developer,” used in API requests.
-
Fetch Job Listings Sends a POST request to the Job Search Global API (via RapidAPI) to retrieve job listings with pagination.
-
Check API Response Validates the API response status, branching workflow on success or failure.
-
Extract Job Data Parses the job listings array from the API response for processing.
-
Save to Google Sheet Appends or updates job listings in Google Sheets, avoiding duplicates by matching job titles.
-
Send Failure Notification Email Sends an alert email if the API response fails or returns an error.
How to Obtain Your RapidAPI Key (Quick Steps)
- Go to RapidAPI Job Search Global API.
- Sign up or log in to your RapidAPI account.
- Subscribe to the API plan that suits your needs.
- Copy your unique X-RapidAPI-Key from the dashboard.
- Insert this key into your workflow’s HTTP Request node headers.
How to Configure Google Sheets
- Create a new Google Sheet for job listings.
- Share the sheet with your Google Service Account email to enable API access.
- Use the sheet URL in the Google Sheets node within your workflow.
- Map columns correctly based on the job data fields.
Google Sheet Columns Used
| Column Name | Description |
|---|---|
| title | Job title |
| url | Job posting URL |
| company | Company name |
| postDate | Date job was posted |
| jobSource | Source of the job listing |
| slug | Unique job identifier or slug |
| sentiment | Sentiment analysis score (if any) |
| dateAdded | Date the job was added to the sheet |
| tags | Associated tags or keywords |
| viewCount | Number of views for the job post |
Use Cases & Benefits
- Automated Job Tracking: Get fresh job listings without manual searching by automatically querying the Job Search Global API multiple times per day.
- Centralized Job Data: Save and update listings in Google Sheets for easy filtering, sharing, and tracking.
- Failure Alerts: Get notified immediately if API calls fail, helping maintain workflow reliability.
- Customizable Search: Change keywords anytime to tailor job searches for different roles or industries.
Who Is This Workflow For?
- Recruiters looking to monitor job market trends in real-time.
- Job Seekers who want to automate job discovery for specific roles like “Web Developer.”
- HR Teams managing talent pipelines and job postings.
- Data Analysts needing structured job market data for research or reporting.
Create your free n8n account and set up the workflow in just a few minutes using the link below:
Save time, stay consistent, and grow your LinkedIn presence effortlessly!
🔗 Nodes Used
Send Email, Google Sheets, HTTP Request, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File