I have created a zap between Google calendar and Gmail, to email upcoming guests for my podcast 48 hours before the recording, providing them with some information.
The calendar entry is populated from Calendly.
The issue I have is that I have the the fields/info I need but have one problem with the name of the guest. The only place their name is added to the calendar entry is in the Title, but Calendly also adds in the title is the guests name plus my name, so it reads for example:
“John Smith and Tony Winyard”
When I setup the email on gmail to be sent to them, and start it with “Hi”, it then adds:
“Hi John Smith and Tony Winyard”
which is weird from the guests' perspective, as they’ll be wondering why I’m emailing myself!
is there any way of filtering out my name from that result, so that it only adds their name, and ideally just their first name?
Best answer by Troy Tessalone
You can use the Formatter > Text > Split step to do this: https://zapier.com/help/doc/how-use-formatter-functions#using-split-text
You can use the Formatter > Text > Replace step to do this: https://zapier.com/help/doc/how-use-formatter-functions#using-replace