How to pull new booking data of calendly on the google sheet?

[samliew]

Welcome to the Make community!

Issue #1

I believe you need to use the “Event” variable here, not “URI”.

Issue #2

You do not need an Iterator module here. DELETE IT.

An Iterator module is for ARRAYs. You are mapping a COLLECTION into it.

Simply delete this module as you do not need it.

Issue #3

Finally, you want to compare all the user_emails within the ARRAY event_memberships.

This is how your filters should be set up:

NOTE:

• use the map function to extract all the user_email from the array of collections.
• use the “Array operator”, not Text operator.

Issue #4

You are incorrectly using a fallback route. Set it to NO.

---

I’d highly recommend going through the Make Academy if you haven’t yet!

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Learn Make

• Help Centre | Tutorials – Make’s “manual” - search for help here first
• Make Academy – Basics 101: Learn Make properly to get your money’s worth
• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

How-Tos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Aggregate an array for mapping complex fields
• Getting started with OpenAI - How to setup and use OpenAI in Make
• Text Parser module - Use pattern matching to extract the text you want
• Webhooks – Make Academy - tutorial on how to use Webhooks

Hope this helps! If you are still having trouble, please provide more details.

— @samliew