Dear Make community,
I’m having trouble connecting creating a link between our Hubspot CRM and Notion project management system. Basically, the goal is to create a link between the two apps, so that the owners of deals in Hubspot gets synced to th
e corresponding projects in Notion.
What I can’t figure out, is how to translate the Hubspot user to the correct Notion user. I have the email, which is common denominator between the users in each system, but I can’t figure out how to translate the Hubspot email into the correct Notion UUID. I’ve tried with filters and AI, but cannot find a reliable solution.
Screenshot of my current setup, which has gotten quite unmanageable, and still doesn’t accomplish my goal.
Maybe there are some other lookup or match functions that I am not aware of. I appreciate any suggestions and inputs. Thank you.