Hi everyone, I want to setup a trigger so that when a calendly event is rescheduled or cancelled, it automaticaly updates the google sheets row of cancelled to “TRUE”. I have been trying to reference the row through the UUID (unique event id created by calendly) but I am not having any success with it. Has anyone done this before? Thanks!
Best answer by Troy Tessalone
View original
+14
Hi
Please post screenshots with how your Zap steps are configured for us to have context, thanks.
Thank you, I have 3 steps to it
Step 2 isn’t working, it is not finding any info from the database.
And my database
+14
You need to map a variable using the ‘custom’ option from the Zap trigger step to this field instead of using a static value.
Check this help article: https://zapier.com/help/create/basics/set-up-your-zap-action#set-up-your-action
Which field exactly are you referring to that I should change in screenshots I sent? I tried to change the “Lookup Value” in Step 2 but there is no option for a custom field.
+14
Your Zap step 2 config should look like this:
It already does
+14
Have you reviewed the available help articles for using GSheets in a Zap?
https://zapier.com/apps/google-sheets/help
In particular this one: https://zapier.com/help/doc/google-sheets-error-writing
Yes, I am doing all of the things mentioned in this article you sent.
+14
Can you share screenshots with how Step 3 is configured?
+14
This mapped variable needs to be a number
Use this variable
Thank you Troy, Here is what happens when I test this:
+14
For Step 3 in the Zap, for the Row field, you need to make sure this variable is mapped from Step 2.
I don’t understand, what exactly do I need to change in order to do this?
+14
You Zap Step 3, should look like this:
Please reference this GSheet help article: https://zapier.com/help/doc/finding-and-updating-rows-in-google-sheets
Thanks, I will try this.
+14
Did you successfully test Zap Step 2?
This shows an example value of “Value in column G”, but the Zap expects as numerical value.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
