This n8n workflow automates the process of scraping business leads using an Apify actor, cleaning the gathered data, and exporting it into a Google Sheets spreadsheet. It streamlines lead generation by automatically fetching data, formatting key contact details, and storing the results efficiently.
### Workflow Steps:
1. **Manual Trigger:** Initiates the workflow manually.
2. **Set Variables:** Adds your Apify API token and specific task ID as variables.
3. **Run Apify Scraper:** Executes an HTTP request to Apify’s API to run a predefined scraper, retrieving datasets of business leads.
4. **Clean Data:** Processes scraped data by formatting phone numbers to remove non-numeric characters and normalizes emails to lowercase.
5. **Export to Google Sheets:** Appends cleaned data, including company name, phone, and address, to a specified Google Sheet.
### Usage Scenario:
This workflow is ideal for marketing teams or lead generation agencies needing periodic or on-demand data retrieval from web sources without manual intervention. It facilitates continuous updating of lead databases, saving time and reducing errors. Users only need to configure their API tokens and target Google Sheets to automate the entire lead collection pipeline.
Reviews
There are no reviews yet.