Clay has an 8,000 character limit per cell. To work with large Salesforce fields that exceed this limit, you can use SOQL queries to selectively retrieve specific portions of the data or break down the large fields into smaller chunks. Using the "Lookup Records via SOQL" action, you can write custom SOQL queries to retrieve only the essential data you need.For large datasets, consider importing directly from Salesforce lists rather than reports, as this method allows for more comprehensive data pulls and better handling of large records.
Sources:Salesforce integration overview | Documentation | Clay UniversityImport from CRM [Clay 101] - Clay University