Scrape LinkedIn B2B leads with Apify and GPT-4 and approve emails in Sheets

What this workflow does

Fully production-ready B2B lead outreach pipeline that:

Takes industry keywords from a form trigger (or you can manually add rows to Google Sheets) Scrapes targeted LinkedIn leads using Apify (peakydev~leads-scraper-ppe actor) Filters for valid emails Automatically creates company + contact records in HubSpot CRM Generates highly personalized, non-salesy cold emails using GPT (tailored to the company’s industry) Logs every lead to Google Sheets with "Pending" status Waits for human approval or rejection — triggered directly from Google Sheets via two webhooks: Approve (via button/script in sheet) → sends the email via Gmail Reject (via button/script in sheet) → automatically rewrites a softer, more value-focused version with a different angle → updates the same row in the sheet

Why this is useful

Most outreach automations send emails blindly.
This one gives you full control with a human-in-the-loop layer inside Google Sheets + automatic intelligent rewrite on rejection — which greatly improves reply rates, reduces spam complaints, and protects your sender reputation.

Ideal if you: Run outbound campaigns at reasonable scale Already live in Google Sheets for lead review Want clean HubSpot CRM records before sending anything Need traceable approval (who approved what, when) Often hear “too salesy” and want the AI to adapt automatically

How to use

Import the workflow into n8n Connect the required credentials: Apify API token HubSpot App Token (Private App) Gmail OAuth2 Google Sheets OAuth2 OpenAI API key Replace placeholders: Your Google Sheet ID in the “Leads Log” node Your name & signature in the AI prompts Any test email addresses if needed Activate the main Form Trigger (Lead Campaign Setup) to start campaigns Review & act from Google Sheets: Leads appear in your sheet with "Pending" status Use simple buttons or a dropdown + Apps Script (code examples provided in workflow sticky notes) to trigger: Approve → POST to /webhook/approved Reject → POST to /webhook/rejected Required credentials

Apify HubSpot (App Token) Gmail OAuth2 Google Sheets OAuth2 OpenAI

Once set up, you get a beautiful hybrid system: generate leads automatically → review & decide in familiar Google Sheets → one-click action → n8n handles sending or smart rewriting.

Enjoy — and feel free to share your reply rates or any tweaks you make after running a few campaigns! 🪄