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

[Jamilah_Duarte]

What is your goal?

I want to filter the router to emails since calendly bookings used round-robin so it used 4 emails to book a call.

What is the problem & what have you tried?

But unfortunately I am having issue and error on the router filter.

Error messages or input/output bundles

no error but no data sync to the google sheet

Screenshots (scenario flow, module settings, errors)

[Stoyan_Vatov]

Hey Jamilah,

can you share what the filters look like and what the incoming data trying to get through them is?

[Jamilah_Duarte]

here @Stoyan_Vatov

The data should pull the name, email, phone number.

[Jamilah_Duarte]

like this (date,name,email, phone number)

[Stoyan_Vatov]

OK and when you run it what does {{13.user}} look like? What data is in there?

[Jamilah_Duarte]

Here sir

[Jamilah_Duarte]

it is shows successful but still no data added on googlesheet

[Stoyan_Vatov]

Um no it doesn’t. It shows there was no array incoming. I’m not sure what the Event Membership array is supposed to contain but it has no values for this specific event.

Check the input and see which specific variable denotes the assignee and what the possible values are.

[Jamilah_Duarte]

Is it okay to use watch event {event membership} because that’s only has data/values. i use get an event {{event membership} before

Calendly - Google Sheet Workflow - Make.com Automation Scenario

[Jamilah_Duarte]

I am not really sure what should i put on iterator

[Jamilah_Duarte]

I tried to used other iterator

but it gives me error

[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

[Jamilah_Duarte]

hi @samliew i am using it now. and I will test it thank you!