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 ano...
Template notes
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.