Google Sheets Button to Trigger Scenario

[fabianlim]

Hi,

I want to trigger a scenario in Google Sheets via a button.

Have created the Button (assigned it to the function), the Script via AppsScript and added a WebHook as a trigger in the Scenario:

The issue I am facing is after I click on the Button, the Scenario does not run at all.

To get the Scenario to run, I need to click the ‘Run Once’ button at the bottom of the Scenario and let the Scenario wait for new data. Only then when I click the Button in Sheets does the Scenario run.

Which part of the configuration did I not setup correctly?

Thanks in advance.

[Abhishek]

Hey @fabianlim

You are doing everything correctly.
You simply need to activate your scheduling

[fabianlim]

That worked, @Abhishek!

Thank you so much!

Would be good if admin updated the instructions here:

https://www.make.com/en/help/app/google-sheets#add-a-custom-button-in-a-sheet-to-trigger-a-scenario

Thanks again!

[samliew]

Welcome to the Make community! I’m glad you got that sorted.

If you want to learn more about Make, you can read up in the Help Center. I also recommend doing the tutorials in the Make Academy, and learn advanced skills like how to make custom apps to any API in the Make Partner Training Portal - both have certificates for successful completion.