📊 Log daily Google Jobs listings to Google Sheets using Apify
⚡ 3 views · 📊 Market Research & Insights
Description
Quick Overview
This workflow runs every morning to search Google Jobs via Apify for a list of job queries and appends the results as dated rows in a Google Sheets spreadsheet.
How it works
- Runs every day at 07:00 on a schedule.
- Defines the job search queries plus the target country and location to search.
- Uses Apify (hirepulse/google-jobs-scraper actor) to scrape Google Jobs for each query and return the dataset results.
- Filters the results to keep only records that include a job title.
- Formats each job into a single Google Sheets row, adding today’s date and fields like company, location, salary, posting age, source, and apply URL.
- Appends the formatted rows to the selected Google Sheets worksheet.
Setup
- Add an Apify connection/credential and ensure you have access to the hirepulse/google-jobs-scraper actor (paid Apify plan may be required for full results).
- Add a Google Sheets OAuth connection and select the target spreadsheet (document ID) and worksheet (sheet name) to append rows to.
- Update the queries, country code, and location values to match the roles and region you want to track.
🔗 Nodes Used
Google Sheets, Schedule Trigger, Filter
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File