Handling Large Phantombuster Datasets in Clay
When Phantombuster results exceed 200kb (typically with ~700+ comments), the API returns a CSV file instead of inline values.
Solutions
Option 1: Reduce Dataset Size
- Limit the number of comments to a smaller amount for direct table output in Clay
Option 2: Process Large Datasets with n8n
- Send an HTTP request from Clay to n8n
- Configure n8n to process all comments from the Phantombuster CSV
- Have n8n push the processed data back to your Clay table in batches
February 2026