Automate Job Search & Curation with JSearch API & Google Sheets

How it works This workflow automates the job curation process by retrieving pending job search inputs from a spreadsheet, querying the JSearch API for relevant job listings, and writing the curated results back to another sheet. It is designed to streamline job discovery and reduce manual data entry.

Step-by-step

1. Trigger & Input The workflow starts on a defined schedule (e.g., once per day).

It reads a row from the Job Scraper sheet where the status is marked as "Pending".

The selected row includes fields like Position and Location, which are used to build the search query.

2. Job Search & Processing Sends a search request to the JSearch API using the Position and Location from the spreadsheet.

Parses the API response and extracts individual job listings.

Filters out empty, irrelevant, or invalid entries to ensure clean and relevant job data.

3. Output & Status Update Writes valid job listings to the Job Listing output sheet with fields such as job title, company name, location, and more.

Updates the original row in the source sheet to mark it as Scraped, ensuring it will not be processed again in future runs.

Benefits Reduces manual effort in job research and listing.

Ensures only valid, structured data is stored and used.

Prevents duplicate processing with automatic status updates.

Simple to expand by adding more job sources or filters.