This template is perfect for sales teams, marketing professionals, recruiters, and business development specialists who need to efficiently collect targeted lead data from multiple sources. Whether you're building prospect lists, conducting market research, or expanding your contact database, this automated solution saves hours of manual data collection.
The workflow uses an n8n built-in form to collect search parameters, then automatically scrapes targeted leads from Google Maps and/or LinkedIn within Apify Actors based on your criteria. All collected data is cleaned, structured using Edit field nodes, and stored in your Supabase database for easy access and analysis.
Step 1: Set Up Apify Account
Create account at apify.com
Navigate to Settings > Integrations > API tokens
Create new API token and copy it
Ensure you have access to these actors:
LinkedIn Profile Search Scraper (harvestapi/linkedin-profile-search)
Google Maps Scraper (compass/crawler-google-places)
Step 2: Configure Supabase Database
Create new project at supabase.com
Go to SQL Editor in your Supabase dashboard
Run the SQL scripts from the Requirements section to create tables
Navigate to Settings > API to copy:
Project URL (starts with https://...)
Service role key (secret key, not anon public)
Step 3: Import and Configure Workflow
Download the workflow JSON file
In n8n Cloud, go to Workflows > Import from File
Select the downloaded JSON file
Configure credentials by clicking on each node that shows a warning:
For Apify nodes (linkedin_dataset & googlemaps_dataset):
Click "Create New Credential"
Name: "Apify account"
API Token: [Paste your Apify token from Step 1]
Save credential
For Supabase nodes (save_linkedin & save_googlemaps):
Click "Create New Credential"
Name: "Supabase account"
Host: [Your Supabase project URL from Step 2]
Service Role Secret: [Your service role key from Step 2]
Save credential
Step 4: Test the Workflow
Click on the "On form submission" node
Copy the Production URL (webhook link)
Open this URL in a new browser tab
Fill out the test form:
Title/Industry: "restaurants"
Location: "San Francisco, CA"
Source: "Google Maps"
Number of results: "3"
Click Submit and wait for processing
Check your Supabase tables to verify data was saved
Step 5: Verify Setup Success
In Supabase, go to Table Editor
Check the googlemaps table for new entries
Verify all fields are populated correctly
Test with LinkedIn source to confirm both paths work
The workflow is designed to be plug-and-play once credentials are configured. Simply share the form URL with your team or bookmark it for regular lead generation tasks.
How to customize the workflow
Search Parameters:
Modify Apify actor configurations in the dataset nodes
Adjust search query formats for better targeting
Change result limits based on your needs
Data Processing:
Edit the Set nodes to extract additional fields
Add data validation steps
Implement duplicate detection logic
Storage Options:
Replace Supabase with other databases (Airtable, PostgreSQL)
Add data export to CSV/Excel
Implement real-time notifications
Support:
Check n8n community forum for help
Review Apify actor documentation
The workflow is designed to be plug-and-play once credentials are configured. Simply fill out the form with your target criteria and let the automation handle the rest.
External Services: Apify account with credits (for web scraping)
Supabase account (for data storage)
Supabase Table Schemas:
LinkedIn Table (LinkedIn):
publicidentifier (text)
linkedinurl (text)
name (text)
headline (text)
about (text)
premium (boolean)
verified (boolean)
openprofile (boolean)
topskills (text)
connectionscount (integer)
followercount (integer)
latest_experience (text)
education (text)
Google Maps Table (googlemaps):
title (text)
category_name (text)
address (text)
neighborhood (text)
street (text)
city (text)
postal_code (text)
state (text)
country_code (text)
website (text)
phone (text)
phone_unformatted (text)
location (text)
total_score (numeric)
Node Requirements:
Form Customisation:
Search Parameters:
Data Processing:
Storage Options:
Advanced Features:
Let's connect: TUMUSIME David