Make.com X bubble

Questions
1

I have an automation in make.com that watches email that have been received(see from attached screenshot) and i am using chatgpt to structure the data received to data that bubble database can understand(which works as expected).The challenge is part of the data is a company name (emails are received from different companies and this company already exist on bubble database) and i need to match that company name(in make) to a company with the same name .
Does anybody know a better approach to this situation?

image
image1753Ă—810 96.4 KB

This is the database i want to change(Alias-company=name received from make) to match field name(company=already existing companie on bubble database
image
image1324Ă—270 29.8 KB

2

Since this involves a company, it’s best to match based on email domain—excluding generic domains like Gmail, Outlook, etc.

Alternatively, you can maintain a list of known senders associated with a company. This can be done by linking contacts to companies or simply storing a list of emails per company. You’d then match the email sender to this list and identify the related company.

The most robust approach to managing contact data is to use separate tables for:

  • Contacts
  • Contact Info (emails, phone numbers)
  • Companies
  • Company-Contact Relationships

This structure offers several advantages:

  • A contact can have multiple emails and phone numbers.
  • You avoid having a cluttered database with dozens of phone/email fields.
  • You can still add a primary phone/email to the contact/company for quick reference (either linked record or text)
  • You maintain a history of a contact’s association with a company, including start/end dates and roles.
  • Contacts can belong to multiple companies.
  • You can accurately match incoming emails to a contact and their associated company, even if they use different known email addresses.
1 Like
3

This topic was automatically closed after 69 days. New replies are no longer allowed.