Gallery
Denis's Coda Playground
Share
Explore
Gallery
Denis's Coda Playground
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:
Search operators you can use with Gmail - Gmail Help
⁠
⁠
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:
Search operators you can use with Gmail - Gmail Help
⁠
⁠
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:
Search operators you can use with Gmail - Gmail Help
⁠
⁠
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:
Search operators you can use with Gmail - Gmail Help
⁠
⁠
maxResults: The maximum number of threads to return.
Example:
Messages(account, "is: starred", 20)

⁠

Up Next: Resources and Templates 👉

⁠
Resources
Gmail Pack templates and Coda resources to explore. Try them out them to use in your own docs.
⁠
⁠

⁠


Load content from tally.so?
Loading external content may reveal information to 3rd parties. Learn more
Allow
Gallery
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.