The GTM Provider Directory
Enrichment

How can I work around Clay's 8KB cell size limit when exporting complete JSON enrichment data?

April 2026

Quick Answer

You have several options to handle large JSON exports: 1) Use field paths with dot notation (like `data.contact.email`) to extract only specific needed fields instead of the full JSON, 2) Use bulk enrichment to process datasets and export results directly to external destinations like Salesforce, Snowflake, or Google Sheets without storing in Clay, 3) Write the full JSON to Google Sheets with an ID reference, then import summarized data back into Clay using lookup actions, or 4) Consider enriching contacts directly in your own application using Clay's data enrichment tools with your existi

○
Up to date
1 months ago

1 Answer

You have several options to handle large JSON exports:

  1. Use field paths with dot notation (like data.contact.email) to extract only specific needed fields instead of the full JSON,

  2. Use bulk enrichment to process datasets and export results directly to external destinations like Salesforce, Snowflake, or Google Sheets without storing in Clay,

  3. Write the full JSON to Google Sheets with an ID reference, then import summarized data back into Clay using lookup actions, or

  4. Consider enriching contacts directly in your own application using Clay's data enrichment tools with your existing API subscriptions.

GTM StackCommunity Insight