Draft and approve LinkedIn outreach openers with Apify, OpenAI, and Gmail

Quick overview

This workflow runs daily to find public LinkedIn profiles via Apify, drafts a short personalized opener with OpenAI, and sends each draft to you in Gmail for approval before saving approved contacts to Google Sheets.

How it works

1. Runs on a daily schedule.
2. Searches for matching LinkedIn profiles using Apify based on your role query and max results.
3. Filters out profiles with headlines that are too short to personalize from and skips profiles already seen in previous workflow runs.
4. Uses OpenAI to draft a single under-30-word opening line grounded in the person’s LinkedIn headline (or returns “skip” if it can’t be specific).
5. Emails you the drafted opener in Gmail and pauses the workflow until you approve or decline within the configured wait window.
6. Appends approved profiles and their opener to a Google Sheets spreadsheet, while declined items stop with no data saved.

Setup

1. Add credentials for Apify, OpenAI, Gmail, and Google Sheets.
2. Update the search query, what you sell, approver email address, and max items in the configuration step.
3. Select the target Google Sheets document and sheet tab where approved rows should be appended.
4. Run the workflow once manually to confirm you receive approval emails and that approved items are written to the sheet.