HttpRequest Automate

Automate lead generation and enrichment with HttpRequest Automate, integrating data from Leadfeeder and Clearbit. This workflow filters leads based on company size and engagement, saving qualified leads directly to Google Sheets. Schedule runs daily to ensure up-to-date insights, enhancing your sales outreach and efficiency.

7/8/2025
15 nodes
Complex
schedulecomplexfilterclearbitsplitoutsticky noteschedule triggergooglesheetsautomationadvancedapiintegrationcron
Categories:
Schedule TriggeredComplex WorkflowData Processing & AnalysisMarketing & Advertising Automation
Integrations:
FilterClearbitSplitOutSticky NoteSchedule TriggerGoogleSheets

Target Audience

This workflow is ideal for:
- Marketing Professionals: Those looking to gather and analyze leads efficiently.
- Sales Teams: Teams that need to filter and enrich leads based on specific criteria to drive sales.
- Data Analysts: Individuals who analyze lead data to derive insights and improve strategies.
- Business Owners: Entrepreneurs wanting to automate lead generation and management processes.

Problem Solved

This workflow addresses the challenge of inefficient lead generation and management. It automates the process of fetching leads from the Leadfeeder API, filtering them based on company size and engagement metrics, enriching the leads with additional information via Clearbit, and saving the results directly into Google Sheets. This ensures that users can focus on high-quality leads without manual intervention.

Workflow Steps

  • Schedule Trigger: The workflow is triggered automatically every day at 7 AM.
    2. Setup Node: Initializes necessary variables like Leadfeeder accounts and Google Sheets URL.
    3. Get all Leadfeeder accounts: Fetches all accounts from Leadfeeder to work with.
    4. Only for wanted accounts: Filters the accounts based on the ones specified in the Setup node.
    5. Get Leads: For each valid account, retrieves leads from Leadfeeder for the past 24 hours.
    6. Filter Leads by company criteria: Filters out leads that do not meet the specified company size (more than 100 employees).
    7. Enrich company: Uses Clearbit to enrich the filtered leads with additional company data.
    8. Filter leads by engagement: Further filters leads based on engagement metrics, ensuring only those with more than 3 visits are considered.
    9. Split Out Leads: Separates the leads into individual items for further processing.
    10. Save leads to Google Sheets: Appends or updates the filtered and enriched leads into the designated Google Sheet.

    • Customization Guide

    To customize this workflow:
    - Adjust the Schedule: Modify the time in the Schedule Trigger node to fit your needs.
    - Change Leadfeeder Accounts: Update the accounts in the Setup node to include or exclude specific Leadfeeder accounts.
    - Modify Filtering Criteria: Alter the employee count and engagement metrics in the Filter nodes to target different lead profiles.
    - Change Google Sheets URL: Update the Google Sheets URL in the Setup node to save leads to a different sheet.
    - Add Additional Enrichment: Incorporate other enrichment services or APIs if needed to gather more data about leads.