Smart Spreadsheet

​

Overview

• 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

​

How it works

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

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

// After Claude extracts the data, update the parent task's metadata
metadata.parent.set("website", object.website);
metadata.parent.set("description", object.description);

​

Relevant code

​

Learn more about Trigger.dev Realtime

• Trigger.dev Realtime - learn more about how to subscribe to runs and get real-time updates
• Realtime streaming - learn more about streaming data from your tasks
• Batch Triggering - learn more about how to trigger tasks in batches
• React hooks - learn more about using React hooks to interact with the Trigger.dev API