I have an external Excel spreadsheet with a list of companies attending an event. I have matched this against our Hubspot database to see which Companies we currently have as records (so we can email them to tell them we are at the event).
I have a list of Company Record IDs that I want to email (around 300 records). But when creating a list, there is no way of adding a large amount of Record IDs to the filter to create the list.
Alternatively, I have also tried re-importing using only Company RECORD ID so I can then create a list. But it doesn’t let me do it.
We come across this requirement a lot, but there doesn’t seem to be a streamlined and clear way to do it.
Hi @Rob-Clued,
@Rob-Clued wrote:
I have a list of Company Record IDs that I want to email (around 300 records). But when creating a list, there is no way of adding a large amount of Record IDs to the filter to create the list.
Have you tried this semicolon “hack”? https://community.hubspot.com/t5/CRM/Filtering-a-view-with-a-comma-separated-list-of-company-IDs/m-p/381499/highlight/true#M122895
Best regards!
Yes. This is what I have been searching many times for. A combination of the semi colon and create a new property and workflow has solved this issue.
Would be great if Hubspot implemented something to avoid the slight ‘hacky’ nature of this issue.
Nevermind answered my own question
(how do I delete posts on here though?)