See llms.txt for all machine-readable content.

Back to Templates

Find hiring-intent companies weekly with Apify and Google Sheets and log them

Created by

Created by: cleanrowdata || cleanrowdata
cleanrowdata

Last update

Last update a day ago

Categories

Quick overview

This workflow runs every Monday, finds companies currently hiring for selected job functions using Apify, logs new companies to Google Sheets, and optionally looks up work emails for named contacts and posts a weekly summary to Slack.

How it works

  1. Runs every Monday at 8:00 based on a schedule.
  2. Loads your search criteria and reads the existing company domains from Google Sheets to use as a deduplication ledger.
  3. Collects rows in Google Sheets where you entered a contact first/last name and domain but no work email, then sends them to Apify Work Email Finder to retrieve verified or catch-all work emails.
  4. Writes any found emails (or a “not found” status and last-checked date) back to Google Sheets by matching on the company domain.
  5. Calls the Apify Hiring Intent Contacts actor to fetch companies hiring in your chosen locations and time window, including public-site emails and sample job details.
  6. Filters out companies already present in Google Sheets, flags whether only generic inbox emails were found, and appends new companies as new rows.
  7. Builds a weekly run summary and, if enabled, posts it to a Slack channel, while sending a Slack alert and failing the run if the Apify company search fails.

Setup

  1. Create an Apify API token and configure an HTTP Header Auth credential that sends Authorization: Bearer <YOUR_APIFY_TOKEN> for both Apify HTTP requests.
  2. Connect Google Sheets credentials and set the target spreadsheet URL and sheet tab name in the workflow settings, ensuring the tab includes columns like domain, contact name fields, and email/status fields.
  3. (Optional) Add an Abstract Email Validation API key in abstract_api_key if you want Apify Work Email Finder to use it for verification.
  4. (Optional) Connect Slack credentials, set send_slack_summary to true, and choose the target slack_channel for summaries and failure alerts.
  5. Adjust the job functions, locations, time window, and per-run limits in the workflow settings to control volume and cost.