Delete Clay table if company doesn't exist in HubSpot

Great question! We don't currently have the option to delete values based on conditions like this but may be part of an update down the road. For now, you can still have a separate view in your table where you filter and surface them, so then you can go into once a week or so and delete them

If you delete the record, yep, the enrichment gets lost. If you don't want to enrich those that don't exist in your CRM, you can still use their Lookup feature to determine if you have them or not, then that can be part of subsequent conditional formulas that only run if they do exist.

Oh, no, if you're filtering and deleting those that you don't want, all the rest should remain in the table.

Yep, then hubspots lookup integration is how you can prevent that since there's no option to auto-delete from Clay yet.

But the issue is that if you do delete it from HS then nothing will come back, so I also understand that. Do you have a DNC list instead?

Maybe that could be a workaround, adding those separately to another Clay DNC table... Here's an example of how to setup a lookup for DNC - https://www.loom.com/share/80d613c10d5248f6bfc662cc95c8023d Based on matches, you can set up conditional formulas so existing records don't get enriched or contacted.

Usually when you delete rows a purple banner to undo it appears at the bottom but if you missed it then happy to add more credits so you can re-run it. Undoing column/enrichments is a bit difficult in the backend so we don't as an option, also maybe because of API calls involved.

Ahh, I see, no filters applied so all were selected instead?

how many records and what enrichments did you have? it could be estimated

Got it, so that enrichment only costs 1 credit per row. I'll add them back so you can run it again.And to clarify, all data in your table is stored there, so if it's deleted from one view it's also removing the source. Views don't make a copy of your data set.

That's why we recommend applying filters to each view, that way you can segment them better and only work with the ones you want to keep

I would only run or re-run this integration after you remove records in your CRM

if you imported the list into Clay before deleting them from hubspot, then that's the way. You can then delete the ones that return as "no company found"

Added the credits back into the account too :)