Javier Hita
Workflows by Javier Hita
Extract business contact leads from Google Maps with RapidAPI and Google Sheets
[**Follow me on LinkedIn for more!**](https://www.linkedin.com/in/javier-hitavb/) **Category:** Lead Generation, Data Collection, Business Intelligence **Tags:** lead-generation, google-maps, rapidapi, business-data, contact-extraction, google-sheets, duplicate-prevention, automation **Difficulty Level:** Intermediate **Estimated Setup Time:** 15-20 minutes ## Template Description ### Overview This powerful n8n workflow automates the extraction of comprehensive business information from Google Maps using keyword-based searches via RapidAPI's Local Business Data service. Perfect for **lead generation**, **market research**, and **competitive analysis**, this template intelligently gathers business data including contact details, social media profiles, and location information while preventing duplicates and optimizing API usage. ### Key Features - **🔍 Keyword-Based Google Maps Scraping**: Search for any business type in any location using natural language queries - **📧 Contact Information Extraction**: Automatically extracts emails, phone numbers, and social media profiles (LinkedIn, Instagram, Facebook, etc.) - **🚫 Smart Duplicate Prevention**: Two-level duplicate detection saves 50-80% on API costs by skipping processed searches and preventing duplicate business entries - **📊 Google Sheets Integration**: Seamless data storage with automatic organization and structure - **🌍 Multi-Location Support**: Process multiple cities, regions, or countries in a single workflow execution - **⚡ Rate Limiting & Error Handling**: Built-in delays and error handling ensure reliable, uninterrupted execution - **💰 Cost Optimization**: Intelligent batching and duplicate prevention minimize API usage and costs - **📱 Comprehensive Data Collection**: Gather business names, addresses, ratings, reviews, websites, verification status, and more ### Prerequisites #### Required Services & Accounts 1. **RapidAPI Account** with subscription to ["Local Business Data" API](https://rapidapi.com/letscrape-6bRBa3QguO5/api/local-business-data) 2. **Google Account** for Google Sheets integration 3. **n8n Instance** (cloud or self-hosted) #### Required Credentials - **RapidAPI HTTP Header Authentication** for Local Business Data API - **Google Sheets OAuth2** for data storage and retrieval ### Setup Instructions #### Step 1: RapidAPI Configuration 1. **Create RapidAPI Account** - Sign up at [RapidAPI.com](https://rapidapi.com) - Navigate to "Local Business Data" API - Subscribe to a plan (Basic plan supports 1000 requests/month) 2. **Get API Credentials** - Copy your `X-RapidAPI-Key` from the API dashboard - Note the host: `local-business-data.p.rapidapi.com` 3. **Configure n8n Credential** - In n8n: Settings → Credentials → Create New - Type: HTTP Header Auth - Name: `RapidAPI Local Business Data` - Add headers: - `X-RapidAPI-Key`: `YOUR_API_KEY` - `X-RapidAPI-Host`: `local-business-data.p.rapidapi.com` #### Step 2: Google Sheets Setup 1. **Enable Google Sheets API** - Go to [Google Cloud Console](https://console.cloud.google.com) - Enable Google Sheets API for your project - Create OAuth2 credentials 2. **Configure n8n Credential** - In n8n: Settings → Credentials → Create New - Type: Google Sheets OAuth2 API - Follow OAuth2 setup process 3. **Create Google Sheet Structure** Create a new Google Sheet with these tabs: **keyword_searches** sheet: ``` | select | query | lat | lon | country_iso_code | |--------|-------|-----|-----|------------------| | X | Restaurants Madrid | 40.4168 | -3.7038 | ES | | X | Hair Salons Brooklyn | 40.6782 | -73.9442 | US | | X | Coffee Shops Paris | 48.8566 | 2.3522 | FR | ``` **stores_data** sheet: ``` The workflow will automatically create columns for business data including: business_id, name, phone_number, email, website, full_address, rating, review_count, linkedin, instagram, query, lat, lon, and 25+ more fields ``` #### Step 3: Workflow Configuration 1. **Import the Workflow** - Copy the provided JSON - In n8n: Import from JSON 2. **Update Placeholder Values** - Replace `YOUR_GOOGLE_SHEET_ID` with your actual Google Sheet ID - Update credential references to match your setup 3. **Configure Search Parameters** (Optional) - Adjust `limit`: 1-100 results per query (default: 100) - Modify `zoom`: 10-18 search radius (default: 13) - Change `language`: EN, ES, FR, etc. (default: EN) ### How It Works #### Workflow Process 1. **Load Search Criteria**: Reads queries marked with "X" from `keyword_searches` sheet 2. **Load Existing Data**: Retrieves previously processed data for duplicate detection 3. **Filter New Searches**: Smart merge identifies only new query+location combinations 4. **Process Each Location**: Sequential processing prevents API overload 5. **Configure Parameters**: Prepares search parameters from sheet data 6. **API Request**: Calls RapidAPI to extract business information 7. **Parse Data**: Structures and cleans all business information 8. **Save Results**: Stores new leads in `stores_data` sheet 9. **Rate Limiting**: 10-second delay between requests 10. **Loop**: Continues until all new searches are processed #### Duplicate Prevention Logic **Search Level**: Compares new queries against existing data using query+latitude combination, skipping already processed searches. **Business Level**: Each business receives a unique `business_id` to prevent duplicate entries even across different searches. ### Data Extracted #### Business Information - Business name, full address, phone number - Website URL, Google My Business rating and review count - Business type, price level, verification status - Geographic coordinates (latitude/longitude) - Detailed location breakdown (street, city, state, country, zip) #### Contact Details - Email addresses (when publicly available) - Social media profiles: LinkedIn, Instagram, Facebook, Twitter, YouTube, TikTok, Pinterest - Additional phone numbers - Direct Google Maps and reviews links #### Search Metadata - Original search query and parameters - Extraction timestamp and geographic data - API response details for tracking ### Use Cases #### **Lead Generation** - Generate targeted prospect lists for B2B sales - Build location-specific customer databases - Create industry-specific contact lists - Develop territory-based sales strategies #### **Market Research** - Analyze competitor density in target markets - Study business distribution
Find LinkedIn professionals with Google Search and Airtable
# Find LinkedIn Professionals with Google Search and Airtable ## Who is this for? This workflow is perfect for **sales professionals**, **recruiters**, **business development teams**, and **marketers** who need to build targeted prospect lists from LinkedIn. Whether you're looking for specific job titles, industry professionals, or experts in particular locations, this template automates the tedious process of manual LinkedIn searching. [**Follow me for more**](https://www.linkedin.com/in/javier-hitavb/) ## What problem is this workflow solving? Finding qualified prospects on LinkedIn manually is time-consuming and inefficient. Traditional methods involve: - Manually searching LinkedIn with limited search capabilities - Copy-pasting profile information one by one - Struggling with LinkedIn's search limitations and restrictions - Difficulty organizing and tracking prospect data - No systematic way to avoid duplicate contacts This workflow solves these challenges by leveraging Google's powerful search capabilities to find LinkedIn profiles at scale, automatically extracting key information, and organizing everything in a structured database. ## What this workflow does The workflow performs intelligent LinkedIn prospect discovery through these key steps: 1. **Keyword-Based Search**: Uses Google Custom Search API to find LinkedIn profiles matching your specific criteria (job titles, industries, locations) 2. **Smart Data Extraction**: Automatically parses profile titles, descriptions, URLs, and search snippets from Google results 3. **Structured Storage**: Saves all prospect data to Airtable with proper field mapping and automatic deduplication 4. **Pagination Handling**: Automatically processes multiple pages of search results to maximize prospect discovery 5. **Rate Limiting**: Includes built-in delays to respect API limits and ensure reliable operation Key features: - **Deduplication**: Prevents storing duplicate LinkedIn profiles - **Batch Processing**: Handles large prospect lists efficiently - **Customizable Search**: Easily modify keywords to target different professional segments - **Clean Data Output**: Structured data ready for outreach campaigns ## Setup ### Prerequisites You'll need accounts with the following services: - **Google Cloud Console** (for Custom Search API) - **Airtable** (free tier works) - **n8n** (cloud or self-hosted) ### Step 1: Google Custom Search Setup 1. Go to [Google Cloud Console](https://console.cloud.google.com/) 2. Create a new project or select existing one 3. Enable the **Custom Search API** 4. Create credentials (API Key) 5. Set up a Custom Search Engine at [Google CSE](https://cse.google.com/) 6. Configure it to search the entire web 7. Copy your **Search Engine ID** (cx parameter) *Bonus*: **[Youtube Set-up Guide](https://www.youtube.com/watch?v=oFH5RqqjOWk&t=228s)** ### Step 2: Airtable Base Setup Create a new Airtable base with a table named **"LinkedIn Prospects"** containing these fields: ``` - Title (Single line text) - LinkedIn profile headline - linkedin_url (URL) - Direct link to LinkedIn profile - Search (Single line text) - Original search terms used - Description (Long text) - Profile description/summary - Snippet (Long text) - Google search result snippet ``` ### Step 3: n8n Credentials Configuration Set up these credentials in n8n: **Google Custom Search API:** - Type: HTTP Query Auth - Name: `Google Query Auth` - Query Parameter Name: `key` - Value: Your Google API key **Airtable:** - Type: Airtable Personal Access Token - Token: Your Airtable personal access token - Configure the base and table IDs in the Airtable node ### Step 4: Workflow Configuration 1. Import this workflow template 2. Update the **"⚙️ CUSTOMIZE YOUR SEARCH KEYWORDS HERE"** node with your target keywords 3. Configure the Airtable node with your base and table information 4. Test the workflow with a small keyword set first ## How to customize this workflow to your needs ### Targeting Different Industries Modify the search keywords in the yellow configuration node: ```javascript // For technology professionals "Software Engineer React" "Product Manager SaaS" "Data Scientist Machine Learning" // For sales professionals "Account Executive Enterprise" "Sales Director B2B" "Business Development Manager" // For marketing professionals "Digital Marketing Manager" "Content Marketing Specialist" "Growth Marketing Lead" ``` ### Geographic Targeting Add location keywords to narrow your search: ```javascript "Marketing Manager London" "Sales Director New York" "Software Engineer Berlin" ``` ### Company Size Targeting Include company type indicators: ```javascript "CFO Startup" "VP Engineering Fortune 500" "Marketing Director SMB" ``` ### Adjusting Search Volume Modify the `Maxresults` parameter in the **"Configure Search Settings"** node: - Set to `10` for quick tests - Set to `50-100` for comprehensive searches - Maximum recommended: `100` per search to respect API limits ### Industry-Specific Customization **For Recruiters:** - Target specific job titles and seniority levels - Add skills-based keywords ("Python Developer", "React Specialist") - Include experience indicators ("Senior", "Lead", "Principal") **For Sales Teams:** - Focus on decision-maker titles ("Director", "VP", "C-Level") - Target specific company sizes or industries - Include location-based searches for territory management **For Marketers:** - Search for industry influencers and thought leaders - Target specific professional communities - Look for content creators and industry experts ### Advanced Filtering Add conditional logic after the search results to filter prospects based on: - Profile description keywords - Title patterns - Company information (when available in snippets) ### Integration Extensions Connect additional tools to enhance your prospect research: - **Email finder tools** (Hunter.io, Apollo) for contact discovery - **CRM integration** (HubSpot, Salesforce) for automatic lead creation - **Enrichment services** (Clearbit, ZoomInfo) for additional prospect data - **Slack/Teams notifications** for real-time prospect alerts ### Data Quality Improvements Enhance the workflow with additional processing: - **Duplicate detection** across multiple search terms - **Profile validation** to ensure active LinkedIn profiles - **Keyword scoring** to rank prospect relevance - **Export formatting** for specific CRM requirements This template provides a solid foundation that can be adapted for virtually any B2B prospect research need, making it an essential tool for modern sales and marketing teams.
Generate qualified leads from LinkedIn with Apify, GPT-4, and Airtable
## Who is this for? This workflow is perfect for **sales teams**, **business development professionals**, **recruitment agencies**, and **fractional CFO service providers** who need to identify and qualify companies actively hiring. Whether you're prospecting for new clients, building a database of potential customers, or researching market opportunities, this automated solution saves hours of manual research while delivering high-quality, AI-analyzed leads. ## What problem is this workflow solving? Finding qualified prospects in the finance sector is time-consuming and often inefficient. Traditional methods involve: - Manually browsing LinkedIn job postings for hours - Difficulty distinguishing between genuine opportunities and recruitment spam - Inconsistent lead categorization and qualification - Risk of contacting the same companies multiple times - Lack of structured data for sales team follow-up This workflow automates the entire lead generation process, from data collection to AI-powered qualification, ensuring you focus only on the most promising opportunities. ## What this workflow does This comprehensive lead generation system performs six key functions: 1. **Automated LinkedIn Job Scraping**: Uses Apify's reliable LinkedIn Jobs Scraper to extract detailed job postings for finance positions, including company information, job descriptions, and contact details. 2. **Smart Data Processing**: Removes duplicates, filters companies by size, and structures data for consistent analysis across all leads. 3. **Intelligent Lead Categorization**: Compares new leads against your existing database to optimize processing and avoid duplicate work. 4. **AI-Powered Qualification**: Leverages OpenAI's GPT-4 Mini to analyze each lead and determine: - **Company Category**: Consumer companies, Fractional CFO services, Recruiting agencies, or Other - **Finance Role Validation**: Confirms the position is genuinely finance-related - **Seniority Level**: Entry, Mid, Senior, Director, or C-Level classification - **Job Summary**: Concise description for quick sales team review 5. **Automated Database Management**: Stores qualified leads in Airtable with comprehensive profiles, preventing duplicates while maintaining data integrity. 6. **Lead Scoring & Routing**: Prioritizes leads based on processing status and qualification results for efficient sales team follow-up. ## Setup ### Prerequisites You'll need accounts for three services: - **Airtable** (Free tier supported) - For lead storage and management - **Apify** (14-day free trial available) - For LinkedIn job scraping - **OpenAI** (Pay-per-use) - For AI-powered lead analysis ### Step 1: Create Required Credentials #### Apify API Credential 1. Sign up for an Apify account at [apify.com](https://apify.com) 2. Navigate to Settings → Integrations → API tokens 3. Create a new API token 4. In n8n, create a new **Apify API** credential with your token #### OpenAI API Credential 1. Create an account at [platform.openai.com](https://platform.openai.com) 2. Generate an API key in the API section 3. In n8n, create a new **OpenAI** credential with your key #### Airtable Personal Access Token 1. Go to [airtable.com/create/tokens](https://airtable.com/create/tokens) 2. Create a personal access token with the following scopes: - `data.records:read` - `data.records:write` - `schema.bases:read` 3. In n8n, create a new **Airtable Personal Access Token** credential ### Step 2: Set Up Airtable Base Create a new Airtable base with the following structure: **Table Name**: `Qualified Leads` **Required Fields**: ``` - Company Name (Single line text) - Job Title (Single line text) - Is Finance Job (Checkbox) - Seniority Level (Single select: Entry, Mid, Senior, Director, C-Level) - Company Category (Single select: Consumer, Recruiting, Fractional CFO, Other) - Job Summary (Long text) - Company LinkedIn (URL) - Job Link (URL) - Posted Date (Date) - Location (Single line text) - Industry (Single line text) - Company Employees (Number) ``` ### Step 3: Configure the Workflow 1. **Import the Workflow**: Copy the JSON and import it into your n8n instance 2. **Update Credentials**: Replace placeholder credential IDs with your actual credential IDs in: - "Scrape LinkedIn Jobs" node (Apify credential) - "OpenAI GPT-4 Mini" node (OpenAI credential) - "Save to Airtable" and "Get Existing Leads" nodes (Airtable credential) 3. **Configure Airtable Connection**: Update the base ID and table ID in both Airtable nodes 4. **Set Search Parameters**: In the "Edit Variables" node, configure: - `linkedinUrls`: Your target LinkedIn job search URLs - `maxEmployees`: Maximum company size filter (default: 200) - `batchSize`: Processing batch size for API efficiency (default: 5) ### Step 4: Test the Workflow 1. Start with a small test by setting `count: 50` in the HTTP Request node 2. Use a specific LinkedIn job search URL (e.g., "CFO jobs in New York") 3. Execute the workflow manually and verify results in your Airtable base 4. Review the AI categorization accuracy and adjust prompts if needed ## How to customize this workflow to your needs ### Targeting Different Roles Modify the LinkedIn search URLs in the "Edit Variables" node to target different positions: ``` - "https://www.linkedin.com/jobs/search/?keywords=Controller" - "https://www.linkedin.com/jobs/search/?keywords=Finance%20Director" - "https://www.linkedin.com/jobs/search/?keywords=VP%20Finance" ``` ### Adjusting Company Size Filters Change the `maxEmployees` parameter to focus on different company segments: - Startups: 1-50 employees - SMBs: 51-500 employees - Enterprise: 500+ employees ### Customizing AI Analysis Enhance the GPT-4 prompt in the "AI Lead Analyzer" node to include: - Industry-specific criteria - Geographic preferences - Technology stack requirements - Company growth stage indicators ### Integration Options Extend the workflow by adding: - **Slack notifications** for new qualified leads - **Email alerts** for high-priority prospects - **CRM integration** (Salesforce, HubSpot, Pipedrive) - **Lead enrichment** with additional data sources ### Scheduling Automation Set up the workflow to run automatically: - **Daily**: For active prospecting campaigns - **Weekly**: For ongoing market research - **Monthly**: For periodic database updates ## Performance & Cost Optimization - **API Efficiency**: The workflow processes leads in batches to optimize API usage - **Smart Deduplication**: Avoids re-processing existing leads to reduce costs - **Configurable Limits**: Adjust batch sizes and employee count filters based on your needs - **Expected Costs**: Approximately $0.05-$0.20 per 100 analysed leads (OpenAI costs) ## Troubleshooting **Common Issues**: - **Rate Limiting**: Increase delays between API calls if you encounter rate limits - **Data Quality**: Review LinkedIn search URLs for relevance to your target market - **AI Accuracy**: Adjust prompts if categorisation doesn't match your criteria - **Airtable Errors**: Verify field names match exactly between workflow and base structure **Support Resources**: - [Apify LinkedIn Scraper Documentation](https://apify.com/curious_coder/linkedin-jobs-scraper) - [OpenAI API Documentation](https://platform.openai.com/docs) - [Airtable API Reference](https://airtable.com/developers/web/api/introduction) Transform your lead generation process with this powerful, AI-driven workflow that delivers qualified prospects ready for immediate outreach.