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`;",["D",1738669890979],"version","currentUserHasLiked","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_96":97,"_101":102},"forkedVal",{"_94":154,"_96":155,"_128":129,"_144":156,"_157":-5},"03cef2f2-a697-11ef-adf9-e6cdfca9ef9f","stevekrouse",22,"prDisabledHint","interval","description","YC Company Finder In an effort to get more companies using Val Town, I wanted to see which of our existing userbase was part of a YC company. I found this wonderful\n google sheet \nwith all YC companies, and had Townie make me this interface to\njoin it with an exported CSV of our users table. All the compute happens client-side, so it's safe for you to run on your customer lists too. If you want any changes, fork it & have Townie customize it for you. Feel free to send me a pull request or leave a comment :)","latestEvaluation","slug","reetkumarbind/yc_finder","versions",[166],{"_98":167,"_144":31,"_168":169},["D",1738669890979],"n","1","hasNext","routes/_app","actionData","errors"]