Identify the last edited sheet via google apps script

Question

Is there a method or way of identifying the last edited sheet in a Google Spreadsheet using Google Apps Script?

Answer 1

You would have checked the official documentation and found that no such method exists.

To accomplish this, you would need to write a proactive script to:

• Use an onEdit() trigger function to identify the occurrence and source of edits.
• Record the details in a non-volatile store; perhaps another spreadsheet.
• Respond to queries about the last edited sheet.