# How do I monitor changes in all the sheets within a Google spreadsheet?

**URL:** <https://community.make.com/t/how-do-i-monitor-changes-in-all-the-sheets-within-a-google-spreadsheet/29567>\
**Category:** Questions\
**Tags:** google-sheets\
**Created:** [March 5, 2024, 1:37pm UTC](https://community.make.com/t/how-do-i-monitor-changes-in-all-the-sheets-within-a-google-spreadsheet/29567 "2024-03-05T13:37:59Z")\
**Posts on this page:** 4\
**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:** [March 5, 2024, 1:37pm UTC](https://community.make.com/t/how-do-i-monitor-changes-in-all-the-sheets-within-a-google-spreadsheet/29567/1 "2024-03-05T13:37:59Z")

</div>

A client has a spreadsheet with multiple sheets. She adds prospects to different sheets and then has to add them to different lists in Brevo.  
The current solution is to create a scenario for each sheet, but this means dozens of scenarios. Is there a way to monitor new rows in any sheet and then route them to the correct list in one single scenario?

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [March 5, 2024, 1:54pm UTC](https://community.make.com/t/how-do-i-monitor-changes-in-all-the-sheets-within-a-google-spreadsheet/29567/2 "2024-03-05T13:54:39Z")

</div>

That’s what the Watch Changes trigger in Google Sheets is for.

If you leave both fields empty, it sends all changes in all sheets.

 ![Screenshot_2024-03-05_210315](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/a/2ac2537c9314d73f135dd8b4d9d76a777db5b3bb.png)

For more information, see

- [https://www.make.com/en/help/apps/productivity/google-sheets](https://www.make.com/en/help/apps/productivity/google-sheets)

- [Watch Changes](https://www.make.com/en/help/apps/productivity/google-sheets#watch-changes-964718_body)

- [Make for Google Sheets add-on installation](https://www.make.com/en/help/apps/productivity/google-sheets#make-for-google-sheets-add-on-installation_body)

- [Connecting the Instant Trigger module to a Google Sheets spreadsheet](https://www.make.com/en/help/apps/productivity/google-sheets#connecting-the-instant-trigger-module-to-a-google-sheets-spreadsheet_body)

---

<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:** [March 5, 2024, 3:45pm UTC](https://community.make.com/t/how-do-i-monitor-changes-in-all-the-sheets-within-a-google-spreadsheet/29567/3 "2024-03-05T15:45:10Z")

</div>

Thank you for the quick reply.  
I already saw this trigger but had a doubt. Every change to the worksheet triggers it. But every time the client inserts a row, she changes several cells. So how do I avoid running the scenario multiple times for every row?

The only option for me seems to do a check which cell is changed. But I can’t get the column letter from the Watch Changes trigger, right?

---

<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:** [June 3, 2024, 2:49pm UTC](https://community.make.com/t/how-do-i-monitor-changes-in-all-the-sheets-within-a-google-spreadsheet/29567/4 "2024-06-03T14:49:12Z")

</div>