I’m trying to create a scenario whereby I have all Salesforce Opportunities in Notion. This is designed to show everyone in the business, not just salesforce users, the sales pipeline and how we engage with our clients.
Whilst I have an ‘Opportunity’ DB in Notion that replicates Salesforce Opportunities, I’d like to validate the owner of the opportunity in Salesforce with their equivalent user account in Notion.
Do anyone have any ideas about how to achieve this? Essentially, I need to take Salesforce OwnerID and marry it to a Notion UserID using their email address.