Update Google Sheet with Calendly Booking

How To
1

Hello makers,

as a recruiting agency, we are generating leads for our clients to hire the best people.
One important step of the process is the qualification of the leads.
One part of it is, that the person has to book an appointment on Calendly to get in contact with the new employer.

Before the person can do that, he/she fills out a form. The data of the form is sent via make to a google sheet. The last column of the data set is called “calendly booking” and is empty after the sign up.
As soon as the person books an appointment (which is only possible through an email, which the person is getting after the sign up) the column “Calendly Booking” should be updated with a check.

Any ideas how I can get there?

Thanks for your answers and sorry If this is too basic :see_no_evil:

2

Hi @personalfix

This looks very simple. You need to watch new Calendly bookings using the “Watch Event” module.

Then, connect the “Get Event” module to get more details - say the email id of the person. This email should be searched in the Google sheet using the “Search Rows” module.

Once found, you can update the corresponding row.

If you need assistance, don’t hesitate to contact me.

Best Regards,

Msquare Automation
:point_right: Visit our website | :spiral_calendar: Book a free consult

2 Likes
3

Thanks @Mohamed_Jahar , worked! Problem solved :slight_smile:

2 Likes