Workflow overview
Why this workflow matters
Helpful for business development and pipeline building. Relevant for managed services and support workflows.
What it does This workflow finds local businesses from Google Maps and automatically enriches them with emails, social profiles, AI summaries, and personalized outreach messages — all saved to Google Sheets. How it works Searches Google Maps using your custom queries Scrapes each business website for emails and contact info Finds missing social profiles (Instagram, Facebook, LinkedIn, Twitter, TikTok, YouTube) Validates emails and removes invalid ones Uses AI to generate a business summary and services list Writes a personalized outreach message for each lead Scores each lead from 0 to 10 based on digital presence Exports everything clean and organized to Google Sheets Who it is for Lead generation agencies Freelancers offering outreach as a service B2B sales and marketing teams Automation consultants Requirements Serper API key Google Sheets OAuth Email validation API Ollama or any LLM endpoint How to set up Connect your credentials in AlekSystem Add your Google Sheet ID to the Sheets node Add your search queries like "bakery in Ohio" or "gyms in Delhi" Hit run and leads start filling your sheet automatically!
Best fit
Categories
Services
Use cases
Need another direction?