Lead Enrichment with Leadfeeder & Clearbit to Google Sheets - n8n Workflow

Sales development representatives (SDRs) needing qualified, enriched lead lists.
Marketing managers focusing on high-intent B2B website traffic.
Users looking for advanced B2B qualification n8n templates.
Business analysts requiring a reliable, scheduled n8n trigger for daily reporting.

• Anyone needing to integrate Leadfeeder data with Clearbit using a custom n8n node setup.

This robust sales automation n8n workflow solves the problem of manually qualifying large volumes of website visitor data. By integrating Leadfeeder and Clearbit, this n8n automation template provides deep insight into high-value B2B prospects. The entire process, driven by multiple sequential n8n node steps, ensures that you only spend time contacting companies that meet both engagement criteria (multiple website visits) and firmographic criteria (large employee count).

This sophisticated n8n workflow starts with a Schedule Trigger, making it entirely hands-off. It dynamically fetches leads, uses the powerful Clearbit n8n node for enrichment, filters out unqualified prospects, and reliably stores the finalized data in Google Sheets, streamlining your lead generation strategy and ensuring that your sales team receives the most actionable intelligence via this customized n8n setup.

The operation of this n8n workflow begins with the Schedule Trigger, initiating the lead generation sequence daily at 7 AM. The process immediately moves to the Setup n8n node, where configuration details like the target Leadfeeder accounts and the specific Google Sheets URL are defined.

The workflow then uses the Leadfeeder API via an HTTP Request n8n node to retrieve all available accounts, which are then filtered using an n8n node to include only the accounts specified in the Setup.

For each selected account, the n8n workflow retrieves leads from the previous day. A primary Filter n8n node analyzes engagement, passing only leads with more than three site visits forward. Next, the crucial data enrichment step occurs: the Clearbit n8n node uses the visitor's website domain to pull comprehensive firmographic data. Finally, a second Filter n8n node applies the company qualification rules, ensuring only leads with over 100 employees are retained. The highly qualified and enriched dataset is then written to your designated Google Sheets document using the final Google Sheets n8n node, completing the daily execution of this n8n workflow.

1. Import the n8n Workflow: Copy the provided JSON code and import it into your n8n instance via the 'Workflows' section.


2. Configure Credentials:

1. Customize the Setup n8n Node: Open the Setup n8n node. Update the array under Leadfeeder Accounts with the exact names of the accounts you wish to track. Replace the placeholder URL in Google Sheets URL with the link to your destination spreadsheet (a template link is provided in the workflow's sticky note).


2. Activate the n8n Trigger: Ensure the Schedule Trigger is enabled to start the daily automation.

Schedule Trigger (n8n trigger): Sets the automation to run every day at 7 AM, acting as the primary n8n trigger for the lead enrichment process.
Set (Setup n8n node): A configuration n8n node used to store dynamic variables like the list of desired Leadfeeder accounts and the Google Sheets destination URL.
HTTP Request (Get Leads): This custom n8n node handles API communication with Leadfeeder, retrieving visitor data for the past 24 hours based on dynamically calculated start and end dates.
Filter (Filter leads by engagement): A core logic n8n node that qualifies leads based on website activity, ensuring only visitors with more than 3 visits are passed forward.
Clearbit (Enrich company n8n node): This specialized n8n node takes the company domain and fetches detailed information (employee count, social handles, description) to enrich the lead data.
Filter (Filter Leads by company criteria): Performs the final qualification filter on the enriched data, checking if the employee count is greater than 100.

• Google Sheets (Save leads to Google Sheets n8n node): The final action n8n node. It connects to Google Sheets using the URL defined in the Setup node and appends all consolidated and highly qualified lead data, completing the execution of the n8n workflow.