About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Notion hit an error: Body failed validation, body.properties.Attendees.people[0].id should be valid uuid

  • 7 June 2023
  • 9 replies
  • 765 views
Ibon

Hi there!

 

I am trying a very simple integration between Calendar and Notion. Expected behavior: google Calendar events create a Meeting in Notion.

 

All is good, except that the Notion integration expects me to manually add the individual emails of the people attending, and Google Calendar only allows me to choose between fields called “Attendees Email” and “Attendees Emails”, both of which are arrays. 

 

 

When running it, the integration fails at the attendees part, with the error below.

 

 

Am I doing something wrong or is there a better way to extract the attendee list from the Calendar event?

icon

Best answer by ken.a 9 June 2023, 06:10

View original

9 replies

SamB
Rank
Userlevel 7
Badge +11

Hi there @Ibon! 👋

That error seems to suggest that the field is looking for an ID (unique identifying) number for the attendees instead of the email address. If you click into the Attendees field on the Notion action does it give you a list of people that you can choose from?  

If so, there will likely be an ID number of some kind that appears in grey underneath the person’s name. For example: 
66337f97c9962d6f645db0630356178b.png
In which case, since you’re looking to select multiple attendees I think you might need to explore adding a Formatter (Utilities > Lookup Table) action to the Zap to convert the email addresses into the relevant names. 

You could also potentially try adding a Find Database Item action before the Create Database Item to search for the people and obtain the relevant IDs. But, I’m not certain whether that would get you the ID. And as that action would only find one you’d need to use a Looping by Zapier action to go through each one but that would then result in multiple database items being created (as that action would need to be put within the loop, it can’t be run afterwards), which wouldn’t be ideal. So I think the lookup table might be your best bet here, what do you think?

Look forward to hearing from you on this!

Ibon

Hey @SamB thanks for the reply!

Well, if I understand correctly, using the lookup table would give me the Notion IDs for the attendees in the calendar meeting, but then how would I handle that? How could I automatically add three ID attendees in Notion if only three people are invited to the meeting? And if that number changes to five? The attendee count and attendee IDs are variable per meeting, and I can’t be expected to update this automation manually every time - that beats the purpose of the automation.

 

chanelle
Userlevel 7
Badge +8

@Ibon Jumping in to see if I can help or create a possible work around. I want to be sure I understand the screenshot. Are each of the items crossed out individual attendee names? 

Ibon

Hey @chanelle - yes, those are individuals. And as soon as I add one, a second box is enabled for me to add the next attendee. Thanks!

 

 

ken.a
Userlevel 7
Badge +6

Hi there @Ibon,

I’m jumping in to see if I can help!

In your case, I would recommend combination of Formatter, Lookup Table, and Looping by Zapier.

  • Text in Formatter by Zapier - Split Text *Segment Index* All (as Line-Items) - this way you can split the multiple email attendees as line items.
  • Looping by Zapier Create Loop From Line Items- to repeat action(s) in your Zaps a variable number of times for sets of values. 
  • Utilities in Formatter by Zapier - Lookup Table function - format the email address to the ID in your Notion app.

Here’s a similar Zap that I have created minus the Lookup table step:

Outline of the Zap setup:

15835a281f7c16706168d5a577c36d18.png
(view larger)

Formatter step setup:

0b4794948400fe7fe2b4730a98082347.png
(view larger)

Formatter Output:

ecd76b4e07e7acd6b36c53036bbc0c78.png
(view larger)

Looping by Zapier setup:

010f5cb2205a85391b249c45df5f3b26.png
(view larger)

Google Calendar action and “Attendee” field setup:

cd53c73f89e57533a63c8214acfbb6eb.png
(view larger)

If you want to learn more about Looping by Zapier. We have an in-depth guide on this Community post here:

Hopefully, this points you to the right direction! 😊

Ibon

Hey @ken.a thanks for jumping in!

That was sort of the direction @SamB was heading to with the first response, but that would create multiple calendar events, one for each attendee. Three attendees, three events. Five attendees, five events.

I feel like I’m trapped between having to choose between creating multiple clone events (if I choose to loop), or manually adding the attendees every time the automation runs.

I feel like there should be a stupid simple solution that just selecting the atendees json from the calendar trigger is smart enough to understand that I want those attendees to be separate individuals in the Notion project...

ken.a
Userlevel 7
Badge +6

Hi @Ibon,

I can confirm that following the Looping by Zapier route won’t create multiple calendar events.

Here’s what it looks like in the Zap History:

d22a6e5a55f520d12591e00a2ad3ece3.png
(view larger)

3b35b9d6f22280fa55ea5c82a2f2d4ca.png
(view larger)

3f73d4e15069160be97f43b855ecfeff.png
(view larger)

5c238f2c6b72a4bf4fbbf8b87f40d460.png
(view larger)

And here’s the event created in Google Calendar:

0eef6e4a3a5b84380d03186319eed10e.png
(view larger)

Hopefully, this helps! 😊

Ibon

Thanks again for the reply!

 

So I tried this, and if I do it with a Detailed Google Calendar event like in your example, the iterating element, Emails, does show up as a value for Attendees

 

However, if I use the Notion integration, this will not be an option, at all. Both were created under the same loop. Any ideas?

 

ken.a
Userlevel 7
Badge +6

Hi @Ibon,

After doing some testing similar to your workflow on my end, I've hit a bit of a snag. But don't worry, we have a fantastic Support team who are experts at solving these kinds of puzzles! They can provide you with 1:1 support and have the ability to access your Zap and its logs, which will be super helpful.

When you reach out to them, it would be great if you could link them to this post. That way, they'll be up to speed on the troubleshooting steps we've already taken.

You can get in touch with our Support team right here: https://zapier.com/app/get-help

I'm really sorry I couldn't solve this one for you myself, but I'm confident our Support team will be able to assist. Thanks so much for your understanding.

Reply


Terms & Conditions