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