Discover, enrich, and email LinkedIn leads with Apify, Gmail, Gemini, and Sheets Workflow Solution

Workflow overview

Why this workflow matters

Helpful for business development and pipeline building. Relevant for managed services and support workflows.

Automate LinkedIn lead discovery, enrichment, and email follow-ups using Apify and Google Sheets What this template demonstrates End-to-end lead pipeline (discovery → enrichment → outreach) Google Search–based LinkedIn discovery (safe approach) Batch processing with controlled loops AI-generated cold emails and follow-ups Google Sheets as a structured lead database Use cases B2B outbound lead generation Recruitment sourcing workflows Founder-led sales outreach Building verified prospect lists Automated follow-up systems How it works Reads role + location inputs from Google Sheets Uses Apify to find LinkedIn profiles via Google Search Stores raw leads and filters valid profiles Enriches profiles with additional data Generates personalized email sequences using AI Sends emails and tracks responses Updates lead status to prevent duplicates How to use Add {{APIFY_API_TOKEN}} Connect Google Sheets and Gmail Prepare input sheet (Keyword, Location) Run workflow in test mode Verify outputs in Google Sheets Activate workflow Requirements AlekSystem (cloud or self-hosted) Apify account Google Sheets Gemini / LLM API key Good to know No direct LinkedIn automation (safe and compliant) Email follow-ups include response tracking Uses batching to handle large datasets Google Sheets acts as the system state Customising this workflow Change target roles and locations Improve AI prompts for personalization Add email verification tools Replace Sheets with a database Add retry logic and rate limits What this template demonstrates Multi-step automation architecture API orchestration using HTTP nodes AI integration in workflows Conditional logic and batching Scalable lead processing design

Best fit

Need another direction?