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:

1. Takes industry keywords from a form trigger (or you can manually add rows to Google Sheets)
2. Scrapes targeted LinkedIn leads using Apify (peakydev~leads-scraper-ppe actor)
3. Filters for valid emails
4. Automatically creates company + contact records in HubSpot CRM
5. Generates highly personalized, non-salesy cold emails using GPT (tailored to the company’s industry)
6. Logs every lead to Google Sheets with "Pending" status
7. 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

1. Import the workflow into n8n
2. Connect the required credentials:

• Apify API token
• HubSpot App Token (Private App)
• Gmail OAuth2
• Google Sheets OAuth2
• OpenAI API key

1. Replace placeholders:

• Your Google Sheet ID in the “Leads Log” node
• Your name & signature in the AI prompts
• Any test email addresses if needed

1. Activate the main Form Trigger (Lead Campaign Setup) to start campaigns
2. 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! 🪄