Phase 1: Foundation Setup (Day 1)
Step 1: n8n Installation
Option A: n8n Cloud (Recommended for Beginners)
- Go to n8n.cloud
- Sign up for account
- Choose "Starter" plan ($20/month)
- Complete email verification
Option B: Self-Hosted (Advanced Users)
bash
*# Docker installation*
docker run -it --rm --name n8n -p 5678:5678 n8nio/n8n
*# Or npm installation*
npm install n8n -g
n8n start
Step 2: Import the Workflow
- Download the workflow JSON file from above
- Open your n8n instance
- Click "Import from File"
- Select the downloaded JSON file
- Import and verify all nodes appear
Step 3: Database Setup
sql
*- PostgreSQL setup*
CREATE DATABASE competitor_leads_db;
*- Connect to the database*
\\c competitor_leads_db;
*- Create the main table*
CREATE TABLE competitor_leads ( id SERIAL PRIMARY KEY, name VARCHAR(255), email VARCHAR(255), company VARCHAR(255), role VARCHAR(255), linkedin_profile TEXT, comment_text TEXT, lead_score INTEGER, pain_points TEXT, source_post VARCHAR(500), created_at TIMESTAMP DEFAULT NOW()
);
*- Create indexes for performance*
CREATE INDEX idx_email ON competitor_leads(email);
CREATE INDEX idx_created_at ON competitor_leads(created_at);
CREATE INDEX idx_lead_score ON competitor_leads(lead_score);
Phase 2: API Integrations (Day 2-3)