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.