@Sroncoroni I can give a solution for your use case, however I’ll need a bit more detail to make sure it’s accurate and flexible enough. I know it’s a few questions, but they’ll help me tailor the approach properly.
- What type of object on HubSpot are you working with, Contacts, Deals, Tickets?
- Is it a single object, or you need to add associations too?
- When you say ‘sync’ what do you mean, is it adding totally new records, updating existing records, deleting records that no longer exist, or some combination?
- Does the Excel data include a unique identifier that can be used to match with existing records?
- How often do you want this sync to run?
- How many rows are you working with for each update roughly?
- Where are you storing your Excel file?
- What level of HubSpot subscription do you have?
- What Power Automate license do you have?