Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

03 Feedback & Requests

03 Feedback & Requests

Easier List Import: Split Large CRM Lists into Multiple Tables

·

·

would be cool that if we import a list of more than 50k from CRM that it would also split into multiple tables. I spend (waste) so much time trying to split lists into 50k. Not an issue with csv imports but doing with Hubspot /Salesforce is a pain

Easier List Import: Split Large CRM Lists into Multiple Tables | Clay

3 comments

· Sorted by Oldest

Clay
APP
·
·
Currently, CRM imports don't automatically split large lists into multiple tables. However, you can use row limits to split up large lists without creating multiple tables. For Salesforce specifically, there's a 2,000 record limit per report due to Salesforce API restrictions, so importing from Salesforce lists is recommended for larger data pulls. The automatic splitting feature you're requesting would indeed streamline workflows for large CRM imports from HubSpot and Salesforce.
Sources: Import from CRM [Clay 101] - Clay University Import from CRM [CRM Enrichment] - Clay University
Clay
APP
·
·
Hello Taimoor! Thanks for reaching out! Could you tell me more about the workflow you imagine and a high level overview of what you are trying to achieve in the workbook? Is it just CRM updations? I can totally understand how frustrating that limit must be. I am trying to get additional context to relay to the product owners so they can consider it in the future roadmap!
Clay
APP
·
·
I would also recommend checking out our Enterprise tier. This unlocks functionalities like deletion of rows on a rolling basis, thereby surpassing the 50,000 limit. This ensures that the table does not exceed the maximum number of rows at any given time, while still allowing for the continuous import of data. For further information on this feature, please refer to the following link: https://www.clay.com/university/guide/auto-delete. More on pricing: https://www.clay.com/pricing I will reach out to the team for additional information!