Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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!

Hi @dershea 

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

 

 

@dershea 

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.

 

@dershea 

Your Zap step 2 config should look like this:

 

It already does

 

 

@dershea 

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.

@dershea 

Can you share screenshots with how Step 3 is configured?

 


Sure, here is all of step 2 above and then Step 3 below. I already have another Zap that adds new calendly entries to a new row so there are no issues with the permissions.
 

 

 

 

@dershea 

This mapped variable needs to be a number

 

Use this variable

 

Thank you Troy, Here is what happens when I test this:

 

 

@dershea 

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?

@dershea

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.

 

 

@dershea 

Did you successfully test Zap Step 2?

This shows an example value of “Value in column G”, but the Zap expects as numerical value.

 

Terms & Conditions