📖 2 mins read

Schedule Reports for Top Email Senders and Receivers in Gmail

This post will show you how GAT+ can generate a report of all email activity for each user.

The report can be scheduled daily, weekly, or monthly and will be generated in the form of a spreadsheet that can be sorted by the desired column.

The report will cover both internal and external emails.

Find emails

To start building this scheduled report the Admin should go to:

GAT+  then navigate  Emails audit

  • Select the ‘User statistics’ from the top menu
  • Choose Type (Stats by Date range and Users)
  • Time period – Date From and Date to
  • User/Group/OU for the report to run against. 
GAT+: How to Schedule Reports for Top Email Senders and Receivers 1

Schedule report

From there, select the ‘Scheduled’ button. It will open extra fields to be filled, such as “Enabled” to enable the report, then choose the ‘Occurrence’ in this case we select daily (Every day -After midnight), then ‘Apply & Schedule. 

GAT+: How to Schedule Reports for Top Email Senders and Receivers 2

For the daily report, select as a schedule ‘Every day – after midnight’ or choose weekly, monthly, or a custom Cron period.

You may also add additional email recipients for the report.

Result 

The Admin will be emailed a link to the spreadsheet

The generated spreadsheet will display:

  • Statistics of all emails sent and received by members of the searched group/OU.
  • Stats for how many emails they have sent and received from their account whether it was sent from Email or Group they use.
GAT+: How to Schedule Reports for Top Email Senders and Receivers 3

Admin can then sort the Spreadsheet to display by the number of emails sent and received, by each individual user. 

A new spreadsheet will be created every day, cover the previous day.

An example of the spreadsheet output looks like this.

GAT+: How to Schedule Reports for Top Email Senders and Receivers 4

Freeze row 1 and then select any column of interest,  finally sort the sheet based on that column in the Z to an order to bring the largest numbers to the top.

Top emails – by Email Content Search

There is also another way to find Top Email sender and receivers.

In Email audit – select ‘Email Content search’, (this is a real-time Gmail search).
In this example, we are searching for all emails in our domain “/” including sub-OUs.

We search for emails ‘newer_than:2d’ – Admin can use any other search parameter (examples from the same line ‘small arrow on the right-hand side’) 

GAT+: How to Schedule Reports for Top Email Senders and Receivers 5

Select ‘Search emails’ this will start a search.

When the result is displayed simply click on the “Sender/Receiver” option from the top bar. 

Here an Admin can sort each of the fields.

See top Internal and External Email senders and receivers on your domain.

Each of the tables can be exported into a spreadsheet.

GAT+: How to Schedule Reports for Top Email Senders and Receivers 6

This is very useful if, for example, your managers want a list of all emails sent and received by your users in a certain period of time.

To see who received and sent what amount of emails.

 

If you would like to run a trial of our products please install GAT+ from the Google Workspace Marketplace and contact us at support@gatlabs.com with any questions you may have.

To request a demo please click here and fill the form, we will get back to you in less than 12 hours during weekdays.

If you trailed GAT in the past and you would like to run a fresh trial again, please enquire through this form.

Thanks for sharing and spreading the word!