n8n-workflow-project-lists

### **n8n Workflow: AI-Powered Social Media Lead Scraper**

**Overview:** This workflow automates the extraction of potential leads from Twitter (X) based on industry keywords and engagement metrics. It filters users who match your ideal customer profile (ICP) and exports their details to a Google Sheet for follow-up.

**Workflow Steps:**
1. **Trigger:** Webhook (manual or scheduled).
2. **Search Twitter:** Uses the Twitter API to fetch tweets containing keywords like "#SaaS" or "#MarketingAutomation" from the last 7 days.
3. **Filter & Analyze:** AI agent (via n8n's AI node) evaluates tweet sentiment and user engagement (likes, replies, retweets). Only users with >50 followers and positive sentiment are retained.
4. **Enrich Data:** Calls a LinkedIn API (or Hunter.io) to fetch user profiles and company details for the filtered users.
5. **Export to Google Sheets:** Appends the enriched data (name, handle, company, email if available, engagement score) to a Google Sheet titled "Twitter Leads - [DATE]."
6. **Notification:** Sends a Slack message to the sales team with a summary of new leads (e.g., "12 new leads added to the pipeline today!").

**Error Handling:**
- If the Twitter API fails, the workflow retries 3 times with exponential backoff.
- Invalid email formats are flagged and logged for manual review.

**Dependencies:**
- Twitter API (v2) with elevated access.
- Google Sheets API (with write permissions).
- LinkedIn API or Hunter.io (for enrichment).
- n8n AI node (for sentiment analysis).

**Testing Data:**
- Input: Keywords = ["#SaaS", "#MarketingAutomation"], Timeframe = Last 7 days.
- Expected Output: 5-10 high-quality leads per run, with 80% accuracy in sentiment scoring.

**Deployment Guide:**
1. Import the workflow JSON into n8n.
2. Configure credentials for Twitter, Google Sheets, and LinkedIn/Hunter.io.
3. Set the webhook trigger to run daily at 9 AM.
4. Test with a small dataset (e.g., 10 tweets) before scaling.
5. Monitor the Google Sheet and Slack channel for results.

**Scalability:**
- Add a CRM integration (e.g., HubSpot) to auto-create contacts.
- Use n8n's queue system for high-volume runs (e.g., 10,000 tweets).
- Store raw data in PostgreSQL for historical analysis.

**Community Notes:**
- This workflow is inspired by real-world use cases from SaaS companies scaling lead gen.
- Join the n8n community forum to share improvements or troubleshoot issues.

**Workflow JSON Snippet:**
```json
{
  "name": "Twitter Lead Scraper",
  "nodes": [
    {
      "parameters": { "trigger": "webhook" },
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook"
    },
    {
      "parameters": { "url": "https://api.twitter.com/2/tweets/search/recent" },
      "name": "Fetch Tweets",
      "type": "n8n-nodes-base.httpRequest"
    },
    {
      "parameters": { "prompt": "Analyze sentiment of this tweet: {{ $json.text }}" },
      "name": "AI Sentiment Analysis",
      "type": "n8n-nodes-base.ai"
    },
    {
      "parameters": { "operation": "append" },
      "name": "Export to Google Sheets",
      "type": "n8n-nodes-base.googleSheets"
    }
  ]
}
```