CRM migration
Bringing support history into HubSpot.
A support ticket needs the conversation behind it. I built import tooling to bring historical requests, replies, and internal notes into HubSpot, linked to their tickets.
- What I built
- CSV validation, ticket matching by source ID, and a note builder that keeps each request, reply, and internal comment together.
- A decision in the design
- Match the tickets before creating the notes. If a ticket cannot be found, put the source record in an exception report for review.
- How it can be checked
- A preview run resolves ticket matches and prepares notes without creating them. Run summaries count matched, missing, created, and failed items. Automated tests cover CSV parsing and date conversion.
- Read the exportsCheck the columns. Prepare the text and dates.
- Match the ticketUse the source ID to find its HubSpot record.
- Attach the historyCreate a note with the request, reply, and internal comments.
Preview the import first.