Automated Lead Data Collection from Leadfeeder and Apollo.io

This n8n workflow automates the process of collecting and enriching lead data from Leadfeeder and Apollo.io, then stores the information in Google Sheets for analysis. It is triggered daily at 9 AM, ensuring fresh data collection without manual intervention.

The workflow begins with a schedule trigger set for 9 AM, after which it fetches the Leadfeeder Account ID via an HTTP request. Using this ID, it generates a pagination sequence through a code node to handle API pagination, then processes each page batch-by-batch.

For each page, a request retrieves lead data from Leadfeeder, checks if the last page has been reached, and extracts lead lists accordingly. For the last page and full data sets, the workflow enriches lead information by querying Apollo.io, and then saves the enriched data into Google Sheets.

Special features include a delay node to manage rate limits and an error listener with alert notifications via Telegram in case of failures. This setup is ideal for marketers and sales teams seeking automated, daily updated lead insights to improve targeting and outreach strategies.