Automation Solution for Transferring Emails to Notion Database Pages in the Notes Section

Solution:
[Webinar] Triggers & Functions/Condition logic:
[Webinar] Triggers & Functions – YouTube

Mapping Logic To Isolate:
Name & Subject Title

The Substring function extracts a specific portion of a string, defined by the starting and ending positions. In this case, it indicates the starting position.

The Index of function is utilized with a “(” as a marker to capture everything following this point. The addition of “+1” is employed to exclude the “(” from being included in the output.

The Length function dynamically captures the entire length of the entry. Subtracting 1 is then applied to exclude the “)” from being included in the output.




I used outlook rules to automatically trigger my automation based on my (3 letter) unique key.

Issues:
I am in the process of fine-tuning my search filters as numerous Page IDs are currently linked to my subject line. However, the code should be designed to function seamlessly with any subject line that contains 3letters as a unique key to indicative the beginning of the string within parentheses () before specifying the recipient’s name associated to the PAGE ID.

Hope this helps.

3 Likes