Create, edit and collaborate better with these Google Sheets tips and tricks

Modified 29 November 2018 by Vicki Rayner

Working on an important Doc and waiting on some feedback? See which of your collaborators have opened your file in your Activity dashboard

In Google Docs, Sheets, and Slides you can see when your file was last viewed and by who. Giving you the important information of who you need to chase.

Here’s how you can see who’s viewed your file

  1. In Docs, Sheets, or Slides, open your file.
    Note: You will need to have edit access for the file to see the Activity dashboard data.
  2. Click Tools > Activity dashboard.
  3. You can see information about the activity on your file, including:
  • Shared with tab: People you’ve shared the file with.
  • All viewers (organisation) tab: People in your organisation who have viewed the file.
  • Viewer trend tab: A chart of viewers over time.
  1. (Optional) If you don’t want your view history to appear in Activity dashboard, click Privacy Settings and choose an option:
  • Turn off view history for all files: Under Account setting, turn off Show my view history for all Docs, Sheets and Slides files.
  • Turn off view history for one file: Under Document setting, turn off Show my view history for this document.
  1. Click Save.

You can email the collaborators from within the Activity dashboard by simply ticking the send email box next to someone’s name.

Note: This feature is available for G Suite Business and Enterprise users only (when G Suite administrator permissions allow).