Calendly Cancellations with Google Sheets

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?

@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.