Skip to main content

Hi everybody,

I'm using Calendly and Gmail to send event invitations to my contacts, and Google Agenda to manage my meetings.

I send a lot of Calendly invitations and I would like to be alerted when somebody does not book an event after having received such a invitation. For example, I would like to receive an alert maybe one week after sending my invitation.

I thought I could do it using a Google Spreadsheet :

I’ve done a first Zap that ads a row in a Google Spreadsheet each time I send a Calendly invitation to a contact using Gmail. It works fine :)

Now, I would like to do a second Zap that would delete the right row in the spreadsheet each time an event is added to my Google Agenda with a contact email that is already in my spreasheet. So my spreadsheet will only have email adresses that did not answer to my Calendly invitations.

I’ve tried to do such a Zap using the “New Event in Google Calendar” condition, but I don’t understand how I could get the contact’s email adress and then delete the right spreadsheet row :thinking:

Please could somebody help me doing this ? Or maybe there’s an easier solution to solve my need using Zapier ?

Thanks for your help !

Action: GSheet - Lookup Row


Oky Troy, I’ll check this. Thanks a lot :)