Gmail Messages

The Gmail Messages extractor allows you to fetch data from your Gmail account.

Configuration

Create a new configuration of the Gmail Messages extractor. Then click Authorize Account to authorize the configuration. Your inbox is accessed as read only.

Fill in the form to fit your needs.

Query – Query to filter your messages. To speed up the extraction, be as specific as possible. For more detailed information about querying, follow Google’s Advanced search help site.
Headers (optional) – Headers you want to download. If no headers are specified, all headers will be downloaded.

Don’t forget to Save the configuration.

Data are always imported incrementally. The extractor produces several tables that can be joined together.

Queries and their messages; it is good to know which query a message came from.

query	messageId
`from:some.address@example.com`	`9876cbd54bd215a6`
`from:another.address@example.com`	`1234abcd2ffdc1d6`

A base table of messages:

id	threadId
`9876cbd54bd215a6`	`1234abcd2ffdc1d6`
`1234abcd2ffdc1d6`	`1234abcd2ffdc1d6`

Tip: You can group your messages to conversations with GROUP BY threadId.

All downloaded headers:

messageId	name	value
`1234abcd2ffdc1d6`	`From`	`News <some.address@example.com>`
`1234abcd2ffdc1d6`	`Subject`	`Trending News`

All downloaded message parts:

messageId	partId	mimeType	bodySize	bodyData
`1234abcd2ffdc1d6`	`0`	`text/plain`	`26`	`Lorem ipsum dolor sit amet`
`1234abcd2ffdc1d6`	`1`	`text/html`	`33`	`<p>Lorem ipsum dolor sit amet</p>`

Note: Only parts with text/plain and text/html mime types are downloaded.