Tracking when a google sheet tab is opened

Question

I am trying to create some metrics regarding how often people are using different sheets in my spreadsheet.

I have an On Open trigger that fires properly whenever someone opens or refreshes the spread sheet. Once the sheet is opened however, I would like to track each time they click a tab and go to another sheet. The simple On Open trigger does not fire when spreadsheet tabs are clicked.

Is there a trigger or another method that would allow me to track tab usage?

Answer 1

We could use the edit and change installable triggers to track some changes made to sheets but they can't track certain users actions like opening a tab o clicking on a cell, among other actions.

References

• Available types of triggers
• Spreadsheet Service