For teams that run on HubSpot
HubSpot data cleanup, every week
Forms, imports and colleagues fill in fields in their own way: NL, Netherlands and Holland, names in capitals, a company typed on the contact but not linked. Cleaning it up is a task that comes back each week.
How it goes today
- Export the new contacts of the week.
- Fix country names, capitals and phone formats in a spreadsheet.
- Import the file again to update the records.
- Check afterwards that nothing was overwritten by mistake.
How it can go
A weekly round of fixes for country, name and company fields, after you approve them.
Each week you get the proposed fixes for new and changed contacts and companies: one spelling per country, names and job titles in normal capitals, phone numbers in one format, and contacts linked to the company that matches their email domain. You approve them per kind of fix, and they are written to HubSpot with a list of what changed.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your HubSpot key in the portal, never in the chat.
With Hypamoon, every Monday, check the contacts and companies created or changed in our HubSpot last week. Propose fixes: one spelling per country, names and job titles in normal capitals, phone numbers in one format, and contacts linked to the company that matches their email domain. Apply the kinds of fix I approve and send me what changed.
A super admin creates the HubSpot service key under Development, Keys, and picks what it may read and change. It stays yours.
More for teams on HubSpot
- I merge duplicate contacts one by one.
- I clear old tasks by hand after a deal or ticket closes.
- I clone won deals by hand to set up the renewal.
- I change our workflows every time someone goes on holiday.
- I compare last week's deal export with this week's to see what changed.
- I work out our ticket times in business days in Excel.
- I add the contacts of a company to each new deal by hand.
- I export our HubSpot reports to send to people without a login.
- I take our own test entries off the form counts every month.
- I move contacts to another company one by one.
- I calculate our stage conversion rates by hand.
- I copy notes and calls out of HubSpot record by record.
- I move open tasks by hand when records change owner.
- I check by hand which won deals have no products.
- I go through the pipeline by hand to find deals that went quiet.
- I calculate commission from HubSpot exports in a spreadsheet.
- I export each object from HubSpot by hand to keep a copy.
- I add the country code to phone numbers by hand.
- I set the subscription by hand for people who already confirmed.
- I track the time zones of my contacts in a spreadsheet.
- I write the formal greeting by hand for each contact.
- I split full names into first and last name in a spreadsheet.
- I cannot show what a form said when someone signed up.
- I type our exchange rates into HubSpot by hand.
- I rename product lines by hand on quotes in other languages.
- I check customer VAT numbers by hand on the VIES site.
- I add the VAT rate by hand to each line.
- I rebuild HubSpot invoices elsewhere to send an e-invoice.
- I make our invoices again elsewhere to get a Factur-X file.
- I link branch records to their parent company one by one.
- I look up each customer's prices and change the deal lines by hand.
- I keep the reseller and end user in text fields on each deal.
- I build our Gift Aid claim in a spreadsheet from HubSpot exports.
- I export HubSpot to a spreadsheet every week.
- I copy deal details into our contract template by hand.
- I tick off event attendees by hand from a list.
- I keep a branch per postcode in our workflow to route leads.
- I number our deals by hand from a counter in a spreadsheet.
- I work out renewal and follow-up dates by hand.
- I keep prepaid hours in a spreadsheet next to our tickets.
- I print the notification email to keep a copy of each form.
- I copy NPS scores from another survey tool into HubSpot.
- I work out deal margins in a spreadsheet.
- Everything for HubSpot