Track YouTube editor jobs with Apify, Google Sheets, and Gmail

Quick overview

This workflow checks ytjobs.co for new YouTube video editor jobs using Apify, saves and updates listings in a Google Sheets tracker, and sends Gmail digests for high-priority matches and follow-ups based on your pay targets, tools, and application dates.

How it works

1. Runs on a manual start or automatically every 2 hours.
2. Sends your job filters and monitor settings to the Apify YTJobs Scraper actor and waits for the run to finish.
3. Stops with an error if the Apify actor run fails, otherwise fetches the scraped job items from the actor dataset.
4. Reads your existing job tracker from Google Sheets and compares it with the latest results to avoid duplicates.
5. Scores each job against your target hourly rate or minimum project pay and your listed tools, then assigns a verdict and reason.
6. Appends new jobs and updates existing ones in Google Sheets keyed by jobId.
7. Builds an HTML email digest for new jobs with selected verdicts and for applications marked Applied that are due for follow-up, then sends it via Gmail.

Setup

1. Install the Apify community node (if needed) and add an Apify API token credential, then ensure you have access to the getascraper/ytjobs-scraper actor.
2. Create a Google Sheet with a tab named Jobs, add Google Sheets OAuth2 credentials, and replace spreadsheetId and sheetName in the workflow configuration.
3. Add Gmail OAuth2 credentials and set recipientEmail in the workflow configuration to the address that should receive alerts.
4. Edit the workflow configuration values (for example targetHourlyUsd, minProjectPayUsd, myTools, roles, keyword, and followUpAfterDays) to match your preferences before activating the schedule.