Generate Qualified Instagram Leads from Hashtags with Apify and Google Sheets

Description

Instagram Hashtag Lead Generation

Automate the process of finding and qualifying Instagram leads based on hashtags. This workflow reads hashtags from Google Sheets, scrapes Instagram for posts using Apify, analyzes caption content and language, compiles unique usernames, gathers detailed user info, and filters leads based on follower count.

How It Works

Fetch Hashtags
The workflow starts and pulls a list of hashtags from a Google Sheet.

Scrape Instagram Posts
For each hashtag, it builds Instagram explore URLs and scrapes posts using Apify.

Analyze Captions
Each caption is cleaned, hashtags and links are removed, and language/content is analyzed (English/French/Spanish).

Extract & Filter Usernames
Usernames are combined and deduplicated, their Instagram profiles scraped for follower counts and other details.

Qualified Leads
Only users with followers in your target range are kept as qualified leads for outreach or analysis.

Requirements

An n8n instance.
Apify API key.
Google account with a Sheet containing hashtags.
Apify Instagram Scraper actor access.
The Google Sheet should have a column with hashtags.

Setup Instructions

Add Credentials
In n8n, add your Apify API key and Google Sheets credentials.

Configure Google Sheets Nodes
Choose your credentials, spreadsheet, and sheet name in the “Get list of Hashtags” node.

Configure Apify Request Nodes
Enter your Apify API key and select the Instagram scraper actors.

Adjust Filtering
Edit the min/max follower count in the relevant filter node to match your needs.

Test & Run
Manually execute the workflow or add a trigger to run on a schedule.

Customization Options 💡

Trigger:** Add a schedule or webhook to automate execution.
Language Filtering:** Modify keyword lists or add language detection logic.
Lead Output:** Extend the workflow to save leads to a CRM or send notifications.

Details

Nodes used in workflow:
Manual Trigger
Google Sheets
Code
HTTP Request (Apify)
IF (Conditional)
Aggregate
Remove Duplicates
Sticky Note