Gmail - Make - Notion Contacts Database

Hi - I am currently trying to create an automation which:

  1. Collects all email addresses from new incoming emails, into a Notion database. Sender, Recipient and CC addresses.
  2. Adds a link of the email to the corresponding address.

If the email address already exists within the database, I would simply like it to append the link to the existing database entry.

When I send an email, someone replies and I reply back etc.. I’m not sure if the link to the email changes. Either way, I would like to find a way to prevent the same email from being linked multiple times to the same address.

I have managed to create a connection to my notion database and linked my private gmail to my make account.

I have tried creating a workflow, but it hasn’t been working out very well. For reference please check out attached image.

I have been confused about a couple of things, for exmaple:

To compare the existing database entries to the new incoming email addresses:

  • The notion search node seems to extract all information and not simply the needed property values. How can I make a workflow around that?
  • Does the notion “Get a database item” only retrieve one item? It’s not letting me select an array

I don’t yet quite have an idea for how the workflow could look, Im kind of piecing it together. If you have a better / cleaner idea for one, please share.

I looked online and couldn’t find anyone making a similar workflow. Please link me material you think would help.

1 Like

Hey @Nomad_Family_Office

Aggregate data from notion and gmail and iterate from Gmail then like you did already. No before adding data to notion, add a filter saying i.e {{map(Array from notion;link}} DOES NOT CONTAIN id/link from iterator.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation