How do I properly pull information from a google calendar event?

Beginner Questions
, , , ,
1

:bullseye: What is your goal?

I’m trying to pull data from a google calendar event. I’m trying to get the name that is part of the title, a phone number in the event description, and the client email address that is one of three emails that is in the guests (aka attendees) section of the event.
Then sending an email based on that information and logging it in a spreadsheet.

:thinking: What is the problem?

My scenario runs, but does not properly Identify the variables of client’s name, email, and phone number.

:test_tube: What have you tried so far?

At first I tried simply running the google calendar trigger to a set multiple variables module, and have that module identify each piece of information with some code, but I don’t know code very strongly and rely heavily on chatgpt. It keeps suggesting code that doesn’t really work with make. Heres the examples of that:
for email:
first(map(filter({{1.attendees}}; organizer != true and email != “fakeemail@gmail.com”);email))
for name:
{{first(split(1.summary; “”“-”“”))}}
for phone:
match({{1.description}}; “(+?1[\s.-]?)?(?\d{3})?[\s.-]?\d{3}[\s.-]?\d{4}”)

But these didn’t work! I tried to identify which bits of code don’t work with Make but kept going in circles with chatgpt trying to figure it out.

So my next attempt has been running 1.attendees through an iterator and running a text parser to find the phone number in the description and It just doesn’t work for me for reasons unknown. Please help, I’m hitting a wall.

3

Hello,
Welcome to the community!

First of all – you are using non-existing functions

There are no filter() and match() functions in Make. LLMs tend to invent them – they simply do not exist.

You can find list of available functions here:

Why this won’t be as easy as you might think

Google Calendar stores event details in a single description field, and for attendees it only returns email addresses. So if you need a name or phone number, you have to extract it from the description text.

How to solve it

Option 1: Use an LLM – send the description to an AI module and let it extract the name and phone. This is the best approach when the description format varies between events.

Option 2: Use a Text parser module with REGEX – works well only if every event follows a consistent structure.

The easiest long-term fix?

Use a booking tool like Calendly, Zencal, or Cal.com to create events. They use intake forms, so name, phone, and email are always returned in a clean, structured format – no parsing needed.

Have a nice day,
Michal