The Gmail Messages extractor allows you to fetch data from your Gmail account.
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.
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.