See llms.txt for all machine-readable content.

Back to Templates

Detect high-velocity hiring signals with Apify, OpenAI, Google Sheets, Slack and Gmail

Created by

Created by: Matt Michels || mattmichels
Matt Michels

Last update

Last update 2 days ago

Categories

Quick Overview

This workflow runs daily to monitor company hiring velocity using an Apify actor, scores and summarizes results with OpenAI, stores them in Google Sheets, and sends hot signals to Slack for approval plus warm signals via Gmail, with a weekly Gmail report and Slack error alerts.

How it works

  1. Runs on a daily schedule (or manually) and loads all settings such as the Apify actor input, scoring thresholds, Google Sheets tab, Slack channel, and email recipient.
  2. Starts the Apify hiring-velocity actor, then waits and polls the Apify Runs API until the run succeeds or fails.
  3. Downloads the Apify dataset results, validates required fields, and deduplicates records against prior runs to avoid repeat alerts.
  4. Computes a rule-based hiring momentum score and then sends each record to OpenAI to generate a structured fit score, summary, outreach angle, and red flags.
  5. Blends the rule score and OpenAI fit score into a final score and tier (hot/warm/cold) and upserts each record into Google Sheets.
  6. Sends hot records to Slack as a single message and waits for an approve/dismiss decision, then writes the review status back to Google Sheets.
  7. Emails a daily Gmail digest for warm records, and on Mondays sends a weekly Gmail report built from the last 7 days of Google Sheets rows.

Setup

  1. Create an Apify token and add an HTTP Header Auth credential (Authorization: Bearer <token>) for the Apify HTTP Request nodes.
  2. Add Google Sheets OAuth credentials, create a spreadsheet with a tab matching the workflow’s columns, and paste the spreadsheet ID and tab name into the Config values.
  3. Add an OpenAI credential (or another supported chat model), and confirm the selected model in the OpenAI chat model configuration.
  4. Add Slack OAuth credentials and set the Slack channel ID in Config (and in the Slack error-alert node if you use a different channel).
  5. Add Gmail OAuth credentials and set the digest recipient email address in Config for the warm digest and weekly report.