# Limiting scenario runs with Google Sheets Watch Change module

**URL:** <https://community.make.com/t/limiting-scenario-runs-with-google-sheets-watch-change-module/35609>\
**Category:** Questions\
**Tags:** google-sheets\
**Created:** [April 30, 2024, 1:41pm UTC](https://community.make.com/t/limiting-scenario-runs-with-google-sheets-watch-change-module/35609 "2024-04-30T13:41:27Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alberto.Cabas.Vidani](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@Alberto.Cabas.Vidani](https://community.make.com/u/Alberto.Cabas.Vidani)\
**Post date:** [April 30, 2024, 1:41pm UTC](https://community.make.com/t/limiting-scenario-runs-with-google-sheets-watch-change-module/35609/1 "2024-04-30T13:41:27Z")

</div>

I use the Watch Changes trigger to add or update contatcts added to a Google Sheets to Brevo.  
The scenario is triggered every time a cell is updated. So it runs a few times for every row.

How can I limit the runs?

---

<div class="post-metadata">

**Author:** ![Donald\_Mitchell](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/donald_mitchell/32/8749_2.png) [@Donald\_Mitchell](https://community.make.com/u/Donald_Mitchell)\
**Post date:** [April 30, 2024, 2:23pm UTC](https://community.make.com/t/limiting-scenario-runs-with-google-sheets-watch-change-module/35609/2 "2024-04-30T14:23:17Z")

</div>

Hello @Alberto.Cabas.Vidani,

I don’t think there’s a great way to handle this because of what Google Sheets is and how it works.

Rather than monitoring the entire range you can try to limit it to monitoring a single column.  
Just be sure to update that triggering column last when you update a row.

---

<div class="post-metadata">

**Author:** ![Alberto.Cabas.Vidani](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@Alberto.Cabas.Vidani](https://community.make.com/u/Alberto.Cabas.Vidani)\
**Post date:** [April 30, 2024, 3:48pm UTC](https://community.make.com/t/limiting-scenario-runs-with-google-sheets-watch-change-module/35609/3 "2024-04-30T15:48:59Z")

</div>

Thanks. I guessed so.  
I have to monitor multiple sheets. So I can’t specify a single one to monitor.  
If I specify a column, but not a sheet, will it monitor the same column on all sheets?

---

<div class="post-metadata">

**Author:** ![Donald\_Mitchell](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/donald_mitchell/32/8749_2.png) [@Donald\_Mitchell](https://community.make.com/u/Donald_Mitchell)\
**Post date:** [April 30, 2024, 4:04pm UTC](https://community.make.com/t/limiting-scenario-runs-with-google-sheets-watch-change-module/35609/4 "2024-04-30T16:04:34Z")

</div>

I suppose you’re right, if you specify a range you must then also pick a specific sheet, but honestly I’ve never tried this so I can’t confirm.

Another option you have is to look at every change and use a filter after the trigger module to only proceed when specific columns are not empty.

Since you’ll be monitoring different sheets, if they all have different structures, maybe add a router after the trigger module and use a combination of filters and routes.

---

<div class="post-metadata">

**Author:** ![Alberto.Cabas.Vidani](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@Alberto.Cabas.Vidani](https://community.make.com/u/Alberto.Cabas.Vidani)\
**Post date:** [April 30, 2024, 7:12pm UTC](https://community.make.com/t/limiting-scenario-runs-with-google-sheets-watch-change-module/35609/5 "2024-04-30T19:12:12Z")

</div>

Thanks, this is exactly what I was thinking.

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [May 23, 2024, 7:54am UTC](https://community.make.com/t/limiting-scenario-runs-with-google-sheets-watch-change-module/35609/6 "2024-05-23T07:54:09Z")

</div>


