Track Next Client Meeting from GCalendar to a Column in Airtable?

Hi,

I’m not super tech savvy, so I’m just wondering if this would be possible through Automations:

  1. I make an appointment in Google Calendar to meet with a client. The title of the google calendar event will include this client’s name.

  2. When Airtable ‘sees’ that I’ve made a Google Calendar event that matches this criteria (event title includes word “client name”), it can pull the date of that meeting and put it in a column I identify (Next Meeting).

TIA!

What format do the Google Calendar Event names follow? Unless the event name is the Client’s Name by itself you’ll need some sort of script to extract the name out of the rest of the title.