Company CSV
Name, website, and company category.
AI-POWERED OUTREACH ENGINE · 2026
InternGuide transforms structured company data into a complete internship outreach pipeline — discovering relevant contact channels, generating context-aware AI drafts, and routing every message through human approval before delivery.
THE PROBLEM
Students repeatedly collect company lists, search contact and career pages, remove irrelevant addresses, research each company, write similar emails, and track what was sent. InternGuide turns that fragmented process into one observable workflow while keeping the final decision with the applicant.
01 — THE COMPLETE WORKFLOW
The scraper and outreach modules operate as connected stages. Structured company metadata stays attached to each recipient from import through generation and delivery.
Name, website, and company category.
Career and contact paths are scanned.
Useful addresses remain with evidence.
Context-aware subject and body.
Approve and send, or reject.
02 — DISCOVERY ENGINE
The scraper accepts a CSV containing company name, website, and business category. Rows are normalized, duplicate domains are removed, and invalid entries are isolated before any network work begins.
Each domain is processed through prioritized career, application, job, internship, and contact paths. Live polling exposes the current domain, page, progress, and latest logs while independent failures cannot stop the run.
The same normalized address is kept once per company while every discovery source is merged. Technical, privacy, billing, support, placeholder, and asset-like addresses are filtered conservatively.
03 — OUTREACH PIPELINE
The applicant supplies a name, a concise background summary, and the target language. A connected Gmail OAuth account or verified SMTP provider becomes the controlled delivery channel.
Every recipient is processed independently. Company metadata, recipient type, applicant information, selected language, and a strict static rubric are sent through the backend to produce structured subject and body fields.
No generated email is sent automatically. Each message enters WAITING_APPROVAL. The applicant can approve and send it through the active provider or reject it permanently. There is no silent bulk-send path.
04 — ENGINEERING DECISIONS
Long-running scraping and AI work returns immediately and reports progress through polling endpoints.
Active state lives in memory. Debounced cloned snapshots are fsynced to unique temp files and atomically renamed.
A strict backend rubric limits drafts to supplied company context and applicant information, reducing unsupported claims.
Delivery supports both Google OAuth architecture and verified custom SMTP without exposing secrets to the frontend.
PROJECT SCOPE
InternGuide is a private, local-first engineering project developed for personal internship outreach workflows and limited use by a small number of friends. The system processes publicly accessible company pages and is not designed to bypass authentication, CAPTCHAs, access controls, or restricted resources.
05 — CONTACT
InternGuide is not publicly distributed, but technical questions about the system are welcome.
egeaksoy@ug.bilkent.edu.tr ↗