See llms.txt for all machine-readable content.

Back to Templates

Score LinkedIn hiring intent and draft account briefs with Apify, OpenAI, and Google Sheets

Created by

Created by: Salih || saliga
Salih

Last update

Last update 9 hours ago

Categories

Quick overview

This workflow runs every morning to scrape new LinkedIn job postings via Apify, score each hiring company’s intent, track results in Google Sheets, and use OpenAI to draft short account briefs for hot accounts, then emails a consolidated HTML alert via Gmail.

How it works

  1. Runs every morning on a schedule trigger.
  2. Calls the Apify LinkedIn Jobs Scraper Actor to find new jobs from the last 24 hours for the configured job titles and locations, grouped by hiring company.
  3. Extracts hiring signals per company (new jobs, distinct titles, seniority, AI roles, remote roles, sample titles, locations, and a recent job link).
  4. Reads the existing company tracker from a Google Sheets “Hiring” tab and merges it with today’s results to calculate running totals, days seen hiring, a 0–100 score, a tier (hot/warm/watch), and score reasons.
  5. Upserts each company back into the Google Sheet using the LinkedIn URL as the unique key.
  6. Keeps only hot-tier companies and sends their hiring signals plus your value proposition to OpenAI to generate a structured brief (why now, angle, opening line, and discovery questions).
  7. Writes the generated brief fields back to the matching rows in Google Sheets and sends a single HTML email via Gmail summarizing all hot companies with their scores, reasons, and briefs.

Setup

  1. Add an Apify API token and configure the HTTP Header Auth so the request includes Authorization: Bearer YOUR_APIFY_TOKEN.
  2. Add an OpenAI API credential for the chat model used to generate the account briefs.
  3. Connect Google Sheets credentials, create a spreadsheet with a “Hiring” sheet that includes a linkedin column, and replace YOUR_SHEET_ID in all Google Sheets nodes.
  4. Connect Gmail credentials and set the recipient email address in the configuration values.
  5. Update the configuration values (job titles, locations, max jobs per search, hot score threshold, monitor name, and “what you sell”) to match your targeting and scoring preferences.

Requirements

  • Apify account with an API token
  • OpenAI API key
  • Google account for Google Sheets and Gmail

Customization

  • Change the scoring weights and the hot threshold in the scoring Code node and the configuration values
  • Edit the brief prompt and the structured output fields to match your sales process
  • Replace the Gmail node with Slack or a CRM node to send hot accounts where your team works