What This Workflow Does
This workflow automates getting leads from Leadfeeder, filtering by company size and engagement, adding company info from Clearbit, and saving everything to Google Sheets. It solves the problem of spending hours manually sorting and enriching leads, making the list ready faster and more accurate for sales teams.
It fetches lead data for chosen Leadfeeder accounts within a date range, filters companies with more than 100 employees, keeps leads with over 3 website visits, enriches lead info via Clearbit, and exports the results to a Google Sheets spreadsheet. This saves time and improves lead quality.
Who Should Use This Workflow
Sales managers or sales teams using Leadfeeder to track website visitors can use this workflow to save manual work. Anyone wanting to filter leads by company size and engagement level, enrich data with Clearbit, and output to Google Sheets will find this helpful.
This helps reduce manual downloads, errors, and delays while giving better lead insights.
Tools and Services Used
- Leadfeeder API: Provides accounts and leads data.
- Clearbit API: Enriches lead data with company details like location and social profiles.
- Google Sheets: Saves the filtered and enriched leads for easy team access.
- n8n: Automation platform to build and run the workflow, either cloud or self-host n8n.
How the Workflow Works: Inputs, Process, and Outputs
Inputs
- Leadfeeder API token for accessing accounts and leads.
- Clearbit API key for enriching company data.
- Google Sheets URL and OAuth credentials for saving data.
- List of Leadfeeder account names to monitor.
Processing Steps
- Schedule trigger fires daily at 7 AM to start the workflow.
- Fetch all Leadfeeder accounts via API, then split into individual accounts.
- Filter accounts to only those specified in the setup.
- For each account, retrieve leads from the last day.
- Split leads individually.
- Filter leads where company employee count is above 100.
- Enrich each lead’s company data via Clearbit using their website URL.
- Filter leads with more than 3 website visits.
- Append or update the filtered and enriched leads in Google Sheets.
Output
A Google Sheets document updated every day with high-quality, engaged leads enriched with company details. Sales teams receive fresh data automatically without manual work.
Beginner Step-by-Step: How to Use This Workflow in n8n
Import the Workflow
- Download the workflow using the Download button on this page.
- In the n8n editor, select “Import from File” and upload the downloaded file.
Setup Credentials and Configuration
- Add your Leadfeeder API token in the HTTP Request nodes using HTTP Header Authentication with header name “Authorization” and value format “Token token=yourapitoken”.
- Add your Clearbit API key in the Clearbit node credentials.
- Ensure your Google Sheets OAuth credentials are connected and authorized.
- In the “Setup” node, update the array with your Leadfeeder account names as strings and set the Google Sheets URL where leads should be saved.
Test and Activate
- Run the workflow manually once to check for errors and confirm lead retrieval, filtering, enrichment, and export works.
- If all works, activate the workflow by toggling it on. It will run daily at 7 AM automatically.
Common Problems and How to Fix
- Leadfeeder API 401 Unauthorized: Check API token header name and value format.
- Clearbit authentication error: Verify Clearbit API key is correct and active.
- Google Sheets not updating: Confirm OAuth permission and correct Google Sheets URL.
Customization Ideas
- Change visit threshold in engagement filter node to adjust how interested leads must be.
- Modify company size employee count filter to target smaller or bigger companies.
- Add or remove Leadfeeder account names in the Setup node to expand or reduce lead sources.
- Change Google Sheets URL to save leads to a different spreadsheet or tab.
- Add more Clearbit enrichment fields like social media or tech stack if needed.
Summary
✓ Automates daily fetching of Leadfeeder leads.
✓ Filters leads by employee count and website visits.
✓ Enriches company data using Clearbit API.
✓ Saves updated lead lists to Google Sheets for sales team use.
→ Saves 10+ hours weekly of manual work.
→ Improves lead quality and timely availability.