Qualify LinkedIn leads with Apify, OpenAI, and Google Sheets

Quick overview

This workflow runs on a schedule to search LinkedIn profiles via Apify, uses an OpenAI chat model to score each profile’s fit and draft a personalized opener, and appends the scored leads (with reasoning and risk notes) to Google Sheets.

How it works

1. Runs on a weekly schedule trigger.
2. Defines your target search query, locations, customer description, and maximum number of results to fetch.
3. Uses Apify’s LinkedIn Profile Search Scraper actor to retrieve matching LinkedIn profiles.
4. Filters out profiles missing key information (for example, a headline) so only judgeable profiles continue.
5. Skips profiles that were already processed in previous runs to avoid re-scoring duplicates.
6. Sends each remaining profile to an OpenAI chat model to return a JSON score (1–5), a quoted reason, a risk note, and a profile-grounded opening line.
7. Appends the scored lead details to a Google Sheets worksheet for review and outreach.

Setup

1. Add an Apify API token credential and ensure the workflow can run the dami_studio/linkedin-profile-search-scraper actor within your Apify account limits.
2. Add an OpenAI API key credential for the chat model used to score and draft openers.
3. Connect Google Sheets credentials and set the target spreadsheet ID and worksheet name in the append step.
4. Update the target persona fields (search query, locations, customer description, and max items) to match your ideal customer profile.