Data Mapping Formulas

Questions
1

:bullseye: What is your goal?

Backstory: Workflow - after Google Gemini creates a Google Doc with meeting notes, my Make Workflow uses the Doc to create a page in OneNote that summarizes the meeting.

Actual goal: Create a page in OneNote with the following naming convention: Interview Notes - First Last name

Note: first last name is a placeholder for the actual person’s name.

:thinking: What is the problem & what have you tried?

I’ve partnered with Gemini to come up with the correct syntax and am tired of having my time wasted.

This is the current data mapping which didn’t work: Interview Notes - {{replace(1.name; " /^.\s\S\s+([^<>]+?)\s<>.*/ "; " $1 ")}}

:clipboard: Error messages or input/output bundles

There are no error messages. The workflow just keeps creating the wrong title when the page is created.

This is an example of the title of the Google Doc. “Solutions Engineer @ Company name - Jim Jones <> Johnny Cash Connect - 2026/05/28 15:00 PDT - Notes by Gemini”

The workflow is supposed to parse out the data from the title of the doc to create the page in OneNote.

Any help or recommendations here would be greatly appreciated!

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

Screenshot 2026-05-28 at 4.48.52 PM.png
Screenshot 2026-05-28 at 4.48.52 PM.png1779Ă—887 95.7 KB

4

Hey John!

Can you try to use this formula in the OneNote title field:

Interview Notes - {{trim(replace(1.name; /.* - ([^<>]+) <>.*/; “$1”))}}

This will pull the person’s name from the Google Doc title and create the OneNote page title in the format Interview Notes - First Last name.

For your example:
Solutions Engineer @ Company name - Jim Jones <> Johnny Cash Connect - 2026/05/28 15:00 PDT - Notes by Gemini

The result will be:
Interview Notes - Jim Jones

6

Hi @johnai.tech - thanks for your help!