Build Your Own AI Lead Gen Agent (n8n + Apify/Google Sheets) | Free
Implementation Steps:
Phase 1: Workflow Setup & Input
Create a new n8n workflow and add a Form Trigger node.
Define fields for "Who are you looking for?" (e.g., Dentist) and "Location" (e.g., Pune).
Execute the node with sample data to activate the variables.
Phase 2: Connecting Apify
Sign up at Apify, go to the Console, and generate an API token.
Select the Google Search Scraper in the Apify Store.
In the API tab, copy the "Run actor synchronously" URL.
In n8n, use an HTTP Request node (Method: POST) and paste the URL.
Paste the JSON payload from Apify into the Send Body section.
Update the queries field to: site:instagram.com {{ $json.profession }} {{ $json.location }}.
Phase 3: Data Processing
Add a Wait node (5-10 seconds) to ensure the scraper completes.
Copy the raw JSON output and ask ChatGPT to generate a JavaScript Code Node to parse the fields (Name, Username, URL, Description, Followers).
Paste this code into an n8n Code node.
Phase 4: Database Integration
Set up an Airtable base with fields for Name, Username, Handle, Description, and Followers.
Use the Airtable node in n8n set to Create a Record.
Map the output from the Code node to your Airtable columns.
Phase 5: Filtering & Scaling
Inside Airtable, use Filters to create specific views for "All," "Reels," and "Posts."
To generate new leads, simply re-run the form with different profession/location inputs.