Google Sheet instant tracking changes specific column

How To
1

Hi Community,

I have a Google Spreadsheet that contains 12 sheets – one for each month of the year. I need a solution that can track whether a new value has been entered in any cell in column “K” across all these sheets. The values in column “K” are entered by a script/function, not manually by a person.

The “Make for Google Sheets” extension and the “Watch changes” module do not meet my requirements because they only allow tracking changes in a specific sheet (e.g., January).

Unless there’s a way to automatically switch the sheet being tracked within this extension?

Do you have any ideas on how I can solve this complex problem?

2

Welcome to the Make community!

There are at least two ways to do it.

The first is you’ll need to write a Google Apps script (which is very advanced level).

The second is you can try using a “List Sheets” module, and then “Get Range Values” to see which row has been recently created/modified based on a new “Timestamp” column.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

1 Like