Would love this feature. Seems simple enough to not allow blank notes to be imported to start with also... It's almost like a bait and switch, since it's counterintuitive to think that HubSpot would've imported blanks by default.
Yes, deleting value in Notes Body in Bulk is a vital feature. Bulk imports does have a scope of error so whenever a wrong value is updated that we do not want to be there in Notes. We are in for a big trouble with manual deletion. Please introduce this feature on a priority.
Hi everyone! I recently had a Zap ran amok and created thousands of junk notes (stuck in a loop) in HubSpot. This obviously created a need to somehow batch delete notes:
Use HubSpot reports to generate a spreadsheet of all the notes you want to delete. Unless you want to purge your entire CRM of notes, filters are your friend. Make sure you include Record ID in the report before you export.
Export the report. Copy the resulting CSV data into Google Sheets.
Convert the Record IDs (currently in spreadsheet cells) into a block of JSON code. You'll need them to look like this:
...except with your own record IDs between the quotation marks in the value field, of course.
I used Zapier Transfers to push the Google Sheets data into a Google Doc and format it accordingly.
There are other solutions, but however you do this, it really needs to be automated. You'll spend a horrible amount of time doing this manually if you have more than 50 notes you need to delete.
Log into, or setup an account with, Postman or an equivalent HTTP request service.
I'd like to expand this request by asking HubSpot simply to consider modifying or deleting notes via the existing import process: providing a CSV or XLSX file of notes to modify or delete. Our specific use case: I batch created 127 notes and found that because I'd set the notes to be created at a date in the past, they didn't appear at the top of the activity feed where I wanted salespeople to see them. I adjusted the date in my import file today's date and tried to-reimport but was prevented. The import system stated notes could not be modified.
Update: Using a runner in Postman is an even more time-effective way of modifying otherwise inaccessible records in HubSpot.
@Edsby In your case, you can delete all the notes you created using a Postman HTTP request and runner and then import them again using the correct create date values. You can set up your Postman call as I described above, except this time use the "runner" feature to have Postman run through a CSV file with your note IDs.