Research Column Configuration
Set up intelligent columns that automatically gather and analyze the exact information you need.
Define exactly what information to gather with custom prompts and parameters
Choose how research results appear in your columns, from text to numbers to selections
Configure once, then gather intelligence automatically across your entire dataset
Configuration at a Glance
Research columns operate in the context of your sheet’s data. Make sure your sheet has the necessary input columns (company name, URLs, etc.) that research operations will reference.
Configuring Columns for AI Research
One of Raycaster’s most powerful features is the ability to configure columns to automatically gather and analyze information through AI research. This guide explains how to set up and optimize research-enabled columns.Enabling Research for a Column
Create or Edit Column
Navigate to the sheet where you want to add research capabilities, then:
Or click the ”+” button to add a new column, then configure it.
Enable AI Capabilities
In the column editor, find the “AI Capabilities” toggle:
This unlocks the research configuration options below.
Select Research Tool
Choose the type of research tool that best matches your needs:
Each tool is optimized for different types of data. STRUCTURED works well for most general cases.
Write Research Prompt
Provide clear instructions for what information to gather:
Write a concise summary of ‘s business model based on their website and recent news. Focus on their main products or services, target market, and revenue streams.
Select Input Variables
Choose which columns provide context for your research:
Configure Web Search
Enabling web search allows the AI to gather current information from the internet.
Video Tutorial: Setting Up Research Columns
Video Tutorial: Setting Up Research Columns
Video tutorial coming soon
Selecting the Right Research Tool
Raycaster offers specialized research tools for different needs:| Research Tool | Purpose | Best For | Compatible Column Types |
|---|---|---|---|
| STRUCTURED | General-purpose research with formatted output | Most research needs | TEXT, NUMBER, BOOLEAN, SELECT columns |
| ADVANCED | In-depth analysis with comprehensive data collection | Detailed research requirements | Most column types |
| Email address discovery and verification | Finding contact information | TEXT, EMAIL columns | |
| COMPANY_ENRICHMENT | Comprehensive company data gathering | Complete company profiles | ACTION columns |
| PEOPLE_ENRICHMENT | Detailed professional background analysis | Complete people profiles | ACTION columns |
| LINKEDIN_POSTS | Extract insights from LinkedIn content | Social media analysis | ACTION columns |
| FETCH_PEOPLE | Discover team members and contacts | Building contact lists | ACTION columns |
Writing Effective Research Prompts
Common Prompt Mistakes
- • Being too vague (“research this company”)
- • Forgetting to specify format (“list key information”)
- • Not referencing variables properly ()
- • Requesting too many things in one prompt
Prompt Best Practices
- • Be specific about exactly what information you need
- • Indicate your preferred format and structure
- • Reference existing columns with
- • Focus each prompt on a single research objective
Prompt Structure Formula
[Action verb] + [What information] + [For what entity] + [Using what sources] + [In what format]
Example:
Analyze the funding history for based on their website and public funding databases. Provide a chronological list of funding rounds with date, amount, and lead investors.
Prompt Examples by Column Type
Selecting Input Variables
Input variables provide context for your research prompt:Access Variable Selection
Select Variables
- Company sheet variables: company_name, company_url, industry, etc.
- People sheet variables: person_name, linkedin_url, title, etc.
- Special variables: search_keywords, organization_settings, etc.
Ensure Required Variables
- The system will warn you if you’re missing any variables
- Variables used in the prompt are automatically highlighted
Common Input Variables
Company Sheet Variables
- company_name: The name of the company
- company_url: The company’s website URL
- company_domain: Just the domain portion of the URL
- industry: The company’s industry classification
- location: Company headquarters location
- company_linkedin_url: The company’s LinkedIn profile
People Sheet Variables
- person_name: The individual’s full name
- person_linkedin_url: Their LinkedIn profile URL
- title: Their job title
- company: Their company affiliation
- email: Their email address (if available)
Special Variables
- search_keywords: Keywords defined in your organization settings
- organization_info: Information about your organization
- current_date: The current date for time-sensitive research
Configuring Web Search
Enable or disable web search based on your research needs:Access Web Search Settings
Choose Setting
- ON: The AI will search the internet for information (recommended for most cases)
- OFF: The AI will use only the provided variables and internal knowledge
When to Enable Web Search
-
Enable when:
- You need the most current information
- Your research involves recent events or news
- You’re researching specific details not likely in the AI’s knowledge base
- You need verification from multiple sources
-
Disable when:
- You want faster processing
- You only need analysis of already-provided data
- You’re working with confidential information
- You need consistent results regardless of when research is performed
Advanced Configuration Options
Output Formatting
For TEXT columns, you can specify formatting preferences:- Structure: Choose from paragraph, bullet points, or numbered list
- Length: Set approximate target length (short, medium, long)
- Style: Select analytical, descriptive, or concise
- Highlight Important Points: Toggle to emphasize key findings
Processing Priority
For batch research operations, set column priorities:- Higher priority columns are processed first
- Set priority from 1-5 with 1 being highest priority
- This affects the order of processing, not the quality of research
Source Requirements
Specify source requirements for verification:- Minimum Sources: Set the minimum number of sources required (1-5)
- Source Types: Specify allowed source types (official websites, news, academic, etc.)
- Source Recency: Set maximum age for sources (any, last year, last 6 months, etc.)
Once you’ve configured a research column, you can start researching by clicking the research button in individual cells or by using batch research for multiple rows. For more details, see Viewing Research Results.