The Complete Guide to Clay Integrations: CRMs, Enrichment, and Outreach Tools
While a single-source B2B database typically yields email match rates between 30% and 50%, chaining multiple providers in a Clay waterfall sequence raises the overall match rate to between 78% and 85% [Leadhaste 2026 Guide]. The 35% performance gap is why GTM teams are shifting from single-provider databases to multi-enrichment workflows. This guide covers how to connect CRM databases, build custom webhooks, and set up clay integrations for automated pipeline sync.
How Clay Integrations Address B2B Data Quality and Outreach Scaling
While a single-source B2B database typically yields email match rates between 30% and 50%, chaining multiple providers in a Clay waterfall sequence raises the overall match rate to between 78% and 85% [Leadhaste 2026 Guide]. The 35% performance gap is why GTM teams are shifting from single-provider databases to multi-enrichment workflows. Relying on a single source of truth for B2B data leads to missed opportunities and wasted outreach spend. Clay integrations connect the GTM platform with databases, CRM platforms, and email sequence engines, allowing automated data enrichment and pipeline syncing.
By establishing a unified workflow that queries different data providers sequentially, teams can ensure maximum coverage without paying for empty results. Clay supports over 150 data enrichment providers natively to enable waterfall enrichment workflows. If the first provider does not return a contact's email, the workflow moves to the second, and then the third. This pay-on-success model ensures capital efficiency while building highly accurate lead databases.
To choose the right integration strategy, GTM operations teams must evaluate the tradeoff between native connectors and custom implementations. Native integrations offer instant setup, whereas custom connectors allow you to integrate any API endpoint in real time. The choice depends on target speed, data privacy requirements, and the complexity of the data source.
How to Connect CRM Databases Natively: HubSpot and Salesforce Mappings
Integrating Clay with your primary CRM is the foundation of automated data enrichment. Native clay crm integrations bypass traditional middleware to create direct connections with HubSpot and Salesforce. These connections sync lead, contact, and account objects directly into your enrichment tables, running waterfalls automatically as new records enter your pipeline.
To connect HubSpot natively, you navigate to the integration panel, select HubSpot, and authorize via OAuth. Clay imports records using custom filters, letting you isolate new leads that are missing critical firmographic data. Once imported, Clay maintains the HubSpot Record ID. This ID is critical for write-back rules, ensuring updates map back to the correct record rather than creating duplicate contacts. GTM teams use this unique identifier to prevent writing outdated data over fresh, manually verified records.
For Salesforce, the native integration supports reading from reports, executing custom SOQL queries, and updating objects via upsert rules. When authenticating Salesforce, starting with a sandbox instance is a recommended workflow pattern to prevent accidental modification of production records. Once the schema mappings are verified, you can transition the table to your live production environment. You can map custom lookup columns to sync relational fields, ensuring Salesforce remains your clean database source of truth.
Setting Up Bidirectional HubSpot Synced Tables
A clean HubSpot sync relies on preserving the HubSpot Record ID across your entire table. After connecting HubSpot via OAuth, choose the contacts object and import only leads with blank company size or verified email columns. Once Clay runs the enrichment waterfall, configure a write-back action that maps the enriched columns back to HubSpot, using the HubSpot Record ID as the primary key. This setup ensures that your CRM remains updated in real time as leads progress, while preventing the system from producing duplicate leads.
Executing Custom Salesforce SOQL Queries
Standard CRM connectors can struggle with complex relationship filtering. Clay solves this by allowing direct SOQL query execution. You can write a query to target specific lead pools:
SELECT Id, Name, Email, Company, AnnualRevenue FROM Lead WHERE Status = 'Open' AND AnnualRevenue = null LIMIT 100
By using SOQL queries, you pull in only the records that require enrichment. This prevents credit consumption on leads that are already fully qualified.
Steps to Build Custom API Connectors with HTTP API Columns
While native connectors cover major data platforms, GTM teams often need to query proprietary internal tools or niche databases. Clay addresses this content gap by providing custom API connectors. HTTP API columns allow integration with any API endpoint in real time. This capability gives you complete control over request methods, header structures, and body payloads.
To create a custom connector, add a new column and select the HTTP API enrichment type. From there, you define the target URL and choose the request method, such as GET or POST. If the endpoint requires authorization, you pass the token inside the headers. This setup allows you to query internal databases, proprietary lead scoring models, or custom data providers that lack a native integration.
Once the API returns a response, Clay loads the raw JSON into the table. You then use Clay formulas or JSON paths to extract specific keys into separate columns. For example, if you query a custom security checker API, you can extract the security score and domain registrar data into distinct fields, making them immediately available for downstream automation. This method gives operations engineers the flexibility to build highly customized data tables.
Configuring Authorization Headers and Authentication
Most external APIs require authentication. In the HTTP API column settings, you can configure headers by adding key-value pairs. For Bearer authentication, add Authorization as the key and Bearer YOUR_API_TOKEN as the value. For custom platforms, you can pass custom headers like X-API-Key. This ensures credentials stay protected inside Clay's encrypted connector storage.
Parsing JSON Payloads with Clay Formulas
Custom APIs return nested JSON data. To extract this information into separate columns, create a new column with a Clay formula. Use JSON path syntax to target the specific field. For example, if your API returns the following payload:
{
"enrichment": {
"tech_stack": ["React", "Node.js"],
"employee_count": 250
}
}
You can write a formula targeting /enrichment/employee_count to extract the integer into its own column. This structured extraction lets you segment your list based on custom variables.
Configuring Custom Webhooks: Steps for Inbound and Outbound Feeds
Beyond pulling data via HTTP columns, Clay can ingest data in real time using custom webhooks. This setup is ideal for capturing inbound form submissions or receiving event notifications from external applications. Every Clay table can generate a unique webhook URL, turning your spreadsheet into an event-driven database.
When an external service sends a POST request to this URL, Clay generates a new row containing the payload. You can map these incoming fields directly to table headers. This allows you to automatically trigger your data enrichment waterfalls the moment a new user signs up or requests a demo, bypassing manual imports and keeping GTM responses fast.
For outbound workflows, you can configure outgoing webhooks. Once your enrichment waterfall is complete and data validation checks pass, Clay can dispatch the enriched row data to an external API endpoint or automation platform. This lets you notify downstream applications or update external databases as soon as a lead is qualified.
Creating and Mapping Incoming Webhook URLs
To ingest leads in real time, go to the Import menu in your Clay table and select Webhook. Clay will generate a unique HTTPS endpoint. Copy this URL and paste it into your web form builder or external routing script. Send a test payload to the endpoint so Clay can auto-detect the schema, allowing you to map the incoming JSON properties to your table columns.
Configuring Outgoing Webhooks for Downstream Automation
Once the lead list is enriched, you can send the data to other tools. Add a webhook write-back column and enter the target URL. Configure the trigger to fire only when a verified email column is populated, ensuring that you only export fully qualified leads to your outbound stack.
Coordinate Clay data and agent outputs in one place
Set up a shared, intelligent workspace to store, version, and query your enriched CRM lead lists. Access your files via the Fastio MCP server or UI. Start a 14-day free trial of a paid organization subscription today.
Outbound Execution: Connecting Clay to Outreach and Email Engines
The final step of the enrichment workflow is pushing your verified leads into sending platforms. Native clay outbound integrations connect your tables directly to outreach engines like Instantly and Smartlead. This direct integration ensures that sales representatives can launch personalized campaigns without manual file exports or complex data mapping.
To set up an outbound sync, connect your sending platform using an API key. Once connected, map your Clay table columns to the variables in your outreach templates. For instance, map the personalized opening lines generated by Clay's AI tools to a custom variable in your email sequence. This allows you to dynamically populate email bodies with company-specific details.
Before launching any outreach campaign, implementing email validation is a critical best practice. Outbound campaigns require high deliverability to protect your sender reputation. Adding validation steps like ZeroBounce or Hunter Verification at the end of your waterfall ensures that invalid addresses are scrubbed before they reach your sending sequences. This programmatic validation step protects your sending domain from being blacklisted.
Mapping Dynamic Personalization Variables
Personalized outreach yields higher response rates. When setting up your outbound integration in Clay, map your AI-generated text columns to custom fields in your sending tool. Ensure that variables like company name, technology stack, and recent company news map directly to variables like {{company}} and {{custom_icebreaker}} in your email templates.
Protecting Email Deliverability with Waterfall Validation
Never push unverified contacts to your outreach sequences. Build a deliverability check directly into your Clay table as the final step of your enrichment waterfall. By configuring email validation tools to run automatically, you verify that every email address exists before it is exported, keeping your bounce rate under 2%.
Persistent Workspaces and RAG: Closing the Handoff Loop with Fastio
While Clay serves as the intermediate table enrichment engine, GTM teams require a collaborative workspace to manage, version, and share the resulting files. Storing CSV files on local desktops or static cloud folders leads to context gaps and lost history.
Fastio provides a shared workspace platform designed for GTM and agentic teams. Instead of using generic storage, teams use Fastio to coordinate files, notes, and automations. For unstructured files like PDFs or contracts, Fastio's Metadata Views turn documents into a live, queryable database. Users describe the fields they want extracted in natural language (such as contract renewal dates, counterparties, or billing details), and the built-in AI populates a structured view. To explore this feature, read about document data extraction.
Fastio supports paid organizations with plans starting at Starter ($29/month), Business ($99/month), and Growth ($299/month). Every organization begins with a 14-day free trial, which requires a credit card. To view plan limits and start a trial, see our pricing page. Teams can configure webhooks to trigger downstream scripts whenever a new CSV is uploaded, and use URL Import to pull files directly from OneDrive or Box.
For developer teams, Fastio works with AI workflows via its Model Context Protocol server. The MCP server exposes tools for reading, writing, and querying files. Developers can access this server via Streamable HTTP at the /mcp endpoint and legacy SSE at the /sse endpoint. For developer onboarding instructions, refer to llms.txt and the MCP guide. This allows AI agents to automatically fetch lead lists, pass them to Clay, and write the enriched files back to the shared workspace. Fastio maintains a per-file version history, keeping every modification auditable and reversible. If an agent error corrupts a file, a human administrator can restore the previous version with a single click. To explore persistent workspace features for AI workflows, see our agent storage capabilities.
Extracting Structured Document Data with Metadata Views
When GTM teams receive inbound leads via unstructured files like event attendee lists in PDF or scanned resumes, they can load them into a Fastio workspace. Using Metadata Views, the system automatically parses these files and extracts key values like name, company, email, and location into a queryable grid. This structured data can then be exported to Clay for deep enrichment and synced to your CRM.
Connecting AI Agents via the Model Context Protocol
By deploying the Fastio MCP server alongside your Clay workflows, your AI agents gain secure access to the file storage layer. The agent can use the MCP tools to read input leads, initiate the enrichment process through Clay, save the output, and notify the GTM team. This provides a system where agents and humans collaborate inside the same workspace.
Frequently Asked Questions
What integrations does Clay support?
Clay supports over 150 data enrichment providers natively to enable waterfall enrichment. Additionally, Clay includes native CRM connectors for Salesforce, HubSpot, Pipedrive, and Close, as well as native integrations with outreach and sending platforms like Instantly, Smartlead, and lemlist.
How does Clay connect to external databases?
Clay connects to external databases through native lookup integrations for PostgreSQL and Snowflake, where you enter database credentials to query rows. For databases without native read-only connectors, you can connect using the HTTP API column or interface via webhooks or automation platforms like Zapier, Make, or n8n.
How do custom webhooks work in Clay outbound workflows?
Custom webhooks allow Clay tables to receive data from external forms or applications in real time. Once you configure a unique webhook URL inside your table, any incoming POST request creates a new row. You can also configure outgoing webhooks to send enriched lead data to other endpoints when validation steps are complete.
How does Fastio persist and version lead data from Clay?
Fastio serves as a persistent, versioned workspace for GTM teams using Clay. You can save enriched CSV lead lists to Fastio, which automatically indexes them for semantic search and retains a complete version history. If an agent or script overwrites a file with bad data, you can restore a prior version immediately.
Related Resources
Coordinate Clay data and agent outputs in one place
Set up a shared, intelligent workspace to store, version, and query your enriched CRM lead lists. Access your files via the Fastio MCP server or UI. Start a 14-day free trial of a paid organization subscription today.