I am trying to link google calendar with my table so that when a prospect who is already in my table takes an appointment with me, the time and date of the appointment appears in a column.
The way I thought I’d do that was creating an automation like this
trigger = new event in google calendar
1st action = find the record where the email address matches with the event attendees
2nd action = update the record found in the 1st action with starting date and time
but I can’t select the condition of 1st action as the dynamic variable “attendee”
any tips to succeed in my project?