Skip to main content

​
Overview

Smart Spreadsheet is an AI-powered tool that enriches company data on demand. Input a company name or website URL and get verified information including industry, headcount, and funding details; each with source attribution. Results appear in the frontend in real-time as each task completes.
  • A Next.js app with Trigger.dev for background tasks
  • Exa – an AI-native search engine that returns clean, structured content ready for LLM extraction
  • Claude via the Vercel AI SDK for data extraction
  • Supabase PostgreSQL database for persistence
  • Trigger.dev Realtime for live updates to the frontend

​
Video

​
GitHub repo

View the Smart Spreadsheet repo

Click here to view the full code for this project in our examples repository on GitHub. You can fork it and use it as a starting point for your own project.

​
How it works

The enrichment workflow:
  1. Trigger enrichment – User enters a company name or URL in the spreadsheet UI
  2. Parallel data gathering – Four subtasks run concurrently to fetch basic info, industry, employee count, and funding details
  3. AI extraction – Each subtask uses Exa search + Claude to extract structured data with source URLs
  4. Real-time updates – Results appear in the frontend as each subtask completes
  5. Persist results – Enriched data is saved to Supabase with source attribution

​
Features

  • Parallel processing – All four enrichment categories run simultaneously using batch.triggerByTaskAndWait
  • Source attribution – Every data point includes the URL it was extracted from
  • Live updates – Results appear in the UI as each task completes using Realtime
  • Structured extraction – Zod schemas ensure consistent data output from Claude

​
Key code patterns

​
Parallel task execution

The main task triggers all four enrichment subtasks simultaneously using batch.triggerByTaskAndWait:
src/trigger/enrich-company.ts
const { runs } = await batch.triggerByTaskAndWait([
  { task: getBasicInfo, payload: { companyName, companyUrl } },
  { task: getIndustry, payload: { companyName, companyUrl } },
  { task: getEmployeeCount, payload: { companyName, companyUrl } },
  { task: getFundingRound, payload: { companyName, companyUrl } },
]);

​
Live updates from child tasks

Each subtask uses metadata.parent.set() to update the parent’s metadata as soon as data is extracted:
src/trigger/get-basic-info.ts
// After Claude extracts the data, update the parent task's metadata
metadata.parent.set("website", object.website);
metadata.parent.set("description", object.description);
The frontend subscribes to these metadata updates using Realtime, so users see each field populate as it’s discovered.

​
Relevant code

FileDescription
src/trigger/enrich-company.tsMain orchestrator that triggers parallel subtasks and persists results
src/trigger/get-basic-info.tsExtracts company website and description
src/trigger/get-industry.tsClassifies company industry
src/trigger/get-employee-count.tsFinds employee headcount
src/trigger/get-funding-round.tsDiscovers latest funding information

​
Learn more about Trigger.dev Realtime

To learn more, take a look at the following resources: