Access Gmail in Excel

Data results output in Excel

All Items

Use the following functions to extract the ids for each item group:

  • Mails
  • Threads
  • Labels


When you have the ids, use this function to extract detailed statistics about items. In the example above, a formula is used to extract the latest mail sent to and from an inbox.

Have I sent/recieved?

SeoTools provides two functions to check if your account has either sent an email to, or recieved an email from a particular address. The Query parameter supports both complete email addresses or search inputs. Available filters:

  • Time period


Add from Manager

The Gmail Connector is available in the Connectors Manager in the top ribbon:
Manager position in main ribbon

Head over to the Email Category and install Gmail :
Connector category in Manager window

To use the Connector you need an account connected to Gmail.

  1. The Connector is located under the Others -> Mail Category in SeoTools main ribbon. Click on Login.Logging in with your account

  2. Select your preferred account and click on Allow.


This connector suite is open-sourced on GitHub.


Official Documentation


Get help with this function in the community →