Gallery
Getting started with the Gmail Pack
Share
Explore
Pack Building Blocks

icon picker
Gmail Formulas

Formulas that take your Gmail account and optional search criteria.
The Gmail Pack offers four formulas to grab Threads and Thread counts, and Messages and Message counts from your inbox based on specific filter criteria. Try adding them to your table columns to bring in specific inbox results!
bobbin

ThreadCount()

Returns the count of email threads in your Gmail account that match the specified Gmail search term.
Required inputs
account: The Gmail account used to pull in this data.
Optional inputs
search: The search terms. You can leave this blank to return everything, or use any valid Gmail search, like "is: important"
💡 Hint: For a list of available options, see:
Example:
ThreadCount(account, "label:inbox") = 41
ThreadCount(account, "label:inbox has:red-bang") = 3
ThreadCount(account, "label:draft is:unread") = 5
needle

Threads()

Returns email threads that match the provided search term.
Required inputs
account: The Gmail account used to pull in this data.
Optional inputs
search: The search terms. You can leave this blank to return everything, or use any valid Gmail search, like "is: important" 💡 Hint: For a list of available options, see:
maxResults: The maximum number of threads to return.
Example:
Threads(account, "is: important", 10)
gmail-login

MessageCount()

Returns the count of emails in your Gmail account that match the specified Gmail search term.
Required inputs
account: The Gmail account used to pull in this data.
Optional inputs
search: The search terms. You can leave this blank to return everything, or use any valid Gmail search, like "is: important"
💡 Hint: For a list of available options, see:
Example:
MessageCount(account, "label:inbox") = 143
MessageCount(account, "label:inbox has:red-bang") = 3
MessageCount(account, "label:draft is:unread") = 5
gmail

Messages()

Returns emails that match the provided search term.
Required inputs
account: The Gmail account used to pull in this data.
Optional inputs
search: The search terms. You can leave this blank to return everything, or use any valid Gmail search, like "is: important" 💡 Hint: For a list of available options, see:
maxResults: The maximum number of threads to return.
Example:
Messages(account, "is: starred", 20)

Up Next: Resources and Templates 👉



Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.