Skip to content

RUN_IMPORT_NOW.md

Latest commit

 

History

History
157 lines (116 loc) · 3.61 KB

RUN_IMPORT_NOW.md

File metadata and controls

157 lines (116 loc) · 3.61 KB

🚀 READY TO RUN - Import YC Winter 2026 Companies

✅ Everything is Set Up!

Your environment is configured and ready to import YC Winter 2026 companies.

Current Status

  • ✅ Database connected (Neon PostgreSQL)
  • ✅ Environment variables configured
  • ✅ n8n webhook URL set
  • ✅ Scraper tested (found 40 companies)
  • ✅ 0 Winter 2026 companies in database (ready for fresh import)

🎯 Run the Import (3 Commands)

cd backend

# 1. Check database status (current state)
npm run db:status

# 2. Import YC Winter 2026 companies
npm run import:yc-w26

That's it! The script will:

  1. Find ~40 Winter 2026 companies from YC
  2. Extract full details for each
  3. Store in your Neon database
  4. Trigger n8n workflows for AI evaluation

⏱️ Expected Timeline

  • Total runtime: 5-7 minutes
  • Companies to import: ~40
  • Rate limiting: 3 seconds between requests

📊 What You'll See

========================================
YC Winter 2026 Companies Import Script
========================================

Step 1: Getting system user...
✓ System user ready

Step 2: Scraping YC Winter 2026 companies...
✓ Found 40 companies in Winter 2026 batch

Step 3: Processing and importing companies...

[1/40] Processing: Veriad
  ✓ Imported successfully

[2/40] Processing: Corelayer
  ✓ Imported successfully

...

========================================
Import Summary
========================================
Total companies found: 40
Successfully imported: 40
Skipped (already exist): 0
Failed: 0
========================================

🔍 Verify the Import

After the import completes, verify the data:

Option 1: Check Database Status

npm run db:status

You should see:

Winter 2026 Companies: 40

Option 2: Query Database Directly

psql 'postgresql://neondb_owner:npg_2kZoxdber7Fl@ep-ancient-wildflower-a4c1trj9-pooler.us-east-1.aws.neon.tech/neondb?sslmode=require&channel_binding=require'

Then run:

SELECT COUNT(*) FROM companies WHERE yc_batch = 'Winter 2026';
SELECT name, website, category FROM companies WHERE yc_batch = 'Winter 2026' LIMIT 10;

Option 3: Check n8n Dashboard

  1. Visit: https://bubblyducks.app.n8n.cloud
  2. Check workflow executions for:
    • generate-report workflow
    • evaluate-company workflow

📝 What Gets Imported

For each company:

  • Name: Company name
  • Description: Company description
  • Website: Company website URL
  • Category: Sector/industry
  • YC Batch: Set to "Winter 2026"
  • Founder Links: LinkedIn profiles (only /in/ personal profiles)
  • Created By: System user (auto-created)

🔧 Troubleshooting

"No companies found"

Run the scraper test to diagnose:

npm run test:scraper

"Database connection failed"

Test the connection:

npm run db:test

"n8n webhook failed"

This is non-critical - companies will still be imported. To fix:

  1. Check workflows are activated at https://bubblyducks.app.n8n.cloud
  2. Verify N8N_WEBHOOK_BASE_URL in backend/.env

📚 Additional Documentation

  • Quick Start: See QUICK_IMPORT.md
  • Comprehensive Guide: See IMPORT_GUIDE.md
  • Implementation Details: See IMPLEMENTATION_SUMMARY.md
  • n8n Setup: See backend/n8n/WORKFLOW_SETUP_GUIDE.md

🎉 After Import

Once complete, you can:

  1. View companies in the frontend
  2. Run evaluations via n8n workflows
  3. Export data for analysis
  4. Re-run import to catch new companies (duplicates will be skipped)

💡 Ready? Let's Go!

cd backend
npm run import:yc-w26

The script will guide you through the rest! 🚀