Hi - I am currently trying to create an automation which:
- Collects all email addresses from new incoming emails, into a Notion database. Sender, Recipient and CC addresses.
- 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.
