I use google to manage and schedule my events. I add meetings with contacts as "Meeting with Tolu Osinowo and James Reed". Tolu Osinowo is me so I don't need that parsed. James Reed ared the contact first and last. I will also add the contact's emal address as guest to the google cal as well as their ph to the description. These info then gt into my crm bc I share my google cal with my crm.

I need a function what will 11.

1.pull and parse parse all this info for me and

2.update the contact record with the date and time of the meeting in a field in the contact's record OR create a new record using those same info

What I'm looking for is to be able to

1. search records using emai, 

2. break up the meeting with tolu Osinowo and james reed into James Reed

3 pull the phone from the description into the phone field