How to show total number of emails in my gmail in google sheets cell
I want to show the total number of emails in my gmail (not unread emails) total number of emails. I want to show the number in one of my Google sheets cells.
How to do that?
gmail-api
add a comment |
I want to show the total number of emails in my gmail (not unread emails) total number of emails. I want to show the number in one of my Google sheets cells.
How to do that?
gmail-api
add a comment |
I want to show the total number of emails in my gmail (not unread emails) total number of emails. I want to show the number in one of my Google sheets cells.
How to do that?
gmail-api
I want to show the total number of emails in my gmail (not unread emails) total number of emails. I want to show the number in one of my Google sheets cells.
How to do that?
gmail-api
gmail-api
asked Nov 17 '18 at 20:02
Mohamed IrshaidMohamed Irshaid
315
315
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You can try getting the messagesTotal
property of Users: getProfile. This property gets the total number of messages in the mailbox.
HTTP request
GET https://www.googleapis.com/gmail/v1/users/userId/profile
Response
{
"emailAddress": string,
"messagesTotal": integer,
"threadsTotal": integer,
"historyId": unsigned long
}
add a comment |
One way I've tried to know the total number of emails I have is: opened my Gmail in a web browser, then just above the section that lists the first (50 or 100) mails, there's a checkbox. Clicking it will select all the emails on the current page.
A message appears below the checkbox section saying All 50 conversations on this page are selected. Select all {{number}} conversations in primary.
Now that {{number}} is the number of all the emails (read & unread) in your primary
inbox. Do same for social
and promotions
tabs and add them up.
That's it if that's what you are asking.
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53355060%2fhow-to-show-total-number-of-emails-in-my-gmail-in-google-sheets-cell%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can try getting the messagesTotal
property of Users: getProfile. This property gets the total number of messages in the mailbox.
HTTP request
GET https://www.googleapis.com/gmail/v1/users/userId/profile
Response
{
"emailAddress": string,
"messagesTotal": integer,
"threadsTotal": integer,
"historyId": unsigned long
}
add a comment |
You can try getting the messagesTotal
property of Users: getProfile. This property gets the total number of messages in the mailbox.
HTTP request
GET https://www.googleapis.com/gmail/v1/users/userId/profile
Response
{
"emailAddress": string,
"messagesTotal": integer,
"threadsTotal": integer,
"historyId": unsigned long
}
add a comment |
You can try getting the messagesTotal
property of Users: getProfile. This property gets the total number of messages in the mailbox.
HTTP request
GET https://www.googleapis.com/gmail/v1/users/userId/profile
Response
{
"emailAddress": string,
"messagesTotal": integer,
"threadsTotal": integer,
"historyId": unsigned long
}
You can try getting the messagesTotal
property of Users: getProfile. This property gets the total number of messages in the mailbox.
HTTP request
GET https://www.googleapis.com/gmail/v1/users/userId/profile
Response
{
"emailAddress": string,
"messagesTotal": integer,
"threadsTotal": integer,
"historyId": unsigned long
}
answered Nov 19 '18 at 6:32
JacqueJacque
3216
3216
add a comment |
add a comment |
One way I've tried to know the total number of emails I have is: opened my Gmail in a web browser, then just above the section that lists the first (50 or 100) mails, there's a checkbox. Clicking it will select all the emails on the current page.
A message appears below the checkbox section saying All 50 conversations on this page are selected. Select all {{number}} conversations in primary.
Now that {{number}} is the number of all the emails (read & unread) in your primary
inbox. Do same for social
and promotions
tabs and add them up.
That's it if that's what you are asking.
add a comment |
One way I've tried to know the total number of emails I have is: opened my Gmail in a web browser, then just above the section that lists the first (50 or 100) mails, there's a checkbox. Clicking it will select all the emails on the current page.
A message appears below the checkbox section saying All 50 conversations on this page are selected. Select all {{number}} conversations in primary.
Now that {{number}} is the number of all the emails (read & unread) in your primary
inbox. Do same for social
and promotions
tabs and add them up.
That's it if that's what you are asking.
add a comment |
One way I've tried to know the total number of emails I have is: opened my Gmail in a web browser, then just above the section that lists the first (50 or 100) mails, there's a checkbox. Clicking it will select all the emails on the current page.
A message appears below the checkbox section saying All 50 conversations on this page are selected. Select all {{number}} conversations in primary.
Now that {{number}} is the number of all the emails (read & unread) in your primary
inbox. Do same for social
and promotions
tabs and add them up.
That's it if that's what you are asking.
One way I've tried to know the total number of emails I have is: opened my Gmail in a web browser, then just above the section that lists the first (50 or 100) mails, there's a checkbox. Clicking it will select all the emails on the current page.
A message appears below the checkbox section saying All 50 conversations on this page are selected. Select all {{number}} conversations in primary.
Now that {{number}} is the number of all the emails (read & unread) in your primary
inbox. Do same for social
and promotions
tabs and add them up.
That's it if that's what you are asking.
answered Nov 17 '18 at 20:28
Abubakar SamboAbubakar Sambo
286
286
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53355060%2fhow-to-show-total-number-of-emails-in-my-gmail-in-google-sheets-cell%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown