How to create detailed logs for scripts in Google Sheets documents?

You can view the execution logs of the script running on a Google Sheets document using the Google Apps Script console.

1 - From the top menu, click on Extensions > Apps Script.

2 - Make sure that the 'Execution log' button is pressed, 

3 - Click the 'Run' button to manually trigger the script.

4 - Finally, get screenshots of messages displayed in the 'Execution log' section at the bottom of the page. Please note that there might be many messages so you might need to take multiple screenshots to cover them all.