Importing a HubSpot List Larger Than 50K Rows: What to Expect
my hubspot list is larger than 50k rows. What happens when I attempt to import is?
my hubspot list is larger than 50k rows. What happens when I attempt to import is?
When you attempt to import a HubSpot list larger than 50,000 rows, the import will be limited to 50,000 rows maximum. Clay tables are capped at 50,000 rows per table, and when this limit is reached, additional rows cannot be added. To work around this, you can: • Split your data: Break your large HubSpot list into smaller lists of under 50,000 rows each and import them into separate Clay tables • Use Passthrough Tables (Enterprise Plan only): This feature bypasses the 50,000-row limit by handling rows on a rolling basis The 50,000-row limit applies to all rows in the table, including visible, hidden, deleted, or filtered rows.
how do I use a passthrough table?
Passthrough tables are an Enterprise Plan feature that bypasses the 50,000-row limit by handling rows on a rolling basis. The system automatically deletes data with the workflow being: 1. Send data to Clay 2. Enrich that data in Clay 3. Send enriched data back to your system 4. Delete the data from Clay to make room for more data You can define how many rows to retain (default is 100). This eliminates the need to duplicate workbooks or create additional tables while ensuring seamless operation through automatic deletion.
That's exactly right! You've summarized the two main approaches perfectly: For Enterprise users: Passthrough tables automatically handle data in batches and delete older rows, allowing you to process datasets larger than 50,000 rows continuously. For other plans: You'll need to split your HubSpot list into smaller chunks under 50,000 rows each and import them into separate Clay tables. The passthrough workflow is: send data to Clay → enrich in Clay → send back to your system → automatically delete from Clay to make room for more data.
I don’t have enterprise so i will opt to split the list in HubSpot
That's a great approach! Splitting your HubSpot list into smaller chunks under 50,000 rows each is the recommended solution for non-Enterprise users. You can divide your large dataset based on logical criteria and then import each portion into separate Clay tables to work around the 50,000-row limit.
Yup, splitting inside HubSpot works best here just make sure each chunk stays under 50k, then you can import them into separate Clay tables and later merge or reference them if needed. That way you avoid hitting the table cap