YC Company Employee Finder

Discover Y Combinator company employees in your user list

\n );\n}\n\nfunction HowItWorks() {\n return (\n

How It Works

Upload your CSV file or paste CSV data containing user emails under a column named \"email\"
We extract email domains from your user list
\n We match these domains against our database of YC companies (sourced{\" \"}\n \n here\n \n , cached here)\n
You get a detailed report of matches, enriched with YC company data
This is done entirely client-side. None of your data hits our servers or is stored

\n );\n}\n\nfunction App() {\n const [ycCompanies, setYcCompanies] = useState([]);\n const [mergedData, setMergedData] = useState([]);\n const [debugInfo, setDebugInfo] = useState(\"\");\n const [isLoading, setIsLoading] = useState(false);\n const [showDebug, setShowDebug] = useState(false);\n const [csvText, setCsvText] = useState(DEFAULT_CSV);\n\n useEffect(() => {\n const fetchYCCompanies = async () => {\n const storedCompanies = localStorage.getItem(\"ycCompanies\");\n if (storedCompanies) {\n const companies = JSON.parse(storedCompanies);\n setYcCompanies(companies);\n setDebugInfo(prevInfo => prevInfo + `\\nLoaded ${companies.length} companies from localStorage`);\n } else {\n const response = await fetch(\"/companies.json\");\n const companies = await response.json();\n setYcCompanies(companies);\n localStorage.setItem(\"ycCompanies\", JSON.stringify(companies));\n setDebugInfo(prevInfo =>\n prevInfo + `\\nFetched ${companies.length} companies from server and stored in localStorage`\n );\n }\n };\n fetchYCCompanies();\n }, []);\n\n const handleFileUpload = (event: React.ChangeEvent) => {\n const file = event.target.files?.[0];\n if (file) {\n setIsLoading(true);\n setDebugInfo(prevInfo => prevInfo + `\\nFile selected: ${file.name}`);\n const reader = new FileReader();\n reader.onload = (e) => {\n const csv = e.target?.result as string;\n setCsvText(csv);\n setDebugInfo(prevInfo => prevInfo + `\\nCSV loaded, length: ${csv.length} characters`);\n };\n reader.readAsText(file);\n }\n };\n\n const handleSubmit = (event: React.FormEvent) => {\n event.preventDefault();\n setIsLoading(true);\n processCSV(csvText);\n };\n\n const processCSV = (csv: string) => {\n const records = csvParse(csv);\n setDebugInfo(prevInfo => prevInfo + `\\nParsed CSV, ${records.length} records found`);\n let matchCount = 0;\n const processedData = records.map((record: any) => {\n if (!record.email) {\n setDebugInfo(prevInfo => prevInfo + `\\nSkipped record: No email field`);\n return null;\n }\n const domain = extractDomain(record.email);\n setDebugInfo(prevInfo => prevInfo + `\\nProcessing email: ${record.email}, extracted domain: ${domain}`);\n const matchedCompany = findMatchingCompany(domain);\n if (matchedCompany) {\n matchCount++;\n setDebugInfo(prevInfo => prevInfo + `\\nMatched company: ${matchedCompany.Company}`);\n return { ...record, ...matchedCompany };\n }\n setDebugInfo(prevInfo => prevInfo + `\\nNo match found for domain: ${domain}`);\n return null;\n }).filter(Boolean);\n setDebugInfo(prevInfo =>\n prevInfo + `\\nProcessing complete. ${matchCount} matches found out of ${records.length} records`\n );\n setMergedData(processedData);\n setIsLoading(false);\n };\n\n const extractDomain = (email: string) => {\n const domain = email.split(\"@\")[1];\n return domain.replace(/^(https?:\\/\\/)?(www\\.)?/, \"\").replace(/\\/$/, \"\");\n };\n\n const findMatchingCompany = (domain: string) => {\n return ycCompanies.find(company => {\n const companyDomain = company.Website.replace(/^(https?:\\/\\/)?(www\\.)?/, \"\").replace(/\\/$/, \"\");\n return companyDomain === domain;\n });\n };\n\n const toggleDebug = () => {\n setShowDebug(!showDebug);\n };\n\n const debugButtonStyle = {\n position: \"fixed\" as const,\n bottom: \"20px\",\n right: \"20px\",\n zIndex: 1000,\n };\n\n return (\n

\n \n \n

Upload Your CSV or Paste CSV Data

\n\n {mergedData.length > 0 && (\n

Results

{mergedData.length} YC company employees found in your list!

\n \n \n \n {Object.keys(mergedData[0]).map(key => )}\n \n \n \n {mergedData.map((row, index) => (\n \n {Object.values(row).map((value: any, cellIndex) => )}\n \n ))}\n \n

{key}
{value}

\n )}\n\n \n\n

Debug Information

YC Companies Data (First 5 Rows)

{JSON.stringify(ycCompanies.slice(0, 5), null, 2)}

Processing Log

{debugInfo}

\n\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")!).render();\n}\n\nif (typeof document !== \"undefined\") {\n client();\n}\n\nexport default async function server(request: Request): Promise {\n const companies = await fetch(\"https://stevekrouse-yc_database.web.val.run\").then(res => res.json());\n const url = new URL(request.url);\n if (url.pathname === \"/companies.json\") {\n return new Response(JSON.stringify(companies), {\n headers: { \"content-type\": \"application/json\" },\n });\n }\n\n return new Response(\n `\n \n \n \n \n \n YC Company Employee Finder\n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"content-type\": \"text/html\" },\n },\n );\n}\n\nconst css = `\n:root {\n --primary-color: #ff6600;\n --secondary-color: #2c3e50;\n --background-color: #f8f9fa;\n --text-color: #333;\n}\n\nbody {\n font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\n line-height: 1.6;\n color: var(--text-color);\n background-color: var(--background-color);\n margin: 0;\n padding: 0;\n}\n\n.container {\n max-width: 1200px;\n margin: 0 auto;\n padding: 20px;\n}\n\n.hero {\n background-color: var(--primary-color);\n color: white;\n padding: 40px 20px;\n text-align: center;\n border-radius: 8px;\n margin-bottom: 30px;\n}\n\n.hero h1 {\n font-size: 2.5em;\n margin-bottom: 10px;\n}\n\n.hero p {\n font-size: 1.2em;\n max-width: 600px;\n margin: 0 auto;\n}\n\n.how-it-works {\n background-color: white;\n padding: 30px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);\n margin-bottom: 30px;\n}\n\n.how-it-works h2 {\n color: var(--secondary-color);\n margin-bottom: 20px;\n}\n\n.how-it-works ol {\n padding-left: 20px;\n}\n\n.how-it-works li {\n margin-bottom: 10px;\n}\n\n.upload-section {\n background-color: white;\n padding: 30px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);\n margin-bottom: 30px;\n}\n\n.upload-section h2 {\n color: var(--secondary-color);\n margin-bottom: 20px;\n}\n\ninput[type=\"file\"] {\n display: block;\n margin-bottom: 20px;\n padding: 10px;\n border: 2px solid var(--primary-color);\n border-radius: 4px;\n width: 100%;\n}\n\ntextarea {\n width: 100%;\n margin-bottom: 20px;\n padding: 10px;\n border: 2px solid var(--primary-color);\n border-radius: 4px;\n font-family: inherit;\n font-size: 14px;\n}\n\n.loader {\n text-align: center;\n font-weight: bold;\n color: var(--primary-color);\n margin-top: 20px;\n}\n\n.results-section {\n background-color: white;\n padding: 30px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);\n margin-bottom: 30px;\n overflow-x: auto;\n}\n\n.results-section h2 {\n color: var(--secondary-color);\n margin-bottom: 20px;\n}\n\ntable {\n width: 100%;\n border-collapse: collapse;\n margin-top: 20px;\n}\n\nth, td {\n border: 1px solid #ddd;\n padding: 12px;\n text-align: left;\n}\n\nth {\n background-color: var(--primary-color);\n color: white;\n}\n\ntr:nth-child(even) {\n background-color: #f2f2f2;\n transition: background-color 0.3s ease;\n}\n\n.debug-section {\n background-color: white;\n padding: 30px;\n border-radius: 8px;\n box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);\n margin-top: 20px;\n margin-bottom: 30px;\n}\n\n.debug-section h2, .debug-section h3 {\n color: var(--secondary-color);\n margin-bottom: 20px;\n}\n\n.debug-content {\n max-height: 500px;\n overflow-y: auto;\n}\n\npre {\n background-color: #f0f0f0;\n padding: 15px;\n border-radius: 5px;\n white-space: pre-wrap;\n word-wrap: break-word;\n font-size: 14px;\n}\n\nfooter {\n text-align: center;\n margin-top: 30px;\n padding: 20px;\n background-color: var(--secondary-color);\n color: white;\n border-radius: 8px;\n}\n\nfooter a {\n color: var(--primary-color);\n text-decoration: none;\n}\n\nfooter a:hover {\n text-decoration: underline;\n}\n\nbutton {\n background-color: var(--secondary-color);\n color: white;\n border: none;\n padding: 10px 15px;\n border-radius: 5px;\n cursor: pointer;\n transition: background-color 0.3s ease;\n}\n\nbutton:hover {\n background-color: #34495e;\n}\n`;","deleted","label",[98],"permalink","https://www.val.town/x/calavera/yc_finder/code/main.tsx","extension","actionData","errors"]