LinkedIn Lead Finder & Gemini Outreach with Google Sheets

This workflow streamlines LinkedIn lead generation for sales teams, recruiters, and marketers. It starts with a form submission capturing keywords and outreach purpose, then uses Gemini AI to craft precise Boolean search queries tailored for LinkedIn (e.g., site:linkedin.com). Results from Google Custom Search API (up to 20 leads) are extracted, stored in Google Sheets, and personalized outreach messages are generated via another Gemini call for each lead.

Benefits include massive time savings on manual prospecting, scalable personalized messaging at zero extra effort, and centralized data in Sheets for easy CRM integration or follow-up. No more copy-pasting or generic templates—AI ensures context-aware, purpose-driven messages that boost response rates.

Ideal use cases: Sales pros finding clients via keywords like 'VP Marketing fintech'; recruiters sourcing 'software engineer remote'; founders pitching partners. Setup requires Google Sheets, Custom Search Engine, Gemini API, and optional SMTP. Test with sample inputs and scale effortlessly.

Post-processing updates the sheet with leads and messages, plus email notifications for instant review, making it a complete hands-off pipeline from search to outreach readiness.