Need HubSpot data in Supabase
Our customer portal runs on Supabase, but the sales team keeps everything in HubSpot. Right now support exports companies and deals every Friday, cleans the CSV, and uploads it. The portal is already out of date by Monday, and merged contacts sometimes return as duplicates. How can we keep HubSpot contacts, companies, and deals synced so the import doesn’t need to be rebuilt every time someone adds a new property?
Weekly CSV uploads are the reason the portal is always behind. They also make duplicates almost inevitable once someone edits or merges a contact in HubSpot. Use the HubSpot record ID to match existing records in Supabase, then copy only the entries that changed after the previous update. Keep companies, contacts, and deals in separate tables so one change doesn’t overwrite unrelated information.
The hourly sync is the easy part. Problems start when the sales team adds another custom property and the destination no longer matches what HubSpot sends. An AI database service can model the CRM entities and keep incremental updates landing in the correct Supabase tables. You can use an AI database here: http://datrise.com/ . Begin with companies and deals so the first validation stays small. Compare one day of changes against HubSpot before adding contacts and activity history.