Skip to main content
Want a guided walkthrough? Schedule a 15-min call.

​
Use Case: Deal Intelligence for Sales Teams

Sales teams often need comprehensive data about potential clients before outreach. Traditional data providers offer limited information, while manual research is time-consuming. With Extruct AI, you can enrich your company list with custom data points at scale.

​
Setting up Company Enrichment

Create a table with input columns for basic company information and agent columns for the enrichment: 
curl -X POST "https://api.extruct.ai/v1/tables" \
  -H "Authorization: Bearer YOUR_API_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "Enterprise Deal Intelligence",
    "kind": "company",
    "column_configs": [
      {
        "kind": "input",
        "name": "Company",
        "key": "input"
      },
      {
        "kind": "agent",
        "name": "Tech Stack",
        "key": "tech_stack",
        "value": {
          "agent_type": "research_pro",
          "prompt": "Identify the key technologies in this company tech stack, focusing on CRM, marketing automation, and data platforms.",
          "output_format": "json",
          "output_schema": {
            "type": "object",
            "properties": {
              "crm": { "type": "string" },
              "marketing": { "type": "array", "items": { "type": "string" } },
              "data_platforms": { "type": "array", "items": { "type": "string" } }
            }
          }
        }
      },
      {
        "kind": "agent",
        "name": "Decision Makers",
        "key": "decision_makers",
        "value": {
          "agent_type": "research_pro",
          "prompt": "Identify the key decision makers for purchasing enterprise software at this company. Include their name, title, and LinkedIn profile URL if available.",
          "output_format": "json",
          "output_schema": {
            "type": "object",
            "properties": {
              "people": {
                "type": "array",
                "items": {
                  "type": "object",
                  "properties": {
                    "name": { "type": "string" },
                    "title": { "type": "string" },
                    "linkedin_url": { "type": "string" },
                    "department": { "type": "string" }
                  }
                }
              }
            },
            "required": ["people"]
          }
        }
      },
      {
        "kind": "agent",
        "name": "Recent Initiatives",
        "key": "initiatives",
        "value": {
          "agent_type": "research_pro",
          "prompt": "Identify 2-3 recent business initiatives, digital transformation efforts, or growth strategies this company has announced in the past 12 months.",
          "output_format": "text"
        }
      }
    ]
  }'

​
Adding Companies to Enrich

Once your table is created, add companies you want to enrich: 
curl -X POST "https://api.extruct.ai/v1/tables/{table_id}/rows" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_API_TOKEN" \
  -d '{
    "rows": [
      {
        "data": {
          "input": "Extruct AI (https://extruct.ai)"
        }
      },
      {
        "data": {
          "input": "OpenAI (https://openai.com)"
        }
      },
      {
        "data": {
          "input": "Anthropic (https://anthropic.com)"
        }
      }
    ],
    "run": true
  }'
Setting run to true automatically triggers the enrichment process. If you add multiple batches of companies, you might want to add them all first with run: false and then trigger the enrichment once: 
curl -X POST "https://api.extruct.ai/v1/tables/{table_id}/run" \
  -H "Authorization: Bearer YOUR_API_TOKEN"

​
Tracking Enrichment Progress

Monitor the enrichment progress using the Get Table endpoint: 
curl -X GET "https://api.extruct.ai/v1/tables/{table_id}" \
  -H "Authorization: Bearer YOUR_API_TOKEN"
The response includes a status object with fields like:
  • num_cells_completed: How many cells have finished enrichment
  • num_cells_in_progress: How many cells are currently being processed
  • run_status: Overall table status (running or idle)

​
Retrieving Enriched Data

Once the enrichment is complete, retrieve the enriched data: 
curl -X GET "https://api.extruct.ai/v1/tables/{table_id}/data" \
  -H "Authorization: Bearer YOUR_API_TOKEN"
Sample response: 
{
  "rows": [
    {
      "id": "<string>",
      "created_at": "2023-11-07T05:31:56Z",
      "data": {
        "input": {
          "value": "Stripe (https://stripe.com)",
          "status": "done",
          "updated_at": "2023-11-07T05:31:56Z"
        },
        "tech_stack": {
          "value": {
            "answer": {
              "crm": "Salesforce",
              "marketing": ["Marketo", "Google Analytics", "Segment"],
              "data_platforms": ["AWS", "Snowflake", "Databricks"]
            },
            "sources": ["https://stripe.com/docs", "https://stackshare.io/stripe/stripe"],
            "explanation": "Based on public information and technical documentation, Stripe uses Salesforce for CRM, multiple marketing automation tools including Marketo, and a cloud-based data infrastructure."
          },
          "status": "done",
          "updated_at": "2023-11-07T05:31:56Z"
        },
        "decision_makers": {
          "value": {
            "answer": {
              "people": [
                {
                  "name": "David Singleton",
                  "title": "Chief Technology Officer",
                  "linkedin_url": "https://www.linkedin.com/in/dsingleton/",
                  "department": "Engineering"
                },
                {
                  "name": "Will Gaybrick",
                  "title": "Chief Product Officer",
                  "linkedin_url": "https://www.linkedin.com/in/wgaybrick/",
                  "department": "Product"
                }
              ]
            },
            "sources": ["https://stripe.com/about", "https://www.linkedin.com/company/stripe/people/"],
            "explanation": "Identified key executives responsible for technology and product decisions based on their public profiles and company information."
          },
          "status": "done",
          "updated_at": "2023-11-07T05:31:56Z"
        },
        "initiatives": {
          "value": {
            "answer": "1. Global Expansion: Stripe has been aggressively expanding into new international markets, particularly in Latin America and Southeast Asia.\n2. AI Integration: Recently launched ML-powered fraud detection tools and revenue optimization features.\n3. Financial Services: Introduced Stripe Treasury to help businesses embed financial services in their platforms.",
            "sources": ["https://stripe.com/newsroom", "https://techcrunch.com/tag/stripe/"],
            "explanation": "These initiatives were identified from recent company announcements and news coverage over the past 12 months."
          },
          "status": "done",
          "updated_at": "2023-11-07T05:31:56Z"
        }
      }
    }
    // More rows...
  ]
}

​
Advanced Enrichment Column Types

​
Text Columns

Text columns are ideal for descriptive information: 
{
  "kind": "agent",
  "name": "Value Proposition",
  "key": "value_prop",
  "value": {
    "agent_type": "research_pro",
    "prompt": "What is the main value proposition of {input}? Explain in 1-2 sentences.",
    "output_format": "text"
  }
}

​
Number Columns

Number columns are perfect for metrics: 
{
  "kind": "agent",
  "name": "Founded Year",
  "key": "founded_year",
  "value": {
    "agent_type": "research_pro",
    "prompt": "In what year was {input} founded? Return just the number.",
    "output_format": "number"
  }
}

​
URL Columns

URL columns help find specific links: 
{
  "kind": "agent",
  "name": "LinkedIn URL",
  "key": "linkedin",
  "value": {
    "agent_type": "research_pro",
    "prompt": "Find the LinkedIn company page URL for {input}.",
    "output_format": "url"
  }
}

​
JSON Columns

JSON columns provide structured data: 
{
  "kind": "agent",
  "name": "Social Media",
  "key": "social_profiles",
  "value": {
    "agent_type": "research_pro",
    "prompt": "Find social media profiles for {input}. Include Twitter, LinkedIn, and Facebook.",
    "output_format": "json",
    "output_schema": {
      "type": "object",
      "properties": {
        "twitter": { "type": "string" },
        "linkedin": { "type": "string" },
        "facebook": { "type": "string" }
      }
    }
  }
}

​
Best Practices for Enrichment at Scale

  1. Batch Processing
    • Add companies in batches of 100-500 for optimal performance
    • Use pagination to retrieve large datasets
  2. Smart Prompts
    • Be specific about what you’re looking for
    • For better accuracy, include instructions about output format in the prompt
    • Use {input} as a placeholder for the company identifier
  3. Error Handling
    • Some companies may not have all information available
    • Check for null values in responses
    • Consider adding fallback columns for critical data points
  4. Performance Considerations
    • Complex prompts take longer to process
    • Simple factual queries process faster than analytical ones
    • Adding more columns increases processing time

​
Exporting Enriched Data

You can export the enriched data in several ways:
  1. API Export: Paginate through all data using the Get Table Data endpoint
  2. Dashboard Export: Download CSV/Excel files from the Extruct Dashboard
  3. Integrations: Connect to CRM systems for direct data transfer

​
Next Steps

  • Try creating a table with different data points
  • Experiment with different column types and formats
  • Check out the API Reference for more details