Calendly and google sheets look for previous meetings

[Oleksandr]

Hi everyone,
I have 2 Google Sheets: One for Booked meetings and One for Cancelled meetings.

When I receive a new booking, I'd like to check in the cancelled meetings if it has been previously booked (by looking up the email)
I'm struggling to understand how to correctly build this, so I'm a little confused about maybe the filter function, or the correct option in Google Sheets.

 

[PabblyMember4]

Hey @oleksandr

For this scenario you can use Google Sheets - Lookup Spreadsheet Rows action for finding the email exists or not.

Kindly let us know if you have any questions or comments.

 

[Oleksandr]

thank you, what I tried before your reply, is creating a vlookup formula that checks for the email (yes/no) and a scheduler to run every 1 day and if yes, send a message, but now I realized a new problem: it will run on ALL the rows (old and new ones), so how can I prevent the tool from checking old (already checked) entries and only focus on new ones?

 

[PabblyMember4]

Hey @oleksandr

You can include an extra column in your spreadsheet let's say "Meeting Attended" and give the value as Yes or No. After this you can add a filter condition in your workflow that will check if the "Meeting Attended = No" and then the lookup table will check the value in it else they will skip this row.