How to Automate Leadfeeder to Google Sheets Lead Capture?
Description
Get a clean list of high intent website leads sent to a Google Sheet every morning. Sales and marketing teams get a ready to work list without manual exports or copy paste. The goal is simple. Pull fresh leads, enrich them, qualify them, and save only the best.
A daily schedule starts the run. The setup step stores the account allowlist and the target Google Sheet link. The flow calls the Leadfeeder API to load accounts, splits them, and keeps only the accounts you want. For each account, it fetches yesterday to today leads, splits each lead, and checks engagement. Company domains are sent to Clearbit for enrichment. A second filter keeps firms that match your target profile. Qualified leads are then appended to Google Sheets.
You need a Leadfeeder API token, a Clearbit API key, and Google Sheets access. Expect faster prospecting, better data, and fewer manual steps. Great for account based marketing, B2B teams, and agencies that need a daily list of warm companies. Adjust the schedule, filters, and sheet mapping to match your goals.
Tools Required
What this workflow does?
- Daily schedule trigger runs the process at a set hour
- Setup node stores account allowlist and Google Sheet URL
- HTTP requests pull Leadfeeder accounts and time bound leads
- Split nodes process accounts and individual leads one by one
- Engagement filter keeps only leads that meet activity thresholds
- Clearbit enrichment adds company size, industry and other fields
- Company filter applies firmographic rules before saving
- Google Sheets node appends qualified leads to your sheet
What are the benefits?
- Reduce manual lead research from 2 hours to 10 minutes per day
- Automate 90 percent of data entry into Google Sheets
- Improve data quality by 40 percent with firmographic enrichment
- Handle 5 times more inbound leads without adding headcount
- Connect Leadfeeder, Clearbit and Google Sheets in one flow
- Deliver a qualified lead list by 7 AM to speed follow up
How to set this up?
- Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
- You'll need accounts with Leadfeeder, Clearbit and Google Sheets. See the Tools Required section above for links to create accounts with these services.
- Open the Schedule Trigger node and set the hour you want the run to start. Save the change.
- Set Leadfeeder credentials: double click the Get all Leadfeeder accounts node, select Credential to connect with, click Create new credential, choose HTTP Header Auth, set Header Name to Authorization and Value to Token token=YOUR_API_TOKEN, then save. Use the same credential on the Get Leads node.
- Create Clearbit credentials: double click the Enrich company node, in Credential to connect with click Create new credential, enter your Clearbit API key from the Clearbit dashboard API page, and save.
- Connect Google Sheets: double click the Save leads to Google Sheets node, click Create new credential, choose Google Sheets OAuth2, sign in with the account that owns the target sheet, and approve access.
- Open the Setup node and update the Leadfeeder Accounts array with the exact account names you want. Paste the URL of your Google Sheet into the provided field.
- Adjust filters: open Filter leads by engagement and set your thresholds. Open Filter Leads by company criteria and set rules like employee count or industry.
- Run a test: execute the workflow once. Watch the Split and Filter nodes to confirm items are passing as expected. Check the Enrich company node output for valid domains.
- Open your Google Sheet and confirm that new rows were added with the fields you expect. If no rows appear, review the filter settings and try lower thresholds.
- Troubleshoot common issues: 401 on Leadfeeder means the Authorization header or token is wrong. Empty enrichment means the website domain was missing. Google Sheets write errors often require sharing the sheet with the authorized Google account.
- When everything looks good, activate the workflow so it runs on schedule each day.
Need help or want to customize this?
Ask in the Free Futurise Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
