Pack Building Blocks
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!
ThreadCount()
Returns the count of email threads in your Gmail account that match the specified Gmail search term.
account: The Gmail account used to pull in this data.
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
Threads()
Returns email threads that match the provided search term.
account: The Gmail account used to pull in this data.
Example:
)
MessageCount()
Returns the count of emails in your Gmail account that match the specified Gmail search term.
account: The Gmail account used to pull in this data.
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:
) = 143
MessageCount(account, "label:inbox has:red-bang") = 3
MessageCount(account, "label:draft is:unread") = 5
Messages()
Returns emails that match the provided search term.
account: The Gmail account used to pull in this data.
Example:
)
Up Next: Resources and Templates 👉
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.